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.
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.aspThere are no built-in stored procedures to insert data into tables. People usually write their own stored procs depending on the needs. |
 |
|
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 |
 |
|
|
|
|