SQL Server Interview Questions
Questions Answers Views Company eMail

What is a subquery in a select query statement in ms sql server?

591

How to see the event list of an existing trigger using sys.trigger_events?

573

How to provide default values to stored procedure parameters?

580

How to defragment indexes with alter index ... Reorganize?

588

What is the default schema of your login session in ms sql server?

594

Where to find ntwdblib.dll version 2000.80.194.0?

560

What happens if ntwdblib.dll is missing on your machine?

639

How to disconnect from a sql server using mssql_close()?

591

How to turn on the mssql api module in php?

570

Can select statements be used on views in ms sql server?

582

How to create a ddl trigger using "create trigger" statements?

618

How to use old values to define new values in update statements in ms sql server?

686

Does index speed up select statements?

588

What happens if time-only values are provided as date and time literals?

534

Is the order of columns in the set clause important in ms sql server?

521


Un-Answered Questions { SQL Server }

What is join and name different type of joins?

584


What is sql stored procedure?

603


Can select statements be used on views in ms sql server?

582


What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

631


What are the hotfixes and patches in sql server?

547






What is normalization according to you and explain its different levels?

527


What are sparse columns?

586


How to insert a new row into a table with "insert into" statements in ms sql server?

541


What are the 3 types of schema?

604


How to get nth highest salary from employee table.

623


what is the main function of a query parameter?

111


if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

527


How to delete existing rows in a table?

593


What can be used instead of trigger?

631


Who developed sql server?

536