Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

insert multiple rows into variable Expand / Collapse
Author
Message
Posted Thursday, May 17, 2012 6:45 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 6:43 PM
Points: 293, Visits: 127
I took one look at this article and thought "What's so special about this?" It's hardly revolutionary!

I used to call my self The Master on forums, then I entered the IT industry and realised how much I still have to learn.
Post #1302222
Posted Friday, May 18, 2012 2:23 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:01 AM
Points: 1,151, Visits: 878
Boltz42 (5/17/2012)
I took one look at this article and thought "What's so special about this?" It's hardly revolutionary!


I agree. I do not see the purpose for this. You would anyway need a loop to get the values again.


Manie Verster
Developer
Johannesburg
South Africa

Life is about choices.... I choose to be happy today
Post #1302329
Posted Friday, May 18, 2012 7:19 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 19, 2013 9:30 AM
Points: 24, Visits: 37
The reason the script is not revolutionary is because other like Erland Sommarskog performed a lot of testing to figure out the best way to do it (http://www.sommarskog.se/arrays-in-sql-2005.html). In SQL Server 2005, a comma-delimited list is a great way to pass primary and foreign key values between stored procedures and between applications and the database.
Post #1302506
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse