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 |
|
real_pearl
Posting Yak Master
106 Posts |
 Posted - 2004-07-01 : 06:31:48
|
| WHat kind of names we can assign to columns? I mean a column name can be25th_pct?I have assigned to a temp table as '25th_pct' = 0 but when I select it i got an error invalid column name, please tell me why this error comes, and can we use digits in the column names? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-07-01 : 06:37:50
|
| you can but you have ho enclose it with [] -> [25th_pct]Go with the flow & have fun! Else fight the flow :) |
 |
|
|
real_pearl
Posting Yak Master
106 Posts |
Posted - 2004-07-01 : 07:06:21
|
Thanks  |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-07-04 : 14:09:26
|
| The reason is that the column name begins with a number.If You had for example: _25th_pct then [] would not be necessary !/rockmoose |
|
|
|
|
|
|
Column Naming Conventions