What are the authentication modes in sql server? How can it be changed?
No Answer is Posted For this Question
Be the First to Post Answer
List the different types of joins?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What are the different ways of moving data/databases between servers and databases in SQL Server?
What is enhanced database mirroring in sql server 2008?
In what version of sql server were synonyms released?
Difference between report and query parameter. Why do we need different type of parameter?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
what is for foreign key ??
4 Answers CarrizalSoft Technologies, Sabic,
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
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 are the parts of a function?
wat is tuff file in log shipping, wt is d use of tht file?