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

What are distributed partitioned views?

0 Answers  


What is the difference between a "where" clause and a "having" clause?

0 Answers  


what's sql server? : Sql server database administration

0 Answers  


Explain linked server in sql?

0 Answers  


Explain what are the events recorded in a transaction log?

0 Answers  






How do you troubleshoot errors in a SQL Server Agent Job?

0 Answers  


What protocol does sql server use?

0 Answers  


Can we drop user if user mapped to any logins

1 Answers  


How many types of functions are there in sql server?

0 Answers  


what is sql injection?

2 Answers  


How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

0 Answers  


Hi..here i would like to know the Backup and Restore models?

2 Answers   HCL,


Categories