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

How can sql injection be stopped? : sql server security

0 Answers  

How to create database with physical files specified in ms sql server?

0 Answers  

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

What is checkpoint process in the sql server?

0 Answers  

SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES

1 Answers   Microsoft,

Magic Tables ?

2 Answers   Thomson Reuters,

What is the use of partition by in sql server?

0 Answers  

Is INSTEAD OF trigger directly applicable to Table ?

0 Answers  

What do you understand by sql server agent?

0 Answers  

What is Covering Indexes? Plz explain with example

3 Answers  

How to connect ms access to sql servers through odbc?

0 Answers  

What is the default sql server instance name?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories