SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

How to insert and update data into a table with "insert" and "update" statements?

977

How to change the data type of an existing column with "alter table" statements in ms sql server?

980

What happens when converting big values to numeric data types?

1122

Can we delete data from a view?

919

How to update multiple rows with one update statement in ms sql server?

1200

What happens if an integer is too big for int date type?

968

Can binary strings be used in arithmetical operations?

928

What is a transact-sql statement?

1050

How to create stored procedures with parameters in ms sql server?

1070

How to specify the collation for a character data type in ms sql server?

1023

Does index slows down insert statements?

995

What are the basic features of a trigger in ms sql server?

1184

Where is my database stored on the hard disk in ms sql server?

1056

What is a database in ms sql server?

1055

What are commonly used mssql functions in php?

1072

Un-Answered Questions { SQL Server }

Mention a few common trace flags used with sql server?

925

What is a DBMS, query, SQL?

1045

Explain what is the use of custom fields in report?

916

What are the new features of sql server 2012 reporting service?

133

How do I debug a stored procedure in sql server?

1097

Mention the differences between sql server and mysql.

1010

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

937

What are the tool windows in sql server management studio? : sql server management studio

1069

Do you know what are pages and extents? : SQL Server Architecture

990

Which sql server table is used to hold the stored procedure script?

944

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

1006

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

987

what is a self join? : Sql server database administration

1030

What are date and time data types in ms sql server?

1084

How to start sql server browser service?

1128

For More Un-Answered { SQL Server } Questions Click Here