Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Can I know,how to Execute Funcion and Trigger through
command(Manualy Execution) in MS SQL/SERVER 2005,give me
answer with Example.

Question Posted / digvijay singh


Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER ..

Answer / bhaskar


Function can excute by the SELECT statement
ex SELECT Functionname(parameters), select *from
functionname

select s_func(Parameters)

We cant execute the trigger ,
When we perform a DML(DELETE,INSERT,UPDATE) operation
Trigger will fire automatically

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the types of indexing?

0 Answers  

Explain sql server service broker?

0 Answers  

How do you troubleshoot SQL Server if its running very slow?

2 Answers   HP,

what is the difference between sql query and google query?

10 Answers   TCS,

What is the need for group functions in sql?

0 Answers  

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  

What is indexed view?

0 Answers  

What stored by the msdb? : sql server database administration

0 Answers  

Define constraints and give an example of their use?

0 Answers  

Mention the differences between having and where clause.

0 Answers  

What is nolock?

0 Answers  

find 2nd highest salary of person using cursor concept?

6 Answers   HCL,

For more SQL Server Interview Questions Click Here
Categories