更新时间:2022-04-02 08:40:21
如何使用存储过程在多个表中插入值?
How to insert values in multiple tables using storedprocedure?
大不了?
Big deal?
CREATE PROCEDURE Usp_StudentDetails(@StudentID int, @StudentName Varchar(50), @Mark int)
AS
BEGIN
INSERT INTO Tbl_Student(StudentID,StudentName) VALUES(@StudentID,@StudentName)
INSERT INTO Tbl_Marks(StudentID,Mark) VALUES(@StudentID,@Mark)
END
BTW根据您的需求自定义内容.也使用Try Catch
.
BTW customize things based on your need. Also use Try Catch
.
什么是错误日志&如何使用?
What is errorlog & How to use?
在这里你
SQL Server错误日志 [ ^ ]
SQL Server 2005错误日志管理 [
Here you go
SQL Server Error Logs[^]
SQL Server 2005 Error Log Management[^]
在存储的proc内写入多个更新语句
write multiple update statements inside a stored proc