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 find the login name linked to a given user name?

152

How to rename databases in ms sql server?

172

How to select all columns of all rows from a table with a select statement in ms sql server?

153

How to create a dml trigger using create trigger statements?

150

How to set database to be read_only in ms sql server?

160

What is the simplest way to create a new database in ms sql server?

135

How to connect ms access to sql servers through odbc?

139

How to add an address record into adventureworkslt?

171

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

161

How to create a new schema in a database?

149

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

143

How to define the name and server for a new dsn?

164

How to create a trigger for insert only?

167

How to delete a login name in ms sql server?

146

What are the differences between decimal and float in ms sql server?

158

Un-Answered Questions { SQL Server }

A trigger can reference objects outside the current database? State true or false.

158

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

201

How display code or Text of Stored Procedure using Sql query in Sql Server ?

173

How many types of database relationship in sql server?

153

What is a functions and types in sql server?

160

How do you drop an index?

116

Why should you use or avoid select * statements?

141

Equi join and non equi join is possible with sql server?

146

What are the mathematical functions supported by sql server 2005?

153

How many types of the database links?

185

How you can get the list of largest tables in a database?

147

What is update locks?

129

Can two tables share a primary key?

118

Why do we use functions?

116

What is an indexing technique?

112

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