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?

944

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

1078

How to use user defined functions in expressions?

1092

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

1053

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

1039

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

1015

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

1125

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

1124

How to change the name of a database user?

960

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

942

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

976

What are triggers in ms sql server?

1161

How to disable triggers using "disable trigger"?

1056

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

980

How many ways to create table-valued functions?

986

Un-Answered Questions { SQL Server }

What is temporal data type?

921

What is a file group?

1092

How is SQL Azure different than SQL server?

225

Which is the main third-party tool used in sql server?

942

What are the underflow and overflow behaviors on float literals?

1113

What is linked report?

131

Explain cdc and sql injection?

979

Can we call stored procedure in view in sql server?

898

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

970

What is the difference between ddl,dml and dcl commands?

1112

How to connect to SQL Azure Database by using sqlcmd?

136

How do I edit a stored procedure in sql server?

926

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

914

What are transactions and its controls?

1061

Is sql server a database?

998

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