SQL Server Interview Questions
Questions Answers Views Company eMail

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

787

How to insert new line characters into strings?

772

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

787

How to start and end transact-sql statements?

805

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

849

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

824

How to attach adventureworkslt physical files to the server?

881

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

807

Does the unique constraint create an index?

782

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

793

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

798

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

745

How to delete an existing database user?

807

How to rebuild all indexes on a single table?

829

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

798


Un-Answered Questions { SQL Server }

What does COMMIT command do?

839


What are the purposes of floor and sign functions?

790


When cursors are useful?

817


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1815


Where is trigger in sql server?

782


What is a scheduled job or what is a scheduled task?

773


explain different types of constraints? : Sql server database administration

761


why would you use sql agent? : Sql server database administration

850


List down some advantages of sql stored procedure?

760


How to change parameter value inside the report?

133


Explain about nested stored procedure?

841


When to use null data driven subscription?

190


What are the five major components of a dbms?

719


How is table type constraint applied to a table?

780


What is the status of services on passive node for failover cluster in sql server? : sql server database administration

917