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
Go to Top of Page
   

- Advertisement -