摘要：1.使用游标 Use Master Declare My_cursor cursor for select name,number from dbo.spt_values where number=1 declare @sname varchar(50) declare @snumber varchar(50) open My_cursor fetch next from My_cursor... 阅读全文

摘要：1. 求x的y次方 declare @n int set @n=3 select power(2,@n) 2. 求x的平方 select Square(3) --2的3次方, 结果应该是8 3. 求x的平方根 select sqrt(4) --4的平方根是2 4. 求绝对值 select abs(-3) --结果是3 5. 阅读全文

摘要：use master go Alter database tempdb modify file (name = tempdev, filename = 'D:\tempdb.mdf') go Alter database tempdb modify file (name = templog, filename = 'D:\templog.ldf') go 阅读全文

摘要：Create procedure dbo.Second AS Begin declare @t as int print 'hello' End Create procedure dbo.First As Begin declare @sql as nvarchar(100) set @sql = 'Create procedure dbo.test AS Begin declare @t as... 阅读全文