Answer / rakesh c sunagar

--select name from #t where ISNUMERIC(name)<>1
--union
--select name from #t1

Answer / rajesh

to get zero u must apply intersect set statement between
select statements of table1 and select statement of table2
syntax:
select * from t1
intersect
select * from t2

Answer / sreekanthb87

t1
A,2,3,4
t2
1,2a,3a,4a
now union of tw0 table must be
A,1,2,2a,3,3a,4,4a

now how you write the qurey ,the answer should be
A,1,2a,3a,4a

How make remote connection in database?

1 Answers  

---

What are the different acid properties?

0 Answers  

---

How exceptions can be handled in sql server programming?

0 Answers  

---

what is Buffer cash and Log Cache? Can you Explain it?

1 Answers   Wipro,

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

what is the difference between Delete and Truncate command in SQL

0 Answers   BirlaSoft,

---

How to add a new dsn with the odbc driver for sql server?

0 Answers  

---

Can I work with several databases simultaneously? : sql server management studio

0 Answers  

---

What are the High-Availability solutions in SQL Server and differentiate them briefly?

0 Answers  

---

Describe and explain about SQL native client?

0 Answers  

---

can an order by clause be used in a creation of a view?

0 Answers  

---

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

---