| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Can anybody explain me cold backup and hot backup?
| TCS | 3 |
| Which is better in performance - CONSTRAINT or TRIGGER over
a column which restricts say an input of particular value
in a column of a table? | Accenture | 3 |
| MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE | IBM | 1 |
| There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better? | | 1 |
| what is difference between having and where clause ? | | 2 |
| What is the difference between windows authentication and
sql server authentication | HCL | 4 |
| i want only duplicates rows from coloumn
ex. emp_id(colomn name)1,1,2,3,3,4,5,5.
so i want only duplicates no.
| iFlex | 2 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | | 1 |
| 1.How to check the backup file details if we do not have
access to that folder
2.how to check the backup file size without connecting to
the folder
| IBM | 1 |
| HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE | TCS | 16 |
| What is the difference between local table and global table | Polaris | 1 |
| IN Vs OR operator which is best to use sql server. | | 3 |
| Hi SQL gurus,
i am working for an MNC...
My team is having a problem in sql server. when user slects
date prompts from jan 1st to april 30, it should display
all months data like :
jan aa
feb bb
mar cc
but when it comes to april its taking data like :
jan aa
feb bb
mar cc
apr dd...and so on
means its taking data again from jan to april which we dont
want. we want the data only april month as we are getting
jan, feb and mar...
can any one write the code to relsove the issue please
would be greatful if you can send to shiva_sans@yahoo.co.in
and also please send your email also ...so that we will be
in touch for any kind of queries ...
Thanks a lot in Advance !!!
| | 1 |
| How to Get the last identity value used | | 4 |
| How to write a script for upate the data in prod , i have
50000 row are there | TCS | 2 |
| What is the basic functions for master, msdb, tempdb databases? | CSC | 2 |
| Which is best Subquery (or) joins in sql server? explain why | | 2 |
| How To Change Column Ordinal Position in SQL Server 2005
using Query i.e I Want To Add Column at Particular Ordinal
Position in SQL Server 2005 | | 2 |
| What is the difference between temp table and table variable? | Microsoft | 4 |
| How the data stores in a page? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |