Thursday, November 1, 2012

How to select description of a column in SQL Server



If a Column in data base table contains description about that column.

then select statement is like this
syntax:

Select objname,Name,value from ::fn_listextendedproperty('MS_Description','user','dbo-name','table','table-name','column',column-name').
 

No comments:

Post a Comment

amazon

Sukanya Samriddhi Account - SBI

SUKANYA SAMRIDDHI Account information by SBI SUKANYA SAMRIDDHI ACCOUNT : FACILITY AVAILABLE AT ALL BRANCHES OF SBI Sukanya Samriddhi ...