SQL Server Interview Questions
Questions Answers Views Company eMail

What is updatable resultset?

514

Is port 1433 secure?

536

How do I open port 1433?

521

What is meant by dirty read?

554

How does recursive cte works in sql server?

524

What is correlated subquery in sql server?

557

What do you mean by sql server 2005 express management tools?

786

Can we use max in where clause?

511

What is the use of group by clause?

525

Can we use where and having clause together?

506

Can we use where clause with group by?

514

Can we use where clause in union?

593

Can we use having clause without group by?

556

How do I create a stored procedure in dbml?

514

What is db stored procedure?

467


Un-Answered Questions { SQL Server }

How to retrieve error messages using mssql_get_last_message()?

531


Explain the categories of stored procedure?

518


What is the tcp/ip port on which sql server runs?

564


How to divide query output into multiple groups with the group by clause in ms sql server?

563


How to override dml statements with triggers?

578






what is dbcc? : Sql server database administration

519


Can we linked SharePoint to a SQL database?

587


What is the bookmark lookup and rid lookup?

566


Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

552


How to convert a numeric expression from one data type to another?

500


What is difference between count (*) and count column?

522


what are acid properties? : Sql server database administration

490


How to connect php with different port numbers?

551


Explain can you implement data mining in ssrs?

106


How do I clean up sql server transaction log?

568