I need to create a stored procedure which saves more than 1 records /actually the records can be 1 or 200/. It will be faster not to call this SP 200 times, but to pass all these 200 params (bigint) to stored procedure. How can I do this? In C# a similar case is solved with pass a string value for example 3454,4456,456546,1265 then to split the string and to loop. Is such approach possible with SP for MS SQL Server 2008 ?
Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed