How to Set Variable from a Sql Query?

James H. Sterling
James H. Sterling
• • 4 min read

I'm Trying to Set a Variable from a Sql Query: Declare @Modelid Uniqueidentifer Select @Modelid = Select Modelid from Models Where Areaid = 'South Coast'...

How to Set Variable from a Sql Query?

I'm trying to set a variable from a SQL query:

declare @ModelID uniqueidentifer

Select @ModelID = select modelid from models
where areaid = 'South Coast'

Obviously I'm not doing this right as it doesn't work. Can somebody suggest a solution?

Thanks!

2

9 Answers

Must Read

Using SELECT

SELECT @ModelID = m.modelid 
  FROM MODELS m
 WHERE m.areaid = 'South Coast'
James H. Sterling

James H. Sterling

Environmental Science & Climate Journalist
Twitter Linkedin

James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.