使用存储过程 [英] working with stored procedure
本文介绍了使用存储过程的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个表,其字段为empid int,emp_name varchar(50),emp_phno char(10),emp_add varchar(75)
i必须使用insert,update,delete创建存储过程操作....提前感谢
解决方案
请访问此网站。
http://www.mssqltips.com/sqlservertutorial/160/sql-server-stored-procedure/ [ ^ ]
在这个网站你有非常基本的例子。试试这个..
有任何疑问或疑问请告诉我..
从这里开始:存储过程(数据库引擎) [ ^ ]并阅读所有相关文章:
实施SP [ ^ ]
创建SP [ ^ ]
执行SP [ ^ ]
我认为它已经足够开始了;)
你可以试试这个
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE StoredProcedureName
@ action varchar ( 10 ),
@ empid int ,
@ emp_name varchar ( 50 ),
@ emp_phno char ( 10 ),
@ emp_add varchar ( 75 )
AS
IF @action = ' 保存'
BEGIN
INSERT INTO TabelName(emp_name,emp_phno,emp_add )
VALUES ( @ emp_name , @ emp_phno , @ emp_add )
END
< span class =code-keyword> ELSE IF @ action = ' 更新'
BEGIN
< span class =code-keyword> UPDATE TabelName SET
emp_name = @ emp_name ,
emp_phno = @ emp_phno ,
emp_add = @ emp_add
WHERE (empid = @ empid )
END
ELSE IF @ action = ' 删除'
BEGIN
DELETE FROM TabelName
WHERE (empid = @ empid )
结束跨度>
i have a table with fields as empid int,emp_name varchar(50),emp_phno char(10),emp_add varchar(75)
i have to create a stored procedure using insert,update,delete operations....thanks in advance
解决方案
Please visit this site.
http://www.mssqltips.com/sqlservertutorial/160/sql-server-stored-procedure/[^]
in this site you have very basic example. try this..
Have any query or doubts please let me know..
Start here: Stored Procedures (Database Engine)[^] and read all related articles:
Implementing SP[^]
Creating SP[^]
Execute SP[^]
I think it''s quite enough for start ;)
you can try this
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE StoredProcedureName @action varchar(10), @empid int, @emp_name varchar(50), @emp_phno char(10), @emp_add varchar(75) AS IF @action ='Save' BEGIN INSERT INTO TabelName (emp_name,emp_phno,emp_add) VALUES (@emp_name,@emp_phno,@emp_add) END ELSE IF @action ='Update' BEGIN UPDATE TabelName SET emp_name = @emp_name, emp_phno = @emp_phno, emp_add = @emp_add WHERE (empid = @empid) END ELSE IF @action ='Delete' BEGIN DELETE FROM TabelName WHERE (empid = @empid) End
这篇关于使用存储过程的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文