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

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

0 Answers   IBM,

---

can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

---

What are the different types of join?

0 Answers  

---

What is identity?

0 Answers  

---

State the difference between local and global temporary tables?

0 Answers  

---

Do you know what are different types of replication in sql server?

0 Answers  

---

What is the difference between local table and global table

1 Answers   CarrizalSoft Technologies, Polaris,

---

Explain what is lock escalation and what is its purpose?

0 Answers  

---

how to get the rowid/rownumbes of a table in sqlserver

7 Answers   IBM,

---

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

0 Answers  

---

Questions regarding Raiseerror?

1 Answers  

---

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---