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 |
How to write stored procedure to update the data in 10 tables
What does asynchronous call backs means?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
What do you understand by intent locks?
Which joins are sql server default?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
Explain primary key in sql server?
4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10
What is model database? : SQL Server Architecture
What are differences in between sql server 2012 and sql server 2016?
How to recover from sql injection? : sql server security
What are locks in sql?