What is difference between cte and view?

907

Define right outer join in sql server joins?

1038

What is normalization? Describe its different types.

1099

Explain the database you used in your final year project?

1032

How to divide query output into multiple groups with the group by clause in ms sql server?

1028

What do you think of this implementation? Can this be implemented better?

931

What is conditional split?

1060

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1942

What is join query?

881

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

1037

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

945

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1249

how you can move data or databases between servers and databases in sql server? : Sql server administration

957

What is difference between foreign key and unique key?

1003

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1045