MS SQL 在存储过程中怎样执行用变量组合的SQL语句

发布网友发布时间：2022-04-09 04:30

共3个回答

懂视网时间：2022-04-09 08:52

PROC Test_GetCollegeInfo @type int AS BEGIN DECLARE @where nvarchar(800),@v int,@sql nvarchar(max) IF @type>2 Begin SET @where=‘AND colleges.id=‘+cast(@type AS varchar(100)) END ELSE BEGIN SET @where=‘‘ END SET @sql=‘ SELECT * FROM collegeMajor INNER JOIN MajorsType ON collegeMajor.majorType=MajorsType.id INNER JOIN colleges ON colleges.id=collegeMajor.collageID WHERE 1=1 ‘+@where EXEC (@sql) End

Sql用变量拼语句

标签：

热心网友时间：2022-04-09 06:00

创建：
create procere p_1
as
declare @empcode nvarchar(10)
declare @result nvarchar(20)
begin
set @empcode='1001'
select @result=c_name from employee where empcode=@empcode
print @result
end

执行：exec p_1

热心网友时间：2022-04-09 07:18

动态sql拼接，大致上是这样：
declare @empcode nvarchar(10)
declare @sql_text nvarchar(100)
declare @result nvarchar(20)

set @empcode='1001'
set @sql_text='select c_name from employee where empcode='

select @sql_test=@sql_text+'''+@empcode+'''
exec(@sql_test)