EasyCFM.COM ColdFusion Forums / MS SQL Server Related Issues / Question about stored procedure

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Question about stored procedure -- page: 1 2

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

kicker
01-03-2007 @ 12:29 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 717
Joined: Oct 2004

Ok I figured it out. here it is for anyone who might have the same problem.


<cfquery datasource="mydb">
CREATE PROCEDURE sp_myProcedure
<!---Name your variables with the database length--->
@myVariable1 VARCHAR(255),
@myVariable2 VARCHAR(50) AS
SELECT cl_Name,cl_Birthday,cl_Type FROM my_tbl
WHERE cl_Name = @myVaribale1 OR cl_Birthday = @myVariable2
</cfquery>


I also found a resource through microsoft after flunking out with them several times and reading through alot of pages of useless "How great stored procedures and their SQL server is" here is that link:

http://msdn2.microsoft.com/en-us/library/ms187926.aspx

Craig

This message was edited by kicker on 1-3-07 @ 12:29 AM

PAGE: 1 2

Website Designed and Developed by Pablo Varando.