开发者

what is sqlserver database remark returned fom sp_databases?

开发者 https://www.devze.com 2022-12-11 14:50 出处:网络
The sp_databases stored proc in sqlserver returns a remarks column.Where doe开发者_StackOverflow社区s this information come from, and can I edit it?This field always retuns null.You can not edit it, u

The sp_databases stored proc in sqlserver returns a remarks column. Where doe开发者_StackOverflow社区s this information come from, and can I edit it?


This field always retuns null. You can not edit it, unless you modify the system stored procedure which is not recommended.

See http://msdn.microsoft.com/en-us/library/aa259636(SQL.80).aspx


Simply run sp_helptext sp_databases and you'll see:

REMARKS   = convert(varchar(254),null)

It's a brand new NULL, manufactured just in time, for your convenience.

0

精彩评论

暂无评论...
验证码 换一张
取 消