fw_br的专栏

sqlserver判断库、表、列、临时表、存储过程、视图、函数是否存在的sql

CREATE function Clear_Numberic_LastO(@inValue varchar(50)) returns varchar(50) as begin declare @returnValue varchar(20) if(@inValue='') set @returnValue='' --空的时候为空 else if (charindex('.',@inValue

DECLARE @s VARCHAR (MAX) SELECT @s = ',' + CAST (kindid AS VARCHAR(20)) + '' FROM treetable WHERE kindid = '25' WHILE @@ROWCOUNT > 0 SELECT @s =@s + ','