You can use XML. Pass XML value as a parameter to SQL procedure and you can use XML functions like nodes(),query() etc inside SQL to shred the XML data out and store it in your tables.
Where does your data come from? If its from flat file or something you can use BULK INSERT statement itself for saving data to table directly.
Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs
No comments:
Post a Comment