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 |
Mention the uses of stored procedures.
What is database dimension? : sql server analysis services, ssas
What is dirty page?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
How to execute stored procedure in select statement sql server?
Explain the collation?
what is a schema in sql server 2005? : Sql server database administration
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
role of sql sever 2005 in database rather than any other database
How to stop a loop early with break statements in ms sql server?
What are the new scripting capabilities of ssms? : sql server management studio
What is the difference between a clustered index and a non-clustered index?