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.comYou 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.com...
> 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.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|||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.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