Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
Insert Values in Four Tables at a time
Ronok Bhowmik
Feb 21 2014 12:30 PM
1.1k
Reply
Here is my sql query.I have four tables. they are
Floors(FloorId(pk),FloorName),
Blocks(FloorId(fk),BlockId(pk),
BlockName)
Rooms(BlockId(fk),RoomId(pk),
RoomName)
Seats(RoomId(fk),
SeatId(pk),SeatName)
.I want to Insert Values in Floors,Blocks, Rooms,Seats Tables at once.
******************************
******************************
******************************
*******
USE [NewDatabase]
GO
/****** Object: StoredProcedure [dbo].[uspinsertion] Script Date:
02/18/2014 20:52:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[uspinsertion]
(
@FloorId int,
@FloorName nvarchar(20),
@BlockId int,
@BlockName nvarchar(20) ,
@RoomId int,
@RoomName nvarchar(20),
@SeatId int,
@SeatName nvarchar(20)
)
as
begin
set nocount on
DECLARE @RecordID INT
Declare @RecordID1 int
Declare @RecordID2 int
insert into Floors(FloorId,FloorName)
Values(@FloorId,@FloorName)
SET @RecordID=Scope_Identity()
insert into Blocks (FloorId,BlockId,BlockName)
Values (@RecordID,@BlockId,@
BlockName)
set @RecordID1=Scope_Identity()
insert into Rooms (BlockId,RoomId,RoomName)
Values (@RecordID1,@RoomId,@RoomName)
set @RecordID2=Scope_Identity()
insert into Seats (RoomId,SeatId,SeatName)
Values (@RecordID2,@SeatId,@SeatName)
End
Return
What is the problem in this sql query.Fail to fix it.Need help.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
SQL Server installation
How to solve this error?