存储过程查询 [英] Store Procedure Query

查看：61 发布时间：2019/6/17 6:59:13 SQL-Server

本文介绍了存储过程查询的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我想要在注册时如果剩下一边那么计数应该增加1

如果一边是正确的，那么计数应该增加1

如果双方数相同，赞助商应该增加1

请告诉我坚持这个代码

这里我创建了商店程序请告诉我哪里出错了..

  ALTER   PROCEDURE  [dbo]。[sp_insert_registration] 
 （
 
  @ fname   varchar （ 50 ）=  NULL ，
  @ mname   varchar （ 50 ）=  NULL ，
  @ lname   varchar （ 50 ）=  NULL ，
  @ p_password   varchar （ 50 ）=  NULL ，
  @ question   varchar （ 50 ）= NULL，
  @ answer   varchar （ 50 ）= NULL，
  @ person_address   varchar （ 50 ）=  NULL ，
  @ gender   varchar （ 50 ）=  NULL ，
  @ sponcorid   varchar （ 50 ）=  NULL ，
  @ dob  datetime =  NULL ，
  @ productname   varchar （ 50 ）= NULL ，
  @ payment   varchar （ 50 ）=  NULL ，
  @ sponcorname   varchar （ 50 ）=  NULL ，
  @ side   varchar （ 50 ）=  NULL ，
  @ mobile   varchar （ 50 ）=  NULL ，
  @ bankname   varchar （ 50 ）=  NULL ，
  @ baccno   varchar （ 50 ）=  NULL ，
  @ bankbranch   varchar （ 50 ）=  NULL ，
  @ PAN   varchar （ 50  ）=  NULL ，
  @ IFSC_code   varchar （ 50 ）=  NULL ，
  @ email_id   varchar （ 50 ）=  NULL ，
  @ member_status   varchar （ 50 ）=  NULL ，
  @ flag 位= NULL，
  @ count_mem   varchar （  50 ）=  NULL ，
  @ smart_pin   varchar （ 100 ）= NULL，
  @createddate  datetime =  NULL ，
  @ is_activate  bit =  NULL ，
  @ registrationid  int =  NULL ，
  @ renewaldate  datetime = NULL，
  @ regCode   varchar （ 50 ）= NULL 
）
  AS  
  BEGIN  
 
  INSERT   INTO  Registration_Master 
（
 [fname] 
，[mname] 
，[lname] 
，[p_password] 
，[问题] 
，[answer] 
， [person_address] 
，[性别] 
，[sponcorid] 
，[dob] 
，[productname] 
，[payment] 
，[sponcorname ] 
，[side] 
，[mobile] 
，[bankname] 
，[baccno] 
，[bankbranch] 
，[PAN] 
，[IFSC_code] 
，[email_id] 
，[member_status] 
，[flag] 
，[smart_pin] 
，[renewaldate] 
，[createddate] 
，[is_activate] 
 ）
 
  VALUES  
（
 
  @ fname ，
  @ mname ，
  @ lname ，
  @ p_password ，
  @ question ，
  @answer ，
  @ person_address ，
  @ gender  ，
  @ sponcorid ，
  @ dob ，
  @ productname ，
  @ payment ，
  @ sponcorname ，
  @ side ，
  @ mobile ，
  @ bankname ，
  @ baccno ，
  @ bankbranch ，
  @ PAN ，
  @ IFSC_code ，
  @ email_id ，
  @ member_status ，
  @ flag ，
  @ smart_pin ，
  @renewaldate ，
  @ createddate ，
  1  
 
）
 
  END  
 
 
   -   配对匹配 
  SET  @ count_mem = 0 
  WHILE （@ sponcorid！= NULL）
  BEGIN  
  IF （ @ regCode ！= NULL）
  BEGIN  
  DECLARE   @ countl   int  
  IF （ @ side  = '  LEFT'）
  BEGIN  
 更新 Registration_Master 
  SET  @ count_mem = @ count_mem + 1 
  WHERE  regCode = @ regCode  AND  side = '  LEFT'  AND  count_mem = @ count_mem 
 
  END  
  DECLARE   @ countr   int  
  IF （@ side = '  RIGHT'）
  BEGIN  
 更新 Registration_Master 
  SET  @ count_mem = @ count_mem + 1 
  WHERE  regCode = @ regCode  AND  side = '  RIGHT'  AND  count_mem = @ count_mem 
  END  
  IF （@ countl = @ countr）
  BEGIN  
 更新 Registration_Master 
  SET  @ count_mem = @ count_mem + 1 
  WHERE  regCode = @ regCode 
  IF （@ regCode！= NULL）
  BEGIN  
  UPDATE  Registration_Master 
  SET  @ count_mem = @ count_mem + 1 
  WHERE  sponcorid = @ sponcorid  AND  count_mem = @ count_mem 
  END  
  END  
 
  END  
 
  END  
 
  SELECT  registrationid，regCode，fname，mname，lname，username，p_password，question，answer，person_address，gender，sponcorid，dob，productname，payment ，sponcorname，side，mobile，bankname，baccno，
 bankbranch，PAN，IFSC_code，email_id，member_status，count_mem，smart_pin，createddate，is_activate 
  FROM  Registration_Master 
 
  WHERE  registrationid = @@ IDENTITY

解决方案

用于illustra的几种设备灰。表格。

 CREATE TABLE [cpqaAnswers]。[cpqa]。[tbl_SK_Registration_Master]（
 [fname] varchar（50）NULL，[mname] varchar（50 ）NULL，[lname] varchar（50）NULL，[p_password] varchar（50）NULL，[question] varchar（50）NULL，[answer] varchar（50）NULL，[person_address] varchar（50）NULL，[性别] varchar（50）NULL，[sponcorid] varchar（50）NULL，[dob] datetime NULL，[productname] varchar（50）NULL，[payment] varchar（50）NULL，[sponcorname] varchar（50）NULL，[ side] varchar（50）NULL，[mobile] varchar（50）NULL，[bankname] varchar（50）NULL，[baccno] varchar（50）NULL，[bankbranch] varchar（50）NULL，[PAN] varchar（50 ）NULL，[IFSC_code] varchar（50）NULL，[email_id] varchar（50）NULL，[member_status] varchar（50）NULL，[flag] bit NULL，[count_mem] varchar（50）NULL，[smart_pin] varchar（ 100）NULL，[createddate] datetime NULL，[is_activate] bit NULL，[registrationid] bigint NULL，[renewaldate] datetime NULL，[regCode] varchar（50）NULL 
）

和一个新架构。然后是上面的停止。

  -  CREATE SCHEMA [cpqa] 
 
 USE [cpqaAnswers] 
 GO 
 CREATE PROCEDURE [ cpqa]。[sp_SK_insert_registration] 
（
 @fname varchar（50）= NULL，@ mname varchar（50）= NULL，@ lname varchar（50）= NULL，@ p_password varchar（50）= NULL ，@ question varchar（50）= NULL，@ answer varchar（50）= NULL，@ person_address varchar（50）= NULL，@ gender varchar（50）= NULL，@ sponcorid varchar（50）= NULL，@ dob datetime = NULL，@ productname varchar（50）= NULL，@ payment varchar（50）= NULL，@ sponcorname varchar（50）= NULL，@ side varchar（50）= NULL，@ mobile varchar（50）= NULL，@ bankname varchar （50）= NULL，@ baccno varchar（50）= NULL，@ bankbranch varchar（50）= NULL，@ PAN varchar（50）= NULL，@ IFSC_code varchar（50）= NULL，@ email_id varchar（50）= NULL ，@ member_status varchar（50）= NULL，@ flag bit = NULL，@ count_mem varchar（50）= NULL，@ smart_pin varchar（100）= NULL，@ createdate datetime = NULL，@ is_activate bit = NULL，@ registrationid bigint = NULL，@ renewaldate datetime = NULL，@ regCode varchar（50）= NULL 
 ）
 AS 
 BEGIN 
 INSERT INTO tbl_SK_Registration_Master（[fname]，[mname]，[lname]，[p_password]，[question]，[answer]，[person_address]，[gender] [sponcorid]，[DOB]，[产品]，[付款]，[sponcorname]，[侧]，[移动]，[BANKNAME]，[baccno]，[bankbranch]，[PAN]，[IFSC_code]，[ email_id]，[member_status]，[flag]，[smart_pin]，[renewaldate]，[createddate]，[is_activate]）
 VALUES（
 @fname，@ mname，@ lname，@ p_password，@问题，@回答，@ person_address，
 @性别，@ sponcorid，@ dob，@ productname，@ payment，@ sponcorname，@ side，@ mobile，
 @ bankname，@ baccno，@ bankbranch，@ PAN，@ IFSC_code，@ email_id，@ member_status，@ flag，@ smart_pin，@ renewaldate，@ createddate，1 
）
 END 
  - 匹配
 SET @ count_mem = 0 
 WHILE（@sponcorid！= NULL）
 BEGIN 
 IF（@regCode！= NULL）
 BEGIN 
 DECLARE @countl int 
 IF（@ side =''LEFT''）
 BEGIN 
 UPDATE tbl_SK_Registration_Master 
 SET @ count_mem = @ count_mem + 1 
 WHERE regCode = @ regCode AND side =''LEFT''AND count_mem = @ count_mem 
 
 END 
 DECLARE @countr int 
 IF（@ side =' 'RIGHT''）
 BEGIN 
 UPDATE tbl_SK_Registration_Master 
 SET @ count_mem = @ count_mem + 1 
 WHERE regCode = @ regCode AND side =''RIGHT''AND count_mem = @ count_mem 
 END 
 IF（@ countl = @ countr）
 BEGIN 
 UPDATE tbl_SK_Registration_Master 
 SET @ count_mem = @ count_mem + 1 
 WHERE regCode = @ regCode 
 IF（@regCode！= NULL）
 BEGIN 
 UPDATE tbl_SK_Registration_Master 
 SET @ count_mem = @ count_mem + 1 
 WHERE sponcorid = @ sponcorid AND count_mem = @ count_mem 
 END 
 END 
 END 
 END 
 
 SELECT [registrationid]，[regCode]，[fname]，[mname]，[lname]，[p_password] ，[问题]，[答案]，[person_address]，[性别]，[sponcorid]，[dob]，[productname]，[付款]，[sponcorname]，[side]，[mobile]，[bankname]， [baccno]，
 [bankbranch]，[PAN]，[IFSC_code]，[email_id]，[member_status]，[count_mem]，[smart_pin]，[createddate]，[is_activate] 
 FROM tbl_SK_Registration_Master 
 
 WHERE [registrationid] = @@ IDENTITY

上面的SELECT中有错误...;还有一个名为[username]的额外字段（我可以自由删除）...要么通过删除来减少程序集，要么通过添加使其复杂化。选择你的选择。

然后快速上下文菜单EXECUTE TO clipboard。还有一个粘贴。

 DECLARE @RC int 
 DECLARE @fname varchar（50）
 DECLARE @mname varchar（50）
 DECLARE @ lname varchar（50）
 DECLARE @p_password varchar（50）
 DECLARE @question varchar（50）
 DECLARE @answer varchar（50）
 DECLARE @person_address varchar（50）
 DECLARE @gender varchar（50）
 DECLARE @sponcorid varchar（50）
 DECLARE @dob datetime 
 DECLARE @productname varchar（50）
 DECLARE @payment varchar（50 ）
 DECLARE @sponcorname varchar（50）
 DECLARE @side varchar（50）
 DECLARE @mobile varchar（50）
 DECLARE @bankname varchar（50）
 DECLARE @baccno varchar（50）
 DECLARE @bankbranch varchar（50）
 DECLARE @PAN varchar（50）
 DECLARE @IFSC_code varchar（50）
 DECLARE @email_id varchar（50） 
 DECLARE @member_status varchar（50）
 DECLARE @flag bit 
 DECLARE @count_mem varchar（50）
 DECLARE @smart_pin varchar（100）
 DECLARE @createddate datetime 
 DECLARE @is_activate位
 DECLARE @registrationid bigint 
 DECLARE @renewaldate datetime 
 DECLARE @regCode varchar（50）
 
 / *有一些假设数据... * / 
 
 SET @fname =''John''
 SET @mname =''Jacob''
 SET @lname =''Jingleheimerschmidt''
 SET @p_password =''daredevil''
 SET @question =''我抓了多少钩子''
 SET @answer =''不知道因为我戴着眼罩''
 SET @person_address =''1313 Mockingbird Lane，Sandusky，OH 43456''
 SET @gender =''male''
 SET @sponcorid =''tv7''
 SET @dob =' '07 / 09/36''
 SET @productname =''SQL Server Managment Studio 2008 64位Express''
 SET @payment =''granitemarbleolivinequartz''
 SET @sponcorname = ''SPON Corp America''
 SET @side =''muttonFull''
 SET @mobile =''918-105-4378''
 SET @bankname =''Sanwa'' 
 SET @ba ccno =''seriousmicroscopicorganismshaveRIFDtagsthesedays''
 SET @bankbranch ='''8722''
 SET @PAN =''100100001000111000010001''
 SET @IFSC_code =''SNWA0008722''
 SET @email_id =''millet@utumno.uk''
 SET @member_status ='''523''
 SET @flag =''1''
 SET @count_mem =''128 ''
 SET @smart_pin =''0''
 SET @createddate =''11/11/77''
 SET @is_activate =''1''
 SET @registrationid = 9473553 
 SET @renewaldate =''01/01/00''
 SET @regCode =''sansouci7sushi6sus4s0''
 
 EXECUTE @RC = [cpqaAnswers]。 [cpqa]。[sp_SK_insert_registration] 
 @ fname，@ mname，@ lname，@ p_password，@ question，@ answer，@ person_address，@ gender，@ sponcorid，@ dob，@ productname，@ payment，@ sponcorname， @侧，@移动，@ BANKNAME，@ baccno，@ bankbranch，@ PAN，@ IFSC_code，@ EMAIL_ID，@ member_status，@标志，@ count_mem，@ smart_pin，@ createddate，@ is_activate，@ registra tionid，@ renewaldate，@ regCode 
 GO

和最终的SELECT达到OVER。

 SELECT [fname]，[mname]，[lname]，[p_password]，[问题]，[回答]，[person_address]，[性别]，[sponcorid]，[dob]，[productname]，[付款]，
 [sponcorname]，[side]，[mobile]，[bankname]，[baccno]，[bankbranch]，[PAN]，[IFSC_code]，[email_id]，[member_status]，
 [flag]， [count_mem]，[smart_pin]，[createddate]，[is_activate]，[registrationid]，[renewaldate]，[regCode] 
 FROM [cpqaAnswers]。[cpqa]。[tbl_SK_Registration_Master] 
 GO

I want when registration occurs if the side is left then the count should get increment by 1

if side is right the count should get increment by 1

if both side count is same the sponsor should get increment by 1

please please tell me stuck on this code

here i have created store procedure please please do tell me where i am going wrong..

ALTER PROCEDURE [dbo].[sp_insert_registration]
	(      
		  
		   @fname varchar(50)= NULL,
		   @mname varchar(50)= NULL,
		   @lname varchar(50)= NULL,
		   @p_password varchar(50)= NULL,
		   @question varchar(50)=NULL,
		   @answer varchar(50)=NULL,
           @person_address varchar(50)= NULL,
           @gender varchar(50)= NULL,
           @sponcorid varchar(50)= NULL,
		   @dob datetime= NULL,
			@productname varchar(50)=NULL,
		   @payment varchar(50)= NULL,
           @sponcorname varchar(50)= NULL,
		   @side varchar(50)= NULL,
           @mobile varchar(50)= NULL,
           @bankname varchar(50)= NULL,
           @baccno varchar(50)= NULL,
           @bankbranch varchar(50)= NULL,
           @PAN varchar(50)= NULL,
           @IFSC_code varchar(50)= NULL,
           @email_id varchar(50)= NULL,
           @member_status varchar(50)= NULL,
           @flag bit=NULL,
		   @count_mem varchar(50)= NULL,
		   @smart_pin varchar(100)=NULL,
           @createddate datetime= NULL,
           @is_activate bit= NULL,
			@registrationid int= NULL,
			@renewaldate datetime=NULL,
			@regCode varchar(50)=NULL
           )
AS
BEGIN

	INSERT INTO Registration_Master
           (
[fname]
,[mname]
,[lname]
,[p_password]
,[question]
,[answer]
,[person_address]
,[gender]
,[sponcorid]
,[dob]
,[productname]
,[payment]
,[sponcorname]
,[side]
,[mobile]
,[bankname]
,[baccno]
,[bankbranch]
,[PAN]
,[IFSC_code]
,[email_id]
,[member_status]
,[flag]
,[smart_pin]
,[renewaldate]
,[createddate]
,[is_activate]
           )

     VALUES
           (

@fname,
@mname,
@lname,
@p_password,
@question,
@answer,
@person_address,
@gender,
@sponcorid,
@dob,
@productname,
@payment,
@sponcorname,
@side,
@mobile,
@bankname,
@baccno,
@bankbranch,
@PAN,
@IFSC_code,
@email_id,
@member_status,
@flag,
@smart_pin,
@renewaldate,
@createddate,
1

)

END


--Pair Matching
SET @count_mem=0
WHILE(@sponcorid!=NULL)
	BEGIN
		IF(@regCode !=NULL)
		BEGIN
			DECLARE @countl int
			IF(@side ='LEFT')
			BEGIN
				UPDATE Registration_Master
				SET @count_mem=@count_mem+1
				WHERE regCode=@regCode AND side='LEFT' AND count_mem=@count_mem
		
			END
			DECLARE @countr int
			IF(@side='RIGHT')
			BEGIN
				UPDATE Registration_Master
				SET @count_mem=@count_mem+1
				WHERE regCode=@regCode AND side='RIGHT' AND count_mem=@count_mem
			END
			IF(@countl=@countr)
			BEGIN
				UPDATE Registration_Master
				SET @count_mem=@count_mem+1
				WHERE regCode=@regCode
				IF(@regCode!=NULL)
				BEGIN
					UPDATE Registration_Master
					SET @count_mem=@count_mem+1
					WHERE sponcorid=@sponcorid AND count_mem=@count_mem
				END
			END
			
		END

	END

SELECT     registrationid, regCode,  fname,mname,lname,username, p_password,question,answer, person_address, gender, sponcorid, dob,productname, payment, sponcorname, side, mobile, bankname, baccno, 
                      bankbranch, PAN, IFSC_code, email_id, member_status, count_mem,smart_pin,createddate, is_activate
FROM         Registration_Master

WHERE registrationid=@@IDENTITY

解决方案

A couple of devices for illustration. A table.

CREATE TABLE [cpqaAnswers].[cpqa].[tbl_SK_Registration_Master](
	   [fname] varchar(50) NULL,[mname] varchar(50) NULL,[lname] varchar(50) NULL,[p_password] varchar(50) NULL,[question] varchar(50) NULL,[answer] varchar(50) NULL,[person_address] varchar(50) NULL,[gender] varchar(50) NULL,[sponcorid] varchar(50) NULL,[dob] datetime NULL,[productname] varchar(50) NULL,[payment] varchar(50) NULL,[sponcorname] varchar(50) NULL,[side] varchar(50) NULL,[mobile] varchar(50) NULL,[bankname] varchar(50) NULL,[baccno] varchar(50) NULL,[bankbranch] varchar(50) NULL,[PAN] varchar(50) NULL,[IFSC_code] varchar(50)  NULL,[email_id] varchar(50) NULL,[member_status] varchar(50) NULL,[flag] bit NULL,[count_mem] varchar(50) NULL,[smart_pin] varchar(100) NULL,[createddate] datetime  NULL, [is_activate] bit NULL,	[registrationid] bigint  NULL,[renewaldate] datetime NULL,[regCode] varchar(50) NULL
	   )

