SQL Server Interview Questions
Questions Answers Views Company eMail

How to Insert multiple rows with a single insert statement?

543

What is autocommit mode in sql server?

540

How to get @@error and @@rowcount at the same time?

560

What is temporary stored procedure?

543

Explain query editor regions

610

Which are the important points to note when multilanguage data is stored in a table?

510

What is default constraint?

537

Explain table valued parameters in sql server? Why tvp used?

553

How to return the date part only from a sql server datetime datatype?

571

What is difference between delete and truncate commands?

521

What is implicit mode in sql server?

552

What is Extended user-defined?

531

what is hash nonclustered index

530

Find columns used in stored procedure?

520

How to rebuild the master database?

572


Un-Answered Questions { SQL Server }

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

528


Explain syntax for viewing trigger?

533


Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

497


What is report rendering ?

102


Which is the latest version of sql server and when it is released?

538






Can we call stored procedure in trigger?

543


What is sql service broker?

586


Explain different types of collation sensitivity?

526


Why are sql functions used?

615


Is it possible to create trigger on views?

545


Why do we partition data?

611


Can a table be moved to different filegroup?

564


How to use order by with union operators in ms sql server?

570


The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

518


How to get the definition of a user defined function back?

561