Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



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