Link to home
Start Free TrialLog in
Avatar of SPLady
SPLady

asked on

Tsql select statement

What does it mean when a select statement has a @?
for example

Select @column1, @column2
From table1
Avatar of IceCode
IceCode
Flag of United States of America image

"The @CustID means it's a parameter that you will supply a value for later in your code. This is the best way of protecting against SQL injection. Create your query using parameters, rather than concatenating strings and variables. The database engine puts the parameter value into where the placeholder is, and there is zero chance for SQL injection."

From

http://stackoverflow.com/questions/361747/what-does-the-symbol-do-in-sql
An identifier beginning with the "at" sign denotes a local variable or parameter.
ASKER CERTIFIED SOLUTION
Avatar of skrga
skrga
Flag of Croatia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial