Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #36.9K
|
[B]Stored Procedure "InsertUser"[/B] [code] ALTER procedure [dbo].[InsertUser] ( @username as varchar(50), @email as varchar(50), @password as varchar(20) ) as if(not exists(select email from dataUser where email=@email)) begin declare @lastnumber as integer set @lastnumber =0 select top 1@lastnumber =cast(substring(user_id,8,9) as integer) from dataUser order by user_id desc --insert insert into dataUser …
|