如何编写具有返回值的插入和删除的存储过程 [英] How To write store procedure for insert and Delete with returning value

问题描述

你好，
我是存储过程的新手，我正尝试使用存储过程从databse插入和获取数据.如何执行此操作，如何从存储过程中获取收益.
我的表是Tbl_Info
InfoId int，Firstname varchar(50)，LastName varchar(50)，City varchar(50)，Dob datetime

Hello,
I am new for Store procedure,i am trying to insert and fetch data from databse using Store Procedures.How to do this,How to get return from store procedure.
My Table is Tbl_Info
InfoId int,FirstName varchar(50),LastName varchar(50),City varchar(50),Dob datetime

推荐答案

您需要查看有关以下内容的一些教程和基本文章存储过程首先要知道它是如何工作的.

http://www.sqlteam.com/article/stored-procedures-returning-data [ ^ ]

You need to check some tutorial and basic articles on stored procedures first to know how it works.

http://www.sqlteam.com/article/stored-procedures-returning-data[^]

CREATE PROCEDURE PROCNAME   
@CountryId integer ,
@CountryName VARCHAR(200) ,
@nType integer
AS
BEGIN
IF @nType=1
  INSERT INTO Country VALUES(@CountryId,@CountryName);
ELSE IF @nType=2
  UPDATE Country SET CountryName=@CountryName WHERE CountryId=@CountryId;
ELSE IF @nType=0
DELET FROM Country WHERE CountryId=@CountryIdEND

这篇关于如何编写具有返回值的插入和删除的存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！