1.what are diff types of joins , and explain diff between cross join and full outer join
2.diff types of views
3. Diff types of index
4. What is diff b/w stores procedure and function procedure
5.diff between double and int in SQL
6.diff between char and varchar in SQL.
7.Oracle or SQL whice you will preferred and why.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Write a query to get all details of employee who has maximum salary from employee table

8 Answers   AON, Genpact,


What is difference between views and stored procedures?

0 Answers  


What are the types of model in sql server and explain

2 Answers   TCS,


SQL Server Architecture ?

0 Answers   IBM, Sapient,


What are the advantages of user-defined functions over stored procedures in sql server?

0 Answers  






Mention the differences between local and global temporary tables.

0 Answers  


How do I save a stored procedure in sql server?

0 Answers  


Should you normalize audio?

0 Answers  


Define Foreign Key?

3 Answers   ADP, College School Exams Tests,


What are the tool windows in sql server management studio? : sql server management studio

0 Answers  


What is Data model and how to prepare a data model.?

1 Answers   TCS,


what's the difference between a primary key and a unique key? : Sql server database administration

0 Answers  


Categories