Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Can we passed multiple recordset(set of records) using a
Stored Procedure

Answer Posted / anil

just write DML sttements like insert into table1 values(),insert into table2 values()in stored procedure.By the way you can send multiple records at one time.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we use pragma autonomous_transaction in trigger?

910


How do you run a trace?

848


What is the syntax to execute the sys.dm_db_missing_index_details?

967


What is the fastest way to permanently delete a 1 million row table named customers?

1152


How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

958


Different types of keys in SQL?

1031


Differentiate between mongodb vs. Sql server?

1032


Does partitioning improve performance sql server?

897


whats new about truncate in sql server 2008?

2440


How connect excel to sql server?

929


How to verify a user name with sqlcmd tool?

1020


Why use identity in sql server?

1009


How many types of attribute relationships are there? : sql server analysis services, ssas

1000


What is filter index?

908


Explain the microsoft sql server delete command? : SQL Server Architecture

1007