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.
| Author |
Topic |
|
Informer30
Starting Member
26 Posts |
 Posted - 2011-06-14 : 10:52:31
|
| Hi All,please can advise what the following code does?cast(# as varchar(30))Many Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-14 : 11:00:12
|
It generates a nice syntax error.  |
 |
|
|
Informer30
Starting Member
26 Posts |
Posted - 2011-06-14 : 11:13:41
|
| Rob, even I know that.....I need to know what the # does? I now understand the rest....Thanks |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-14 : 11:25:11
|
| The # in this case specifies an identifier, which doesn't exist, and therefore causes the syntax error. If it's an example from somewhere, my guess is it's supposed to represent a number of some kind. |
|
|
|
Informer30
Starting Member
26 Posts |
Posted - 2011-06-14 : 11:33:53
|
| Yep it is an example...Thanks Rob |
|
|
|
|
|
|
Code Understanding