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

What do mean by xml datatype?

0 Answers  

---

How to create prepared statements using odbc_prepare()?

0 Answers  

---

Can we execute a stored procedure inside a trigger?

6 Answers   BirlaSoft, CarrizalSoft Technologies, United Healthcare,

---

‘Order by’ is not allowed in a view how can you sort information from a view?

0 Answers  

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,

---

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers  

---

1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers   Perot Systems,

---

What is the difference between varchar and varchar(max) datatypes?

0 Answers  

---

What is a heap?

0 Answers  

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

What is optimization and its types?

0 Answers  

---

How many types of attribute relationships are there? : sql server analysis services, ssas

0 Answers  

---