摘要：
/****** Script for SelectTopNRows command from SSMS ******/alter PROCEDURE QueryWeight @myResult NVARCHAR(MAX) OUTPUTASBEGINIF((SELECT COUNT(column_name) FROM myWeight WHERE fname = '曲宗雪' and 查看 = '1') < 2)BEGINSET @myResult = (SELECT column_name FROM myWeight WHERE fname = '曲 阅读全文
摘要：
declare @objid int,@objname char(40)set @objname = 'dbo.MyTestView'select @objid = id from sysobjects where id = object_id(@objname)select FID,FName ,'Column_name' = name ,'' AS 查看 ,'' AS 更新 ,'' AS 删除 ,'' AS 新增 into MyWeight from syscolumns,MyWorker wh 阅读全文