STR1="DELETE FROM "& BBB &"_GZSPDZ WHERE exists" & _
"(select f_qlhl from rhz2 where f_lsdbm=f_qlhl and f_cd<'"& qq &"')"1.上述语句中 BBB 与 qq 均为变量本来是在VB程序中直接执行的,但现在想把它
转为存储过程,如何写?2.转为存储过程后,VB如何调用?
"(select f_qlhl from rhz2 where f_lsdbm=f_qlhl and f_cd<'"& qq &"')"1.上述语句中 BBB 与 qq 均为变量本来是在VB程序中直接执行的,但现在想把它
转为存储过程,如何写?2.转为存储过程后,VB如何调用?
(@BBB Varchar(50),
@qq Varchar(50)
As
Begin
Declare @S Varchar(8000)
Select @S = 'DELETE FROM ' + @BBB + '_GZSPDZ WHERE exists (select f_qlhl from rhz2 where f_lsdbm=f_qlhl and f_cd<''' + @qq +''')'
EXEC(@S)
End
GO
--調用
EXEC SP_DELETE 'AAA', 'BBBB'
as
begin
exec('delece from '+@tname+'_GZSPDZ WHERE exists (select f_qlhl from rhz2 where f_lsdbm=f_qlhl and f_cd<'''+@qq+''')')
end
(@BBB Varchar(50),
@qq Varchar(50))
As
Begin
Declare @S Varchar(8000)
Select @S = 'DELETE FROM ' + @BBB + '_GZSPDZ WHERE exists (select f_qlhl from rhz2 where f_lsdbm=f_qlhl and f_cd<''' + @qq +''')'
EXEC(@S)
End
GO
--調用
EXEC SP_DELETE 'AAA', 'BBBB'
as
declare @str1 varchar(8000)
select @str1='DELETE FROM '+ @BBB +'_GZSPDZ WHERE exists (select f_qlhl from rhz2 where f_lsdbm=f_qlhl and f_cd<'''+@qq+''')'
exec(@str1)