Calendar

October 2014
M T W T F S S
« Jun    
 12345
6789101112
13141516171819
20212223242526
2728293031  

Q18. What is the difference between the Database and Datawarehouse?

Please visit SQLVERSITY.COM for more details.

(more…)

Q17. What is the difference between COUNT(*) and COUNT(Column Name)?

Please visit SQLVERSITY.COM for more details.

(more…)

Q16. What are the GRANT permissions we can give to different types of database objects?

Please visit SQLVERSITY.COM for more details.

(more…)

Q15. What is the difference between Clustered & Non Clustered Indexes?

Please visit SQLVERSITY.COM for more details.

(more…)

Q14. What are the System databases available in SQL Server?

Please visit SQLVERSITY.COM for more details.

(more…)

Q13. What is the basic difference between ROW_NUMBER, RANK and DENSE_RANK functions?

Please visit SQLVERSITY.COM for more details.

(more…)

Q12. What is RAISERROR()? Where do you use this?

Please visit SQLVERSITY.COM for more details.

(more…)

Q11. What is the difference between the basic datatypes Char and Varchar?

Please visit SQLVERSITY.COM for more details.

(more…)

Q10. What is meant by the error ‘String or binary data would be truncated. The statement has been terminated’?

Please visit SQLVERSITY.COM for more details.

(more…)

Q9. How do you rename a table or column name?

Please visit SQLVERSITY.COM for more details.

(more…)

Follow

Get every new post delivered to your Inbox.