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 create a new login name in ms sql server?

1063

How to create a view with data from multiple tables?

1012

How to retrieve field values using mssql_result()?

1313

How to convert a numeric expression from one data type to another?

1015

How to join two tables in a single query in ms sql server?

993

How to count groups returned with the group by clause in ms sql server?

1065

How to access the deleted record of an event?

1040

How to locate and take substrings with charindex() and substring() functions?

1016

How to list all tables in the database using odbc_tables()?

1050

What are approximate numeric data types in ms sql server?

1059

What are null values in ms sql server?

1088

How to set a database state to offline in ms sql server?

1046

How to list all triggers in the database with sys.triggers in ms sql server?

1081

How to verify a user name with sqlcmd tool?

1080

How to use go command in "sqlcmd"?

1204

Un-Answered Questions { SQL Server }

What are basics of policy management?

1102

What is attribute hierarchy? : sql server analysis services, ssas

1018

What is bcp? When does it used?

976

what are the different stages of Report Processing?

135

what is normalization? : Sql server database administration

1095

What programming language would you use to create embedded functions in ssrs?

184

Is sql server 2016 free?

935

How to automatically create a log when an exception is being received into SQL Server?

1287

How to change the ownership of a schema in ms sql server?

1193

What will happen if a column containing char type data is changed to the nchar data type?

1102

What is an identity?

1018

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

1092

How can you append an identity column to a temporary table?

953

What is the process of normalization?

1124

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1066

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