I have to display ten columns values from diffrent ten
tables.
how many joins are require?
Answer Posted / ask
Select column1, column2, ...., column10 from table1,
table2, ..., table10
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Explain difference between control flow and data flow?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
What is indexed view?
What are the system database in sql server 2008?
Is it ok to shrink transaction log?
Which is better statement or preparedstatement?
What is snapshot report?
What are sql azure firewall rules?
Explain comment on transactions?
How will you find out if there are expensive SQL statements running or not?
What are sql server functions?
What is the difference between indexing and hashing?
Explain how you can deploy an SSRS report?
Explain partitioned view?
What is similarity and difference between truncate and delete in sql?