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
 Database Design and Application Architecture
 create functions for insert, update, delete querie

Author  Topic 

jonekim
Starting Member

35 Posts

Posted - 2011-12-19 : 03:43:24
Every time I create a database project, I've to write the queries for inserting, updating, deleting functions and for other SQL qeeries.

Is there any way of creating functions for such queries and just passing the arguments for required queries as per our need?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-19 : 03:49:46
you can use template explorer available in sql management studio if you want to get templates. you can also store custome templates created inside it so that next time you want to use them, you can just drag and drop them and add values to required placeholders

use view->template explorer to launch it in sql management studio

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -