Explain the disadvantages of cursors?
No Answer is Posted For this Question
Be the First to Post Answer
Why do we use trigger?
Explain the difference between delete,drop and truncate in SQL Server?
What is indexing explain it with an example?
DIFFERENCE BETWEEN SQL SERVER 2005 and 2008
What is the difference between dataadapter and datareader?
1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?
What is a trace frag?
What is b tree index?
What are Magic Table?
34 Answers 3i Infotech, Digiweb, Evalueserve, NIIT, PL,
How to check if a table is being used in sql server?
What is master database? : SQL Server Architecture
What are the advantages of user defined function?