OP wrote:
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 customize things based on your need. Also use
Try Catch
.
OP wrote:
What is errorlog & How to use?
Here you go
SQL Server Error Logs[
^]
SQL Server 2005 Error Log Management[
^]