Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 data insert

Author  Topic 

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2011-05-14 : 22:37:17
HI,

Is there any sp/query to insert data into sql server 2005 existing table.

Thank you.

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2011-05-15 : 05:57:00
Most of the activities that are done in a database are either inserting, deleting, or updating data into existing tables and then retrieving the data. So, certainly you can insert data into a table using queries.

You can google for "insert in sql database", for example: http://www.w3schools.com/sql/sql_insert.asp

There are no built-in stored procedures to insert data into tables. People usually write their own stored procs depending on the needs.

Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2011-05-15 : 13:42:48
If you check INSERT on BOL , you will see a wide range of INSERT uses- from a simple INSERT statement to a BULK loading . Could you specify your exact requirement , with an example?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -