拼接T-SQL语句字符串

create  procedure  procDelete
@iTtlTbls int,
@strPreTblName nvarchar(50)
as
declare @iIdx int ,@s nvarchar(500)
set @iIdx=0
while @iIdx <=@iTtlTbls
begin
  set @s='delete from '+@strPreTblName + ltrim(@iIdx)
  exec(@s)
  set @iIdx=@iIdx+1
end
go