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?

980

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

1083

How to delete a database in ms sql server?

1234

Can you roll back the ddl statement in a trigger?

968

What are character string data types in ms sql server?

1248

How to modify existing triggers using "alter trigger"?

1017

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

1092

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

981

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

961

Can you pass expressions to function parameters?

1103

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

1010

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

1091

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

1168

How to create a local temporary stored procedure?

998

What happens if null values are involved in datetime operations?

975

Un-Answered Questions { SQL Server }

What is wide table?

948

What is rs.exe utility?

156

What are approximate numeric data types in ms sql server?

1059

What are sp_configure commands and set commands?

1022

What are the instances when triggers are appropriate?

979

role of sql sever 2005 in database rather than any other database

1939

How to use values from other tables in update statements in ms sql server?

1117

Do you know what is rank function?

1073

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2075

Explain what are the restrictions while creating batches in sql server?

1068

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1847

What to perform pattern match with the like operator?

883

How do database indexes work?

1009

Tell me when is the update_statistics command used?

1111

How to find which stored procedure is currently running in sql server?

994

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