开发者

what is sqlserver database remark returned fom sp_databases?

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