摘要:
select a.name,case a.precision when 0 then case a.is_ansi_padded when 1 then convert(nvarchar(15),b.name+ '('+convert(nvarchar(10),a.max_length)+')') when 0 then b.name end else case a.scale when 0 then b.name else b.name+ '('+convert(nvarchar(10),a.precision)+','+con 阅读全文
摘要:
declare @UserName varchar(400)declare @EM varchar(400)declare pcurr cursor for select UserName, ErrorMessage from ErrorLogopen pcurr fetch next from pcurr into @UserName,@EMwhile (@@fetch_status = 0) begin --set @Str=@Str+@ProductName print @UserName print @EM fetch next from pcurr into @User... 阅读全文