How to invoke a trigger on demand?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What gets stored inside msdb database?

0 Answers   Abacus,


Which command executes the contents of a specified file?

2 Answers   ABC, InfoMedia,


what is node in sql server?

2 Answers   CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,


In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,


what is physical sort data and logical sort data in index?

2 Answers  






Define Foreign Key?

3 Answers   ADP, College School Exams Tests,


How to recreate an existing index in ms sql server?

0 Answers  


What is user stored procedure & it purpose?

4 Answers   Wipro,


What are the types of indexes available with SQL Server?

2 Answers   Standard Bank,


How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,


What happens if an integer is too big for int date type?

0 Answers  


How to display a past time in days, hours and minutes?

0 Answers  


Categories