Advanced Search

Return to Snippet

Revision: 27848
at June 25, 2010 04:39 by vedgiee
Initial Code 
CREATE PROCEDURE [dbo].[login]
(
	@username varchar(50),
	@password varchar(50)
)

AS

SELECT *  FROM tblUsers WHERE userName = @username AND userPass = @password

RETURN @@ROWCOUNT
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
MS SQL Store Procedure

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL