SQL Server Interview Questions
Questions Answers Views Company eMail

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

846

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

817

How to provide default values to stored procedure parameters?

796

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

818

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

769

Where to find ntwdblib.dll version 2000.80.194.0?

773

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

913

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

819

How to turn on the mssql api module in php?

796

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

797

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

837

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

919

Does index speed up select statements?

779

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

783

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

746


Un-Answered Questions { SQL Server }

What is the difference between SQL notification and SQL invalidation?

830


Where in ms sql server is ’100’ equal to ‘0’?

844


How to concatenate two character strings together?

817


What languages bi uses to achieve the goal?

737


Distinguish between commit and rollback?

732


How to download and install sql server 2005 books online?

807


Give a example to search fr a string in all stored procedure in sql server.

733


What is perspective, have you ever created perspective? : sql server analysis services, ssas

705


What according to you is the difference between mysql and sql server performance?

804


What are the High-Availability solutions in SQL Server and differentiate them briefly?

934


What is the parse query button used for?

824


How to copy the tables, schema and views from one sql server to another?

781


What are the different types of lock modes in sql server 2000?

672


What is the datatype of rowid?

698


What are the types of indexing?

869