摘要：use testgo--生成測試臨時表#if not object_id('Tempdb..#')is null drop table #select top 35 [Name]=cast( [Name] as nvarchar(50)) into # from s... 阅读全文

摘要：十进制转换为十八进制create function F_int18(@num int)returns nvarchar(50)asbeginif @num=0 return '0'declare @s nvarchar(50)set @s=''while @num>0 select @s=subst 阅读全文

摘要：---生成测试表Tif exists(select 1 from sysobjects where Name=N'T' and objectProperty(ID,N'IsUserTable')=1) drop table Tgoselect top 5 ID,Name into T fr... 阅读全文