what is the mistake in this stored procedure

Question

Post reply

what is the mistake in this stored procedure

ssakjobs

Grasshopper

Points: 15
More actions
August 9, 2010 at 6:19 pm

#142342

create procedure edifyp
(
@firstname varchar(50),
@lastname varchar(50),
@Username varchar(50),
@password varchar(50),
@cpassword varchar(50)
)
as insert into esignup
(
[firstname],
[lastname],
[username],
[password],
[cpassword]
)
values
(
@firstname ,
@lastname ,
@Username ,
@password ,
@cpassword
)

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95409 More actions · Answer 1

I don't see an issue with it. Why do you think there is one?

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Grant Fritchey SSC Guru Points: 398690 More actions · Answer 2

Looks OK to me. Are you getting an error? If so, what is it?

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Dwayne Dibley SSCrazy Points: 2350 More actions · Answer 3

Perhaps...

The table doesn't exist?

You are storing passwords unencrypted?

If that is the standard of formatting in the database, your formatting standards could be improved.

Come on, give us a clue. Is this for a pub quiz?

dmbaker SSCertifiable Points: 5086 More actions · Answer 4

You're not specifying the owner/schema for the stored procedure and/or the table you're inserting into? You're trying to insert NULL values into columns that don't allow NULLs? The moon isn't in the seventh house?

Wow, the possibilities are endless!

Dwayne Dibley SSCrazy Points: 2350 More actions · Answer 5

Inconsistent casing - do I not like that.

Jupiter isn't aligned with Mars, this isn't the dawning of the age of Aquarius...

vidyasagar.web2.0 Newbie Points: 1 More actions · Answer 6

Hey i don't see any issue with the procedure. If is their any problem check your table once again

sdorris-1150234 SSC-Addicted Points: 457 More actions · Answer 7

The procedure is syntatically correct. The mistake is in not telling us what error you are receiving.:unsure: