List out the different types of locks available in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Is sql server is free?
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 stored procedure can you use to display the current processes?
Explain what is analysis service repository?
How to create function without parameter in sql server?
How to list all field names in the result set using mssql_field_name()?
How would you add a section to a table?
What is the difference between coalesce() & isnull()?
Write a SQL queries on Self Join and Inner Join.
Explain nested join?
Can we write a distributed query and get some data which is located on other server and oracle database?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?