What is a cursor, index in sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is the maximum size of a row in sql server?
How to generate create function script on an existing function?
Explain the new features of SQL server 2000?
Write an sql query for deleting duplicate rows?
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
Explain transaction server explicit transaction?
Where views are stored in sql server?
What is partition in sql server?
tell me the disaster recovery plan
Tell me what is fill factor?
What is ddl command?
What is the difference between varchar and nvarchar?