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 enter comments in transact-sql statements?

896

How to loop through result set objects using mssql_fetch_array()?

1022

How to use user defined functions in expressions?

1009

How to use group functions in the select clause in ms sql server?

996

How to list all dsn entries on your local machine using odbc_data_source()?

979

How to count rows with the count(*) function in ms sql server?

952

What happens if the update subquery returns multiple rows in ms sql server?

1058

What happens if the update subquery returns no rows in ms sql server?

1075

How to change the name of a database user?

911

What is the security principal at the database level that represents your session?

896

How to loop through result set objects using odbc_fetch_row()?

921

What are triggers in ms sql server?

1105

How to disable triggers using "disable trigger"?

1002

Can the query output be sorted by multiple columns in ms sql server?

937

How many ways to create table-valued functions?

935

Un-Answered Questions { SQL Server }

How to list all columns in a table using odbc_columns()?

938

how can u get last observation in an unknown dataset ?

2388

What are various aggregate functions that are available?

918

What is dbcc command in sql server?

1021

How to edit table in sql server 2017?

881

What are the source of constraints?

860

What is purpose of normalization?

899

What stored by the model?

984

What is table join?

1069

What is a periodical index?

865

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1064

Can we deploy SSRS reports on our personal website?

162

What is the difference between varchar and varchar(max) datatypes?

1005

What number aggregate functions are accessible there in sql?

1009

How to store and query spatial data?

937

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