How to invoke a trigger on demand?
No Answer is Posted For this Question
Be the First to Post Answer
What gets stored inside msdb database?
Which command executes the contents of a specified file?
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
what is physical sort data and logical sort data in index?
Define Foreign Key?
3 Answers ADP, College School Exams Tests,
How to recreate an existing index in ms sql server?
What is user stored procedure & it purpose?
What are the types of indexes available with SQL Server?
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.
What happens if an integer is too big for int date type?
How to display a past time in days, hours and minutes?