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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Converting ASP codes to Stored Procedures

Author  Topic 

abidba
Starting Member

26 Posts

Posted - 2009-10-22 : 14:44:18
Hi,
I have to conver ASP codes into SQL Stored procedures. How can i do this? I am not very good at programminr but i have to do this. There are about 85 ASP pages that have to converted to stored procuedures.

Thanks in advance for your help on this.

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2009-10-22 : 14:47:36
Are you talking about converting SQL embedded in ASP pages into stored procedures? If so, I think the only way to do it manually. :(
Go to Top of Page

abidba
Starting Member

26 Posts

Posted - 2009-10-22 : 15:02:25
Yes, there are lot of SELECT, INSERT, Update statements in ASP pages which are embedded in ASP pages and i have to conver these into Stored Prcoedures.
Please let me know how can we do this.

Thanks
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2009-10-23 : 14:21:14
you cant convert them.

You have to rewrite the codes yourself
Go to Top of Page

abidba
Starting Member

26 Posts

Posted - 2009-10-26 : 11:54:33
Thank you. I am learning ASP so that i can understand the code in ASP and conver them into SQL. Thanks for the info.
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2009-10-26 : 12:08:38
I would advice you, if you can to drop CLASSIC ASP and go for .net. Thought .net's learning curve is much more difficult than classic ASP, its far more simpler to implement and far more robust.

... and fun.
Go to Top of Page
   

- Advertisement -