| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| About types of indexes in SQL server ? | Cognizent | 1 |
| Which command using Query Analyzer will give you the version
of SQL server and operating system? | | 3 |
| what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1; | Patni | 6 |
| I need a query that retrieves info from an Oracle table and
a query that retrieves info from a SQL Server table. The
info has to be joined together according to Record ID
numbers. I have very limited access to the Oracle database
but full control of the SQL Server database.How do I join
two different queries from two different databases?
| | 1 |
| create procedure proc1 (@a int)
as
begin
if @a=1
create table #temp(a1 int)
else
create table #temp(a1 int)
end
while executeing the above code it shows error
like '#temp already exist' .why it shows an error? | IBM | 1 |
| What r sql reporting services and analysis services? how
can we use it. | | 2 |
| what is the purpose of creating view is sql server 2000 | Wipro | 6 |
| what are batch in sql server?
| Satyam | 2 |
| How m-m relationships are implemented? | | 1 |
| SQL stops working in every 15 days displaying message that
database log file is full. Log file size is 3.95 GB. It is
happening after shrinking the database also. What is
solution to overcome this problem. Please help me as it's
urgent. | | 2 |
| What is the difference between temp table and table variable? | Microsoft | 3 |
| how to connect sybase to sql server 2005?. | ABC | 1 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | HCL | 2 |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| Can you explain the role of each service? | | 1 |
| What is the difference between 2-Tier architecture and
3-Tier architecture | Oracle | 5 |
| How to write query to Delete the records in child table
and corresponding records in parent table | Semantic-Space | 7 |
| how many type of subquery? | | 1 |
| Explain some DBCC commands? | | 3 |
| What's the purpose of Stored Procedure? | Wipro | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
