Explain different backup plans?
WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.
How do I find the default sql server instance?
How to test subquery results with the exists operator?
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
How to include text values in sql statements?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
do views contain data ?
What are functions in the sql server?
How many types of cursor type are there?
Describe in brief authentication modes in sql server.
how to insert the values in 5 table at a time Using any single statement ?
6 Answers Infosys, Value Labs,
Tell me what are the essential components of sql server service broker?