Ask Paula!

...bringing you notes from the field...
posts - 55, comments - 17, trackbacks - 0

My Links

News

Article Categories

Archives

Post Categories

.NET Development

Enterprise Integration

Java Development

Mobile/PDA Development

Professional Affiliations

Thursday, March 26, 2009

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'

posted @ Thursday, March 26, 2009 7:13 AM | Feedback (0) | Filed Under [ SQL ]

Powered by:

Copyright © Paula DiTallo 2007-2009 All Rights Reserved