A successfully created SSIS package in SQL Server 2005 runs
fine in MS BIDS and Integration Services. But gives error
when run through an SQL-Job. What are the possible reasons?
how to get the maximum among two tables,for example table 1
(dep1) have (emp_id,emp_name,salary) columns and table 2
(dept2) have (emp_id,emp_name,salary) columns,i want which
employee have the maximum salary among two tables?
One table Test with single column. These are the values in
the table
a
b
c
d
e
f
g
h
I need a query (without using any variable) with output as -
a b c
d e f
g h
Delete duplicate rows from a table without primary key by
using a single query
Table Employee
empname salary
A 200
B 300
A 200
C 400
D 500
D 500
Output should be
A 200
B 300
C 400
D 500
One table Test with single column. These are the values in
the table
a
b
c
d
e
f
g
h
I need a query (without using any variable) with output as -
a b c
d f f
g h
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
How to Improve the performencs of SQL Server 2005 exclude
stored Procedure and Indexes?
140
What will you do If the low Performance occurs?
33
role of sql sever 2005 in database rather than any other
database
142
A left outer join B
B right outer join A gives the same result then what is
the use of two?
27
How to know whether our backup is succesfully taken?
13
One table Test with single column. These are the values in
the table
a
b
c
d
e
f
g
h
I need a query (without using any variable) with output as -
a b c
d f f
g h
28
What is the difference between MVC and Teir Architecher?
Plz explain with Layyered Programming example...? Thanks
143
After recovering the database by using tail log backup.How
to verify the data has been sucessfully restored or not.?
Scalability, Availability, Integration with internet, etc.)?
152
You have modified 100 store procedures and want to
replicate these changes from development to prodution, and
production can have users using the Server/DB, how would
you replicate without causing issues?
103
how can you attach more than 20 ldf files in sql server
100
Give some Scenario for Non Clusterd index?
Can we write system defined functions in side The Function?
Wat is the Unique Datatype?
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
