How to find out what is the default collation in a database?
No Answer is Posted For this Question
Be the First to Post Answer
Explain collation?
What is transaction server auto commit?
What is a unique index?
Can the “if update (colname)” statement be used in a delete trigger?
What are the properties of the transactions?
What is a with(nolock)?
Explain system scalar functions?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is difference between joins and subqueries?
What are the purposes of floor and sign functions?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Write a sql query to sort on different column name according to the parameters passed in the function?