下面將為您介紹sql變量從select,insert獲取值的單值情況及記錄集情況的操作，供您參考，希望對(duì)您學(xué)習(xí)sql變量會(huì)有所幫助。

use Northwind

--整形sql變量的賦值

declare @addr int
set @addr = (select sum(power(2,cast(EmployeeID as integer))) as addr from employees )
print '員工id的平方和為：'+cast(@addr as varchar(10))

--浮點(diǎn)數(shù)sql變量的賦值

declare @total float
set @total = (select sum(freight) as freight from Orders)
print '所有商品的總運(yùn)費(fèi)為：'+cast(@total as varchar(10))

--記錄集sql變量的賦值

declare @tb table(id int,name varchar(20),country varchar(20))
insert into @tb select employeeid,firstname+' '+lastname,country from employees
select * from @tb
select a.name,b.customerId,b.freight from @tb a,orders b where a.id=b.employeeid

關(guān)鍵點(diǎn)：?jiǎn)沃登闆r下，select一定要用括號(hào)

【編輯推薦】

Transact-SQL變量的聲明

設(shè)置Transact-SQL變量中的值

SQL變量定義賦值及調(diào)用

教您使用SQL參數(shù)變量來傳遞記錄值

SQL中的指示變量及數(shù)組變量