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 |
|
ujjaval
Posting Yak Master
108 Posts |
 Posted - 2007-05-06 : 01:41:58
|
Hello everyone,I have a sql file with bunch of statements like this:alter table [dbo].[TESTTABLE] add constraint DF_COL_A default ("?") for [COL_A]Now, these statements used to work on my database on SQL Server 2000 and SQL Server 7.0.But when I tested that with SQL Server 2005, it gave me error. And I had to replace double quotes with single quotes.And it worked fine. Does anyone have some article which explains this change in SQL Server 2005?Also, although I haven't tested, and I think single quotes should also work in older sql servers, has anyone tried that? What do you say?Cheers,Ujjaval |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-05-06 : 09:26:45
|
| Single quotes have always been the standard.e4 d5 xd5 Nf6 |
 |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-05-06 : 15:28:43
|
| It is SET QUOTED_IDENTIFIER issue, if set the SET QUOTED_IDENTIFIER OFF you will not get error...I don't think there is any change in the setting but it might have changed manually..MohammedU |
|
|
|
|
|
|
quotes in T-SQL