Consider the table T1 it consits
A,2,3,4
consider another table t2 it contain
1,2a,3a,4a
now i need o get the upadted answer
Answers were Sorted based on User's Feedback
Answer / rakesh c sunagar
--select name from #t where ISNUMERIC(name)<>1
--union
--select name from #t1
Is This Answer Correct ? | 0 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 1 No |
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
Is This Answer Correct ? | 1 Yes | 4 No |
What is the difference between seek predicate and predicate?
Define right outer join?
Does the unique constraint create an index?
What is the command to change the recovery model?
Can we do dml on views?
Do you know the isolation level that sql server support?
how many instance use in sql server 2005
How to truncate a table first before running a package?
What is deadlock and how to avoid the deadlocks.
Explain the concept of recursive stored procedure.
In which year relase the 7.0& 2000 & 2005?
How to use values from other tables in update statements in ms sql server?