L u k e
جمعه 21 خرداد 1389, 10:16 صبح
مشکل این چیه ؟
می گه Must Declare the Scalar Variable @TblParam
می خوام کاربر مشخص کنه که از کدوم جدول رکورد پاک بشه و بره به همون جدول و Delete کنه
ALTER PROCEDURE DeleteCmd
@IdParam int,
@TagParam varchar(30),
@TblParam varchar(10)
as
begin
if @TblPram Like "Home" Delete FROM Home Where Id=@IdParam and Tag=@TagParam
if @TblParam Like "Download" Delete From Download Where Id=@IdParam and Tag=@TagParam
if @TblParam Like "Tutorial" Delete From Tutorial where Id=@IdParam and Tag=@TagParam
if @TblParam Like "Project" Delete FROM Project Where Id=@IdParam and Tag=@TagParam
end
می گه Must Declare the Scalar Variable @TblParam
می خوام کاربر مشخص کنه که از کدوم جدول رکورد پاک بشه و بره به همون جدول و Delete کنه
ALTER PROCEDURE DeleteCmd
@IdParam int,
@TagParam varchar(30),
@TblParam varchar(10)
as
begin
if @TblPram Like "Home" Delete FROM Home Where Id=@IdParam and Tag=@TagParam
if @TblParam Like "Download" Delete From Download Where Id=@IdParam and Tag=@TagParam
if @TblParam Like "Tutorial" Delete From Tutorial where Id=@IdParam and Tag=@TagParam
if @TblParam Like "Project" Delete FROM Project Where Id=@IdParam and Tag=@TagParam
end