And a new schema. Then the above stoproc.

--CREATE SCHEMA [cpqa]

USE[cpqaAnswers]
GO
CREATE PROCEDURE [cpqa].[sp_SK_insert_registration]
	(      
	@fname varchar(50)= NULL,@mname varchar(50)= NULL,@lname varchar(50)= NULL,@p_password varchar(50)= NULL,@question varchar(50)=NULL,	@answer varchar(50)=NULL,@person_address varchar(50)= NULL,@gender varchar(50)= NULL,@sponcorid varchar(50)= NULL,@dob datetime= NULL,@productname varchar(50)=NULL,@payment varchar(50)= NULL,@sponcorname varchar(50)= NULL,@side varchar(50)= NULL,@mobile varchar(50)= NULL,@bankname varchar(50)= NULL,@baccno varchar(50)= NULL, @bankbranch varchar(50)= NULL,@PAN varchar(50)= NULL,@IFSC_code varchar(50)= NULL, @email_id varchar(50)= NULL, @member_status varchar(50)= NULL, @flag bit=NULL,@count_mem varchar(50)= NULL,	@smart_pin varchar(100)=NULL, @createddate datetime= NULL, @is_activate bit= NULL,	@registrationid bigint= NULL,@renewaldate datetime=NULL,@regCode varchar(50)=NULL
      )
AS
	BEGIN
	 INSERT INTO tbl_SK_Registration_Master([fname],[mname],[lname],[p_password],[question],[answer],[person_address],[gender],[sponcorid],[dob],[productname],[payment],[sponcorname],[side],[mobile],[bankname],[baccno],[bankbranch],[PAN],[IFSC_code],[email_id],[member_status],[flag],[smart_pin],[renewaldate],[createddate],[is_activate])
				VALUES(
	 				@fname,	@mname,	@lname,	@p_password,@question,@answer,@person_address,
						@gender,@sponcorid,	@dob,@productname,@payment,@sponcorname,@side,@mobile,
							@bankname,@baccno,@bankbranch,@PAN,	@IFSC_code,	@email_id,@member_status,@flag,	@smart_pin,	@renewaldate,@createddate,1
	 						)
	END
	--Pair Matching
	SET @count_mem=0
	WHILE(@sponcorid!=NULL)
		BEGIN
			IF(@regCode !=NULL)
			BEGIN
				DECLARE @countl int
				IF(@side =''LEFT'')
				BEGIN
					UPDATE tbl_SK_Registration_Master
					SET @count_mem=@count_mem+1
					WHERE regCode=@regCode AND side=''LEFT'' AND count_mem=@count_mem
			
				END
				DECLARE @countr int
				IF(@side=''RIGHT'')
				BEGIN
					UPDATE tbl_SK_Registration_Master
					SET @count_mem=@count_mem+1
					WHERE regCode=@regCode AND side=''RIGHT'' AND count_mem=@count_mem
				END
				IF(@countl=@countr)
				BEGIN
					UPDATE tbl_SK_Registration_Master
					SET @count_mem=@count_mem+1
					WHERE regCode=@regCode
					IF(@regCode!=NULL)
					BEGIN
						UPDATE tbl_SK_Registration_Master
						SET @count_mem=@count_mem+1
						WHERE sponcorid=@sponcorid AND count_mem=@count_mem
					END
				END
			END
		END
	 
	SELECT     [registrationid], [regCode],  [fname],[mname],[lname],[p_password],[question],[answer], [person_address], [gender], [sponcorid], [dob],[productname], [payment], [sponcorname], [side], [mobile], [bankname],[baccno], 
						  [bankbranch], [PAN], [IFSC_code], [email_id], [member_status], [count_mem],[smart_pin],[createddate], [is_activate]
	FROM         tbl_SK_Registration_Master
	 
	WHERE [registrationid]=@@IDENTITY

There were errors ... in the above SELECT; there was an extra field called "[username]" (which i took the liberty of removing) ... either reduce the assembly by deletion or complicate it by addition. Take ''yer pick.

Then a quick context menu EXECUTE TO clipboard. And a paste.

DECLARE @RC int
DECLARE @fname varchar(50)
DECLARE @mname varchar(50)
DECLARE @lname varchar(50)
DECLARE @p_password varchar(50)
DECLARE @question varchar(50)
DECLARE @answer varchar(50)
DECLARE @person_address varchar(50)
DECLARE @gender varchar(50)
DECLARE @sponcorid varchar(50)
DECLARE @dob datetime
DECLARE @productname varchar(50)
DECLARE @payment varchar(50)
DECLARE @sponcorname varchar(50)
DECLARE @side varchar(50)
DECLARE @mobile varchar(50)
DECLARE @bankname varchar(50)
DECLARE @baccno varchar(50)
DECLARE @bankbranch varchar(50)
DECLARE @PAN varchar(50)
DECLARE @IFSC_code varchar(50)
DECLARE @email_id varchar(50)
DECLARE @member_status varchar(50)
DECLARE @flag bit
DECLARE @count_mem varchar(50)
DECLARE @smart_pin varchar(100)
DECLARE @createddate datetime
DECLARE @is_activate bit
DECLARE @registrationid bigint
DECLARE @renewaldate datetime
DECLARE @regCode varchar(50)

/* There''s a little hypothetical data ... */

SET @fname		= ''John''
SET @mname		= ''Jacob''
SET @lname		= ''Jingleheimerschmidt''
SET @p_password		= ''daredevil''
SET @question		= ''how many hooks am I holding up''
SET @answer		= ''don''''t know because I''''m wearing a blindfold''
SET @person_address	= ''1313 Mockingbird Lane, Sandusky, OH 43456''
SET @gender		= ''male''
SET @sponcorid		= ''tv7''
SET @dob		= ''07/09/36''
SET @productname	= ''SQL Server Managment Studio 2008 64-bit Express''
SET @payment		= ''granitemarbleolivinequartz''
SET @sponcorname	= ''SPON Corp America''
SET @side		= ''muttonFull''
SET @mobile		= ''918-105-4378''
SET @bankname		= ''Sanwa''
SET @baccno		= ''seriouslymicroscopicorganismshaveRIFDtagsthesedays''
SET @bankbranch	        = ''8722''
SET @PAN		= ''100100001000111000010001''
SET @IFSC_code		= ''SNWA0008722''
SET @email_id		= ''millet@utumno.uk''
SET @member_status	= ''523''
SET @flag		= ''1''
SET @count_mem		= ''128''
SET @smart_pin		= ''0''
SET @createddate	= ''11/11/77''
SET @is_activate	= ''1''
SET @registrationid     = 9473553
SET @renewaldate	= ''01/01/00''
SET @regCode		= ''sansouci7sushi6sus4s0''

EXECUTE @RC = [cpqaAnswers].[cpqa].[sp_SK_insert_registration] 
   @fname,@mname,@lname,@p_password,@question,@answer,@person_address,@gender,@sponcorid,@dob,@productname,@payment,@sponcorname,@side,@mobile,@bankname,@baccno,@bankbranch,@PAN,@IFSC_code,@email_id,@member_status,@flag,@count_mem,@smart_pin,@createddate,@is_activate,@registrationid,@renewaldate,@regCode
GO

And a final SELECT to reach OVER.

SELECT [fname],[mname],[lname],[p_password],[question],[answer],[person_address],[gender],[sponcorid],[dob],[productname],[payment],
			[sponcorname],[side],[mobile],[bankname],[baccno],[bankbranch],[PAN],[IFSC_code],[email_id],[member_status],
				[flag],[count_mem],[smart_pin],[createddate],[is_activate],[registrationid],[renewaldate],[regCode]
					FROM [cpqaAnswers].[cpqa].[tbl_SK_Registration_Master]
GO

这篇关于存储过程查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文

存储过程查询 [英] Store Procedure Query

问题描述

相关文章

其他开发语言最新文章

热门教程

热门工具

登录关闭

存储过程查询 [英] Store Procedure Query

问题描述

相关文章

其他开发语言最新文章

热门教程

热门工具

登录 关闭

登录关闭