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 |
Explain some DBCC commands?
How to connect PK and FK?
What is transaction server isolation?
What does the not null constraint do?
Can you tell me some of the common replication dmv's and their use? : sql server replication
What is normalization? Explain its different types?
What is dynamic cursor in SQL SERVER?
How to create new tables with "select ... Into" statements in ms sql server?
I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
How do you know if sql server is running on your local system?
Explain atomicity?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)