There are two tables (T1, T2) with different rows. Find the
output of query. Select count(*) from T1,T2.
Answers were Sorted based on User's Feedback
Answer / atul sharma
the result will be--
Number of rows in table T1 multiply(*) the Number of rows
in table T1
Is This Answer Correct ? | 31 Yes | 2 No |
Answer / jitendra sharma caresoft inc.
No of rows in table T1 * No of rows in table T2
Is This Answer Correct ? | 9 Yes | 0 No |
What do you understand by a view?
What are the difference between primary key and unique key? : sql server database administration
What do you understand by SQL*Net?
Do you know what is replace and stuff function in sql server?
in how many ways we can use count()
How do I find sql server instance name?
How do I compare two values when one value(data type) is char and the other is an integer?
Can you tell me the difference between DELETE & TRUNCATE commands?
How to list all dsn entries on your local machine using odbc_data_source()?
Explain how many types of relationship?
What is a user-defined function in the sql server and what is its advantage?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.