| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| I am Having tables T1 and T2 both having same data how to
check (or) compare the data in both table are same? | | 2 |
| Can I remove the default constraint columns in SQL SERVER? | Value-Labs | 3 |
| What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance.... | Siemens | 6 |
| What is a Linked Server? | | 1 |
| Explain the storage models of OLAP? | | 1 |
| hi,
i have a table called names and field name
select * from names
name
a
b
c
d
i want to display like this
name
a,b,c,d
how it is possible
Regards
Baiju | | 3 |
| How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name? | | 3 |
| How would you Update the rows which are divisible by 10,
given a set of numbers in column? | | 1 |
| 9. Write a query to list a new column with the
difference in temp of the cities Delhi and Mumbai, Mumbai
and Jammu and soon. Consider the following table :
City_id City Temp.
1 delhi 40
2 Mumbai 35
3 Jammu 32
4 Pune 18
| | 2 |
| what is Archive old data? | | 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. | | 5 |
| What is the difference between OLEDB and ODBC | CFCI | 3 |
| What is the Query of getting last 10 transaction Reports
(like insert, update, Delete Data from Tabele) ? | Wipro | 4 |
| What is Trigger? | Misys | 2 |
| Can we rewrite subqueries into simple select statements or
with joins? Example? | ASD | 1 |
| How to write query to Delete the records in child table
and corresponding records in parent table | Semantic-Space | 8 |
| Rate yourself in .NET and SQL ? | Cognizent | 1 |
| Assume,there are three tables in a database, Can i have
both primary key and foreign key for each table in the same
database? | | 4 |
| what is diffence between replicaion and logshipping? | | 1 |
| What is deadlock and how to avoid the deadlocks. | 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
