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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Aggregation Aggravation
 Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

Xerxes
Aged Yak Warrior

USA
666 Posts

Posted - 08/25/2005 :  13:06:30  Show Profile  Reply with Quote
Back to my original question....the 't' can be anything. Could someone confirm this?

Semper fi,
XERXES, USMC(Ret.)
------------------------------------------------------
The Marine Corps taught me everything but SQL!
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11752 Posts

Posted - 08/25/2005 :  13:09:49  Show Profile  Visit spirit1's Homepage  Reply with Quote
consider it confirmed.
EDIT:
and if you put [] around it then it can really be anything...

Go with the flow & have fun! Else fight the flow

Edited by - spirit1 on 08/25/2005 13:11:11
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

USA
3246 Posts

Posted - 08/25/2005 :  17:17:02  Show Profile  Visit AjarnMark's Homepage  Reply with Quote
Or at least anything that meets the requirements for SQL Server identifiers (e.g. cannot start with a number, etc.)

---------------------------
EmeraldCityDomains.com
Go to Top of Page

Xerxes
Aged Yak Warrior

USA
666 Posts

Posted - 08/25/2005 :  17:41:23  Show Profile  Reply with Quote
But Mladen (spirit1) asserts that anything within [ ] is acceptable!

Semper fi,
XERXES, USMC(Ret.)
------------------------------------------------------
The Marine Corps taught me everything but SQL!

Edited by - Xerxes on 08/25/2005 17:41:48
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 08/25/2005 :  17:45:22  Show Profile  Reply with Quote
You could always just test it yourself
select 
	[!@#$%^&*()_+{}:"<>?|\/qwertyuiopasdfghjklzxcvbnm1234567890].id
from
	sysobjects [!@#$%^&*()_+{}:"<>?|\/qwertyuiopasdfghjklzxcvbnm1234567890]


CODO ERGO SUM
Go to Top of Page

Xerxes
Aged Yak Warrior

USA
666 Posts

Posted - 08/25/2005 :  18:33:29  Show Profile  Reply with Quote
Gee, Kernel Jones, that just ruins the fun!

Semper fi,
XERXES, USMC(Ret.)
------------------------------------------------------
The Marine Corps taught me everything but SQL!
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000