Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

what is the mistake in this stored procedure Expand / Collapse
Author
Message
Posted Monday, August 9, 2010 6:19 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 7, 2011 10:56 PM
Points: 15, Visits: 3
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
)
Post #966317
Posted Monday, August 9, 2010 7:45 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, October 17, 2014 7:46 AM
Points: 5,364, Visits: 8,948
I don't see an issue with it. Why do you think there is one?

Wayne
Microsoft Certified Master: SQL Server 2008
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, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #966320
Posted Tuesday, August 10, 2010 6:27 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:30 AM
Points: 13,864, Visits: 28,260
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
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #966607
Posted Tuesday, August 10, 2010 6:35 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 2, 2014 7:11 AM
Points: 368, Visits: 3,076
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?
Post #966616
Posted Wednesday, August 11, 2010 7:04 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, October 16, 2014 8:23 AM
Points: 519, Visits: 2,831
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!



Post #967375
Posted Wednesday, August 11, 2010 7:16 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 2, 2014 7:11 AM
Points: 368, Visits: 3,076
Inconsistent casing - do I not like that.

Jupiter isn't aligned with Mars, this isn't the dawning of the age of Aquarius...
Post #967386
Posted Thursday, August 12, 2010 12:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 12, 2010 2:35 AM
Points: 1, Visits: 2
Hey i don't see any issue with the procedure. If is their any problem check your table once again
Post #967949
Posted Friday, August 13, 2010 2:30 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, July 22, 2011 7:33 AM
Points: 289, Visits: 433
The procedure is syntatically correct. The mistake is in not telling us what error you are receiving.
Post #969265
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse