如何使用存储过程执行插入,更新,删除操作. [英] how to perform insert,update,delete operation using stored procedure.
本文介绍了如何使用存储过程执行插入,更新,删除操作.的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
任何人都可以回答我......
Can anyone Answer Me.........
how to perform insert,update,delete operation using stored procedure.
推荐答案
http://www.telerik.com/community/code-library/aspnet-ajax/grid/update-insert-delete-with-stored-procedures-and-sqldatasource-control.aspx [ http://www.mikesdotnetting.com/Article/15/Insert-Single-Value-With-Stored-Procedure-ASP.NET-CSharp [^ ]
http://www.c-sharpcorner.com/UploadFile/gtomar/storedprocedure12052007003126AM/storedprocedure.aspx [ ^ ]
http://www.telerik.com/community/code-library/aspnet-ajax/grid/update-insert-delete-with-stored-procedures-and-sqldatasource-control.aspx[^]
http://www.mikesdotnetting.com/Article/15/Insert-Single-Value-With-Stored-Procedure-ASP.NET-CSharp[^]
http://www.c-sharpcorner.com/UploadFile/gtomar/storedprocedure12052007003126AM/storedprocedure.aspx[^]
只需包含参数&在存储过程中进行查询,仅此而已.
普通查询
Just include the parameters & query inside the stored procedure, thats all.
Normal query
INSERT INTO Emp(EmpID, EmpName) VALUES(@EmpID, @EmpName)
存储过程
Stored procedure
CREATE PROCEDURE usp_InsertEmployee
(
@EmpID int,
@EmpName varchar(50)
)
AS
BEGIN
INSERT INTO Emp(EmpID, EmpName) VALUES(@EmpID, @EmpName)
END
嗨Narmatha,
您可以像这样尝试正常工作
创建过程[dbo].[InsertCourse](
@CourseCode nvarchar(250),
@CourseName nvarchar(250),
@CourseDescription ntext
)
AS
开始
INSERT INTO课程(课程代码,
课程名称,
课程说明)
值(@CourseCode,
@CourseName,
@CourseDescription)
END
更新/////////////
更改过程[dbo].[UpdateCourse](
@CourseCode nvarchar(250),
@CourseName nvarchar(250),
@CourseDescription ntext,
@CourseID int
)
AS
开始
更新课程设置CourseCode = @ CourseCode,
CourseName = @ CourseName,
CourseDescription = @ CourseDescription
WHERE CourseID = @ CourseID
END
/////////////////
更改程序[dbo].[DeleteCourse](
@CourseCode nvarchar(250),
@CourseName nvarchar(250),
@CourseDescription ntext,
@CourseID int
)
AS
开始
从课程WHERE中删除CourseID = @ CourseID
END
////////////选择///////////
USE [BW HRM]
GO
/******对象:StoredProcedure [dbo].[GetAllCourse]脚本日期:09/24/2010 12:45:25 ******/
设置ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
更改过程[dbo].[GetAllCourse]
(@CourseCode nvarchar(250),
@CourseName nvarchar(250),
@CourseDescription ntext,
@CourseID int)
AS
开始
从课程中选择课程ID,课程代码,课程名称,课程说明
END
///////////////id选择////////////
USE [BW HRM]
GO
/******对象:StoredProcedure [dbo].[GetAllCourseIDdetails]脚本日期:09/24/2010 12:45:44 ******/
设置ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
更改过程[dbo].[GetAllCourseIDdetails]
(
@CourseCode nvarchar(250),
@CourseName nvarchar(250),
@CourseDescription ntext,
@CourseID int
)
AS
开始
从课程中选择CourseCode,CourseName,CourseDescription,其中CourseID = @ CourseID
END
并且这是sql formate,一旦粘贴了此站点并复制paste => sql看到sql formate的区别
http://www.dpriver.com/pp/sqlformat.htm?ref=g_wangz [ ^ ]
Hi Narmatha,
you can try like this working fine
CREATE PROCEDURE [dbo].[InsertCourse](
@CourseCode nvarchar(250),
@CourseName nvarchar(250),
@CourseDescription ntext
)
AS
BEGIN
INSERT INTO Course(CourseCode,
CourseName,
CourseDescription)
values(@CourseCode,
@CourseName,
@CourseDescription)
END
update//////////////
ALTER PROCEDURE [dbo].[UpdateCourse](
@CourseCode nvarchar(250),
@CourseName nvarchar(250),
@CourseDescription ntext,
@CourseID int
)
AS
BEGIN
UPDATE Course SET CourseCode=@CourseCode,
CourseName=@CourseName,
CourseDescription=@CourseDescription
WHERE CourseID=@CourseID
END
//////////////delete//////////////
ALTER PROCEDURE [dbo].[DeleteCourse](
@CourseCode nvarchar(250),
@CourseName nvarchar(250),
@CourseDescription ntext,
@CourseID int
)
AS
BEGIN
delete from Course WHERE CourseID=@CourseID
END
///////////select/////////////
USE [BW HRM]
GO
/****** Object: StoredProcedure [dbo].[GetAllCourse] Script Date: 09/24/2010 12:45:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[GetAllCourse]
(@CourseCode nvarchar(250),
@CourseName nvarchar(250),
@CourseDescription ntext,
@CourseID int)
AS
BEGIN
SELECT CourseID, CourseCode, CourseName, CourseDescription FROM Course
END
////////////////id select/////////////
USE [BW HRM]
GO
/****** Object: StoredProcedure [dbo].[GetAllCourseIDdetails] Script Date: 09/24/2010 12:45:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[GetAllCourseIDdetails]
(
@CourseCode nvarchar(250),
@CourseName nvarchar(250),
@CourseDescription ntext,
@CourseID int
)
AS
BEGIN
SELECT CourseCode,CourseName,CourseDescription FROM Course where CourseID=@CourseID
END
and this is sql formate once paste this site and copy paste=>sql see difference of sql formate
http://www.dpriver.com/pp/sqlformat.htm?ref=g_wangz[^]
这篇关于如何使用存储过程执行插入,更新,删除操作.的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文