我如何为SQL Server中的变量赋值 [英] How I can assign value to a variable in SQL Server
本文介绍了我如何为SQL Server中的变量赋值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
BEGIN TRY
SET @ SQL = ' SELECT' + @ PAIDSTATUS + ' = PAIDSTATUS FROM' + @ DATABASES + ' 。DBO.sometablename WHERE ROLLNO =''' + @ ROLLNO + ' '''
SELECT @ PAIDSTATUS
PRINT ( @ PAIDSTATUS )
EXEC ( @ SQL )
IF (@PAIDSTAT US!= ' Y')
SET @ ERROR_MSG = ' 您尚未注册'
END TRY
BEGIN CATCH
RAISERROR ( @ ERROR_MSG , 1 , 1 )
END CATCH
我想要@paidstatus的价值所以我可以进一步操纵那个变量..
感谢您的帮助..
解决方案
hi,
试试这个
声明 @ PAIDSTATUS as varchar 跨度>(<温泉n class =code-digit> 10 )
SELECT @ PAIDSTATUS = PAIDSTATUS FROM table_name WHERE ROLLNO = 1
BEGIN TRY
SET @SQL = 'SELECT ' + @PAIDSTATUS + ' = PAIDSTATUS FROM '+ @DATABASES +'.DBO.sometablename WHERE ROLLNO=''' + @ROLLNO +''''
SELECT @PAIDSTATUS
PRINT (@PAIDSTATUS)
EXEC (@SQL)
IF (@PAIDSTATUS!='Y')
SET @ERROR_MSG='You are not registered'
END TRY
BEGIN CATCH
RAISERROR(@ERROR_MSG,1,1)
END CATCH
I want value of @paidstatus so that I can manipulate that variable further..
Thanks for help..
解决方案
hi,
try this
declare @PAIDSTATUS as varchar(10) SELECT @PAIDSTATUS = PAIDSTATUS FROM table_name WHERE ROLLNO=1
这篇关于我如何为SQL Server中的变量赋值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文