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
Answer Posted / 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 |
Post New Answer View All Answers
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
Explain error and transaction handling in sql server?
What is cursor in ms sql server?
Do you know concepts and capabilities of sql server?
Explain indexed views?
What is change data capture (cdc) feature?
Explain system views?
What is inner join in sql server joins?
What are the different types of collation sensitivity?
what is datawarehouse?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What are subqueries in sql server? Explain its properties.
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is a document index?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration