SQL Server Interview Questions
Questions Answers Views Company eMail

How to replace given values with null using nullif()?

762

How to insert new line characters into strings?

753

How to sort query output in descending order in ms sql server?

770

How to start and end transact-sql statements?

775

What is sqlservr.exe - process - sql server (sqlex?press)?

826

How to get a list of all tables with "sys.tables" view in ms sql server?

807

How to attach adventureworkslt physical files to the server?

852

How to download and install microsoft sql server management studio express?

782

Does the unique constraint create an index?

767

How to use column default values in insert statements in ms sql server?

759

How to get a list of columns using the "sys.columns" view in ms sql server?

770

What is mscorsvw.exe - process - microsoft .net framework ngen?

730

How to delete an existing database user?

786

How to rebuild all indexes on a single table?

807

How to write a query with an inner join in ms sql server?

783


Un-Answered Questions { SQL Server }

Why do we need different type of parameter?

795


How to use “drop” keyword in sql server and give an example?

905


What is partition in sql server?

749


How is SQL Azure different than SQL server?

124


How to find the second highest salary of an employee?

831


What is the order by used for?

809


What have included columns when we talk about sql server indexing?

800


Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

898


What are the differences between decimal and float in ms sql server?

795


How to automatically create a log when an exception is being received into SQL Server?

968


What are “lost updates”?

809


What is difference between materialized view and view?

721


Why use view instead of a table?

734


Can I delete event logs?

735


What is lookup override?

797