摘要:
一、生成九九乘法表 create function test()begin declare @a smallint, @b smallint, @str varchar(1000) set @a=1 while @a<=9 begin set @b=1 set @str='' while @b<=@ 阅读全文
摘要:
--建了一张表 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Bas_DateTime]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [d 阅读全文
摘要:
declare @a smallint, @b smallint, @str varchar(1000) set @a=1 while @a<=9 begin set @b=1 set @str='' while @b<=@a begin select @str=@str+convert(varch 阅读全文