Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Question on (@) sytax

Author  Topic 

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2008-09-30 : 09:15:09
simple one for you guys.

what does the @ do or mean when it is at the begining of a column name?

can someone give an example please

Regards

Rob

MCTS certified

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-09-30 : 09:18:51
It means it is a variable/parameter

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-09-30 : 09:22:22
1) Can be part of a XML query. @ is meant for attribute values.
2) Can be part of a really weird column name
3) Can be a hard-wired value for the column

May we see your code?



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2008-09-30 : 09:26:10
Hello Peso

I have no code or project im working on.

Im just learning SQL as Im going through an MCITP course

MCTS certified
Go to Top of Page
   

- Advertisement -