SQL Server Interview Questions
Questions Answers Views Company eMail

What is an identity column in insert statements?

651

Where are sql server user names and passwords stored in sql server?

624

What is the difference between substr and charindex in the sql server?

583

What is the difference between getdate and sysdatetime?

629

What is the use of for clause?

665

What are scheduled tasks in sql server?

646

What is bulkcopy in sql?

634

Which command is used for user defined error messages?

646

What is the use of sign function?

639

What is the difference between varchar and nvarchar types?

1 892

What will be query used to get the list of triggers in a database?

642

What are the two authentication modes in sql server?

698

Can we check locks in database? If so, how can we do this lock check?

610

What is sub query and its properties?

639

What is the use of @@spid?

656


Un-Answered Questions { SQL Server }

What is normalization? Describe its different types.

672


How do I create a trace in sql server?

604


What are scalar functions in sql?

710


whats the maximum size of view state??

1814


Explain syntax for viewing trigger?

618






How many levels of sp nesting is possible?

683


What is query cost in sql server?

645


What is the difference between varchar and nvarchar datatypes?

657


Explain transaction server explicit transaction?

596


is there a column to which a default can't be bound? : Sql server database administration

635


What is triggers and its types?

627


How do I view a script in sql server?

624


What is a rownum?

588


How to connect php with different port numbers?

641


How to assign null values to variables or columns?

632