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 fixed length strings are truncated and padded?

948

How to create a testing table with test data in ms sql server?

1025

How to delete a database in ms sql server?

1140

Can you roll back the ddl statement in a trigger?

920

What are character string data types in ms sql server?

1162

How to modify existing triggers using "alter trigger"?

952

How to delete an existing row with delete statements in ms sql server?

1033

How to transfer an existing table from one schema to another schema in ms sql server?

936

How to run sql server 2005 books online on your local system?

927

Can you pass expressions to function parameters?

1040

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

951

How to convert numeric values to integers in ms sql server?

1022

What are the advantages of passing name-value pairs as parameters?

1122

How to create a local temporary stored procedure?

955

What happens if null values are involved in datetime operations?

917

Un-Answered Questions { SQL Server }

How to select some specific rows from a table in ms sql server?

969

What are sparse columns?

963

What is history table in sql server?

905

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

965

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1816

List the various tools available for performance tuning?

847

What do you understand by replication in sql server? Mention the different types of replication in sql server.

900

What is the difference between dbcc indexdefrag and dbcc reindex?

945

what are the reporting service components in SSRS?

155

What are the types of dml?

939

What are the 3 types of schema?

1051

What is normalization 1nf 2nf 3nf?

1011

Can you please explain the difference between function and stored procedure?

967

Where can you find the error log information? : sql server database administration

988

How many types of objects are there?

948

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