migration from sql 7 to sql 2000

hi ,
I want to migrate from sql 7 to sql 2000 and now my issuse is that double
quotes are not suported in sql 2000 and they where suported in sql 7 . an
many of my procedures are using it .what should i do .
Message posted via http://www.sqlmonster.com
You should use single-quotes to delimit strings, not double-quotes, which is a left over from a bad
design since the 1.0 days. Double.quotes are used to delimit identifiers, not strings.
Anyhow, SQL Server 2000 supports delimiting strings with double-quotes. Create your stored
procedures while having SET QUOTED_IDENTIFIER turned on and they will work.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"amr h via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:dcf579d27da347e289518bcd2ccee84c@.SQLMonster.c om...
> hi ,
> I want to migrate from sql 7 to sql 2000 and now my issuse is that double
> quotes are not suported in sql 2000 and they where suported in sql 7 . an
> many of my procedures are using it .what should i do .
> --
> Message posted via http://www.sqlmonster.com
|||But my issue is that i have a distributed application ,web application also
..
won't this quoted identifier work from there also .
Message posted via http://www.sqlmonster.com
|||What do you mean by "distributed application"? Are you saying that the web application sends SQL
queries to SQL Server instead of executing stored procedures?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"amr h via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:4df1ae8a484d4565899f54b5898844c9@.SQLMonster.c om...
> But my issue is that i have a distributed application ,web application also
> .
> won't this quoted identifier work from there also .
> --
> Message posted via http://www.sqlmonster.com
|||As I told u that I am having a distributed application .
on some nmachine can still be running on sql 7 ,and between these different
server ,I have data tansfer happening using bcp in and ou command ,so will
a bcp out from sql 7.0 happen on sql 2k and from sql 2k to sql 7 and all
mix and match .
Message posted via http://www.sqlmonster.com
|||Then methods I mentioned are both applicable to both 7.0 and 2000.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"amr h via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:6c38c8ae142544f19d01802a220109e3@.SQLMonster.c om...
> As I told u that I am having a distributed application .
> on some nmachine can still be running on sql 7 ,and between these different
> server ,I have data tansfer happening using bcp in and ou command ,so will
> a bcp out from sql 7.0 happen on sql 2k and from sql 2k to sql 7 and all
> mix and match .
> --
> Message posted via http://www.sqlmonster.com