CREATE PROCEDURE up_InfoShow
(
@uctrlType varchar(20)
)
AS
declare @LinkmanTel_One varchar(20),
@strSql nvarchar(4000)
begin transaction
set @strSql=N'select top 1 @LinkmanTel_One=LinkmanTel from ' + @uctrlTypeexec sp_executesql @strSql,N'@LinkmanTel_One varchar(20) output',@LinkmanTel_One output
(
@uctrlType varchar(20)
)
AS
declare @LinkmanTel_One varchar(20),
@strSql nvarchar(4000)
begin transaction
set @strSql=N'select top 1 @LinkmanTel_One=LinkmanTel from ' + @uctrlTypeexec sp_executesql @strSql,N'@LinkmanTel_One varchar(20) output',@LinkmanTel_One output
[交流]动态SQL语句
select top 1 @LinkmanTel_One=LinkmanTel from @uctrlType
不可以直接执行是因为表名是变量,直接执行的SQL中表名不可以为变量