What is data mart? : sql server analysis services, ssas
No Answer is Posted For this Question
Be the First to Post Answer
What is 1nf normalization form?
What are user-defined functions (udfs) in sql server?
How to apply cascading referential integrity in place of triggers?
Explain few examples of stored procedure over triggers?
How to download and install sql server 2005 books online?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
What stored by the master?
What is the difference between row_number and dense_rank?
What is msdb database? : SQL Server Architecture
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 the syntax for encrypting a column in SQL Server?
How do we return a record set from a Stored Procedure in SQl server 2000?