July 11, 2002 at 7:31 am
How can I use and create a template for stored procedures in SQL-Server version 7.0?
July 11, 2002 at 7:43 am
Do you have the SQL Server 2000 client tools available?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
July 11, 2002 at 7:43 am
Proc Blaster has several usefull templates but there is nothing specific you can more than that with SPs as they are basicall CREATE PROC name
input/output variables
AS
your processing code.
Also another trick you can get to give you some templates is download SQL 2000 eval and install on a test machine. Then copy the tql files and rename .sql.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 11, 2002 at 7:53 am
No. All I have is SQL version 7.0.
quote:
Do you have the SQL Server 2000 client tools available?K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
July 11, 2002 at 8:17 am
Then you're going to have to either grab a third-party tool like Proc Blaster as Antares has suggested or obtain a license for SQL Server 2000.
Unfortunately, I don't believe the client tools for SQL Server 2000 can be licensed separately from an actual server license. I'd have to verify that. In the interim, you can go and grab an eval copy and install the client tools without installing the server.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply