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

...bringing you notes from the field...

Tag Cloud

<< Why do I get the error: "General failure. The URL was: [http text]. The system cannot find file specified" When I click a link from an Outlook Message? | Home | The Wrong Program is Active when I double Click on a File. How Do I Change it Back? (AKA: How do I change My File Type Association?) >>

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:

posted @ Thursday, March 26, 2009 7:13 AM

Feedback

No comments posted yet.

Title:

Name:

Email: Not Displayed

Website:

Comment:

Enter the code shown above