SQL: Local variables | um what now?

SQL: Local variables

July 15 2010 by Ryan Carter in SQL |No Comments

     DECLARE @var1 VARCHAR(50)
     SET @var1 = 'hello'

Then you can use it in your SELECT (and other) statements later, like this:

   SELECT * FROM tablename WHERE welcomemessage = @var1

Tags: @variable, local, SQL, variables

Leave a Reply

You must be logged in to post a comment.