就是:
SELECT @return_status as [Return Status]的意思,在查询器执行下列语句:
declare @return_status int
set @return_status=1
SELECT 'Return Status' = @return_status
SELECT @return_status as [Return Status]的意思,在查询器执行下列语句:
declare @return_status int
set @return_status=1
SELECT 'Return Status' = @return_status
如表TAB,有字段:COL1,COL2,COL3,则
select col1 as aa,col2 as bb,col3 as cc from tab
<==等同==>
select aa=col1,bb=col2,cc=col3 from tab
只是写法不同而已.
用于以'Return Status' 的名称显示变量@return_status 的值,只是一条输出语句