Jeff Moden (5/1/2008)
Michael Valentine Jones (5/1/2008)
Jeff Moden (5/1/2008)
Michael Valentine Jones (5/1/2008)
It's probably better to avoid using a reserved word, like INDEX, for a table name.Or "number" or "sequence" or... that's all part of the reason why I use "Tally". 😉
NUMBER is not a reserved word. Maybe you are thinking of NUMERIC?
SEQUENCE is not a reserved word in 2005, but is listed as a future reserved word in 2005 BOL.
Not in SQL Server it's not... 😛 You think SQL Server is the only place I use such a thing? Heh... most folks get on me because I don't really don't give a hoot about portability but the one place I do... wham! :hehe:
Ah, but "NUMBERS" is not a reserved word anywhere that I know of. Given that you've already caved on your "No Portability, Anywhere, Ever!" 😀 stand, do you think that you could give on your "No Plurals" stand for tables?
🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]