Member Avatar for Suryaahh

Hi all,

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

  • 3 Contributors
  • 2 Replies
  • 69 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by cutepinkbunnies
Member Avatar for sknake

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..?

Member Avatar for cutepinkbunnies

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.