摘要: 上学期还操作顺手的存储过程,这学期都忘了,而且忘得一干二净。再写一个存储过程:use Northwind go create proc test @StartOrderID int, @EndOrderID int, @Code varchar(1000) Out As Begin Declare @tmp int Set @Code='' Declare #cur_orders cursor for Select OrderID From Orders... 阅读全文
posted @ 2011-11-10 17:25 SOD_QWER 阅读(82) 评论(0) 推荐(0)
摘要: 上学期还操作顺手的存储过程,这学期都忘了,而且忘得一干二净。再写一个存储过程:use Northwind go create proc test @StartOrderID int, @EndOrderID int, @Code varchar(1000) Out As Begin Declare @tmp int Set @Code='' Declare #cur_orders cursor for Select OrderID From Orders... 阅读全文
posted @ 2011-11-10 17:25 SOD_QWER 阅读(101) 评论(0) 推荐(0)