摘要:
禁用: ALTER TABLE trig_example DISABLE TRIGGER trig1 GO 恢复: ALTER TABLE trig_example ENABLE TRIGGER trig1 GO ------------------------------------------... 阅读全文
摘要:
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 阅读全文
摘要:
ALTER FUNCTION getPinYin(@HZ NVARCHAR(4000))RETURNS NVARCHAR(4000)ASBEGINDECLARE @word NCHAR(1)DECLARE @PY NVARCHAR(4000)SET @PY = ''WHILE LEN(@HZ) > 0 BEGIN SET @word = LEFT(@HZ,1) SET @PY = @PY + (CASE WHEN UNICODE(@word) BETWEEN 19968 AND 19968+20901 THEN (SELECT TOP ... 阅读全文