SQL Server 7.0 with ASP.NET?

  • Thread starter Thread starter Peter Monadjemi
  • Start date Start date
P

Peter Monadjemi

Hi,

I want to "implement" an asp.net message board that uses sql 2000 as a
backend but my provider only gives me sql server 7.0 (they say every of
their customers only uses sql 7 - I hope thats not standard).

My question is since I am no T-SQL expert - would it make sense to adapt
the sql 2000 script to sql 7 (it uses a sort by a bit colum for example
which is sql server 2000 only I guess) or could that mean that the stored
procedure the message board uses might have other hidden dependencies as
well? When I run the script with query analyzer the stored procedure will be
created.

I don't want to go through all this only to find about it was a misson
impossible;)

So my question is: Is T-SQL in Sql 2000 a big jump from T-SQL in SQL 7.0
or are they only minor differences? I could scan through documentation but
an expert advice like "Don't even think about trying it" would be a much
bigger help for me.

many thanks,
peter

PS: The vendor of the message board obviously doesn't know much about SQL
7.0 too;(
--

<----------------------------------------------------->
Peter Monadjemi - ActiveTraining
www.activetraining.de
Post:
Soeckingerstrasse 18
82319 Starnberg
Germany
Phone: +49-8151-555 830
Fax: +49-8151-555 831
<----------------------------------------------------->
 
T-SQL syntax should not be different between SQL Server 7 and 2000. Here
is a link to the known issues between SQL 7 and 2000 and T-SQL is not
mentioned:

SQL Server 2000 and SQL Server version 7.0
http://msdn.microsoft.com/library/en-us/instsql/in_bckwd_3vlc.asp?frame=true

I hope this helps!

Thanks,
Hussein Abuthuraya
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2004 Microsoft Corporation. All rights
reserved

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
 
Back
Top