--ALTER PROCEDURE GetData @tbName nvarchar(10), @colName nvarchar(10), @Name nvarchar(10)
--AS BEGIN
--declare @sql nvarchar(50);
-- set @sql='select '+ @colName+' from ' +@tbName+ ' where colName1=@whereName';
-- --注意此句不可以写成如下: -- set @sql='select @colName from @tbName where name=@whereName';
--exec sp_executesql @sql, N'@whereName nvarchar(10)' , @whereName
--end
CREATE PROCEDURE [dbo].[GetData2] @tbName nvarchar(10), @topnum nvarchar(10)
AS BEGIN
declare @sql nvarchar(50);
set @sql=N'select top '+ @topnum +' * from ' +@tbName;
--注意此句不可以写成如下: -- set @sql='select @colName from @tbName where name=@whereName';
exec sp_executesql @sql
END
GO
