Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 4799 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to loop through the result set with @@fetch_status?
Explain about Views?
What is an inner join?
what is the primary use of the model database? : Sql server administration
How to create a simple table to test triggers in ms sql server?
Explain the use of keyword with encryption. Create a store procedure with encryption?
Give an example of why you would want to denormalize a database
Can we create clustered index on composite key?
What do you mean by 'normalization'?
What are the disadvantages of using querystrings to send data from one page to another?
Define left outer join in sql server joins?
Explain the disadvantages/limitation of the cursor?
How do you make a trace?
What is the full meaning of dml?
what are candidate key, alternate key and composite key? : Sql server database administration
