stored procedures

Question

what happened to this ??

romasha ali · Answer

sir kindly tell me the exact code: I want query for login verification in which the user and password I give in textbox match to my db column ..my column names are UserName and Password

romasha ali · Answer

sir kindly tell me the exact code: I want query for login verification in which the user and password I give in textbox match to my db column ..my column names are UserName and Password

ashleyturnier · Answer

Your answer is correct. The error occured only the red boxes. The normal stored procedure creation is: create procedure Proc_Name @Column1Value DataType, @Column2Value DataType as begin insert into TableName ( Column1, Column2 ) values ( @Column1Value, @Column2Value ) end exec Proc_Name 'TestValue1','TestValue2'

Anoop Kumar Sharma · Answer

See the red and orange boxes in above image. I think you have done mistake here(check spelling).Why I am saying this? Because the name you declare is different from the name you are using in your query. and try to declare parameter like this:- DECLARE @ MyVariable INT SET @ MyVariable = 8 Specify a parameter name by using the at sign ( @ ) as the first character -------------------------------------------------------------------------------------- There are no mistakes or failures, only lessons.

stored procedures

Answers (4)