Interested to Buy Any Domain ? << Click Here >> for more details...
In join, which clause in not used?
- 4 Answers
- 12641 Views
- HCL, NIIT, TCS, I also Faced
- E-Mail Answers
Answer Posted / b.kumar
--Ms sql server
We can't use where clause in joins(inner/left/right/full).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are views used for?
What are alternate keys?
How to create an index on an existing table in ms sql server?
What is the partitioning method?
How to create an index on a view?
How to update multiple rows with one update statement in ms sql server?
What is spid in sql server profiler?
Explain foreign key in sql server?
Differentiate between delete and truncate.
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
How do you create type- insensitive operator?
what is datawarehouse?
What is the difference between push and pull subscription? : sql server replication
What new changes are being made in SQL Server?
What is faster join or union?
