When would you use it?
No Answer is Posted For this Question
Be the First to Post Answer
What happens if null values are involved in datetime operations?
What are the mathematical functions supported by sql server 2005?
Why we should not use triggers?
how we can store the value like that 001,003,023 etc in sql server 2005
What are the steps to follow to configure SQL*Net?
Explain syntax for viewing, dropping and disabling triggers?
Explain what is public role in sql server?
Does hive support indexing?
How to transfer an existing table from one schema to another schema in ms sql server?
How do I run a trace in sql server?
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
write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?