摘要： select b.[value]from sys.columns a left join sys.extended_properties b on a.object_id = b.major_id and a.column_id = b.minor_id inner join sysobjects c on a.column_id = c.id and a.[name] = '列名' and c.[name] = '表名'select 表名 = case when a.colorder = 1 then d.name el... 阅读全文

摘要： create procedure aaaasdeclare @a intset @a=12 raiserror('状态已发生改变,或许其它用户做了更改!',16,-5)select @areturn -45--这里不显示指定的话，如里没有错误刚返回0，反之为负数declare @b intexec @b=aaaselect @bdrop procedure aaa 阅读全文