Insert query or Insert into - SQL Server Forums

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

SQL Server 2005 Forums

Transact-SQL (2005)

Insert query or Insert into

Author

Topic

sanjay5219
Posting Yak Master

240 Posts

Posted - 2012-11-26 : 03:38:52

Hi All,

Wanted to check wheather we should use Insert Query or Procedure while inserting record from front end

Please suggest

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2012-11-26 : 04:12:11

Check this

http://blog.sqlauthority.com/2007/04/13/sql-server-stored-procedures-advantages-and-best-advantage/

http://www.codinghorror.com/blog/2005/05/stored-procedures-vs-ad-hoc-sql.html

Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources