create proc pro_text @sql varchar(100)
as begin
declare @sqlStr varchar(8000)
set @sqlStr='select * from '
set @sqlStr'declare cur_ABC scroll cursor for select ……… from '+ +@sql+'where ………………' ----注:定义游标并将参数传进去
exec(@sqlStr)
open cur_ABC
fetch first from cur_ABC into …………
while (@@fetch_status <> -1)
create proc pro_text @sql varchar(100)
as begin
declare @sqlStr varchar(8000)
set @sqlStr='select * from '
set @sqlStr'declare cur_ABC scroll cursor for select ……… from '+ +@sql+'where ………………' ----注:定义游标并将参数传进去
exec(@sqlStr)
open cur_ABC
fetch first from cur_ABC into …………
while (@@fetch_status <> -1)
fetch next from cur_updatebasicdata into………………
.
.
.
.
--你可以把固定的语句段写在过程里,举个简单的例子:
create proc pro_text @sql varchar(100)
as begin
declare @sqlStr varchar(8000)
set @sqlStr='select * from '
set @sqlStr=@sqlStr+@sql
exec(@sqlStr)
end
--执行以下这句:
pro_text 'table1'
即可查询表table1里的所有记录