...bringing you notes from the field...
  • News
  • Copyright © 2008-2011 Paula DiTallo

Tag Cloud


How do I select a value from a table into a variable in SQL Server?

Here's an example...

DECLARE @LocID

SELECT @LocID = LocationID
 FROM Locations
  WHERE LocationName = 'WAREHOUSE X'


  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Thursday, March 26, 2009 7:13 AM | Feedback (0)