我正在尝试从SQL查询设置一个变量:
declare @ModelID uniqueidentifer
Select @ModelID = select modelid from models
where areaid = 'South Coast'
很明显,我做得不对,因为它不起作用。有人能给出一个解决方案吗?
谢谢!
发布于 2010-10-20 12:04:24
SELECT @ModelID = modelid
FROM Models
WHERE areaid = 'South Coast'
如果select语句返回多个值,则会为变量分配返回的最后一个值。
有关在变量中使用SELECT的参考信息:http://msdn.microsoft.com/en-us/library/aa259186%28SQL.80%29.aspx
发布于 2016-05-18 17:04:58
declare @ModelID uniqueidentifer
--make sure to use brackets
set @ModelID = (select modelid from models
where areaid = 'South Coast')
select @ModelID
发布于 2017-12-06 19:10:29
我更喜欢在declare语句中设置它
DECLARE @ModelID uniqueidentifer = (SELECT modelid
FROM models
WHERE areaid = 'South Coast')
https://stackoverflow.com/questions/3974683
复制相似问题