stored procedures

romasha ali13y ago

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 ali13y ago

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

ashleyturnier13y ago

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 Sharma13y ago

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.