SQL Server Interview Questions
Questions Answers Views Company eMail

What is updatable resultset?

507

Is port 1433 secure?

529

How do I open port 1433?

511

What is meant by dirty read?

546

How does recursive cte works in sql server?

515

What is correlated subquery in sql server?

547

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

775

Can we use max in where clause?

505

What is the use of group by clause?

517

Can we use where and having clause together?

502

Can we use where clause with group by?

509

Can we use where clause in union?

588

Can we use having clause without group by?

542

How do I create a stored procedure in dbml?

510

What is db stored procedure?

460


Un-Answered Questions { SQL Server }

What happens if null values are involved in arithmetic operations?

576


What is candidate key with example?

504


How do I setup a sql server database?

532


what is an extended stored procedure? : Sql server database administration

490


What are the system database in sql server 2008?

571






How to delete database objects with "drop" statements in ms sql server?

585


What does sql server mean?

528


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1790


Explain datetime2 data type in sal server 2008?

541


What is store procedure? How do they work? When do you use?

499


Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

580


What is unpivot?

558


What are audit control procedures?

580


Can we write ddl in trigger?

489


What is the purpose of sql profiler in sql server? : sql server database administration

616