What is the main difference between ‘between’ and ‘in’ condition operators?
No Answer is Posted For this Question
Be the First to Post Answer
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
Does table partitioning improve performance?
how you can get the list of largest tables in a database? : Sql server administration
Do you know what are pages and extents? : SQL Server Architecture
What is the ‘fillfactor’?
what is a deadlock? : Sql server database administration
What is #table in sql server?
What number aggregate functions are accessible there in sql?
What is Pointer ?
3 Answers Cap Gemini, CarrizalSoft Technologies,
What are the restraints imposed on the table design by a merge replication?
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 ?
Is t sql the same as sql server?