Insert A List OF Data To sql

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Insert A List OF Data To sql

Insert A List OF Data To sql

Rate Topic

Display Mode

Topic Options

Author

Message

vahid.arr

Posted Saturday, September 22, 2012 6:21 AM

SSC Rookie

Group: General Forum Members
Last Login: Saturday, May 04, 2013 12:11 PM
Points: 42, Visits: 130

I write bellow query For Insert Data but I want my Store Procedure take A List OF Data and insert it.how can i change That?

create procedure AtashSooziFloorInsert
@AtashSooziID int,@FloorID int
as
begin
insert AtashSooziFloor (AtashSooziID,FloorID)
 values(@AtashSooziID,@FloorID)
end

Post #1363100

bitbucket-25253

Posted Saturday, September 22, 2012 7:21 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:13 PM
Points: 5,103, Visits: 20,214

To assist those who desire to assist you, could you supply a short sample of the "list of data" that you need to insert.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #1363103

ESAT ERKEC

Posted Saturday, September 22, 2012 8:16 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:46 AM
Points: 222, Visits: 707

SELECT 'EXECUTE AtashSooziFloorInsert ' + CAST(AtashSoozId as varchar(100))+ '
CASTFloorID as varchar(100)) FROM ImportedTable

then you can execute this list of sql
or you write a cursor and then execute all sql

Post #1363105