Hi all,

I need a help regarding with the extraction of a single value from the specific field that contains the datatype nvarchar(MAX).

Recommended Answers

All 2 Replies

Are you wanting to do this one time or regularly.. and are you looking for a utility to do it or are you wanting to write an application? If you want to write something then what language are you developing in..?

Look through the metadata functions available in your database.

Specifically, the columnproperty() function looks like it may be of some use for you.

As suggested earlier the question was a bit vague. You might be looking for some of the functionality sp_help provides. In that case, you can peek through that procedure and modify some of its code in your procedure.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.