How maney row would be print after join if A table have 100
rows and B table have 50 rows...
Answer Posted / brajesh kumar srivastava
its depend on join what type join you are using,If You are
using cross join then 100*50 record would printed.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the different types of backups available in sql server? : Sql server database administration
What is msdb database? : SQL Server Architecture
What is a view and what are its advantages?
Can multiple columns be used in sql group by clause in ms sql server?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What is the use of @@spid?
What are acid properties of transaction?
How many types of built in functions are there in sql server 2012?
how to create “alternate row colour”?
What is the datatype of rowid?
What is difference between inner join and full join?
How to transfer data from a cursor to variables with a "fetch" statement?
what is a deadlock? : Sql server database administration
What is ddl and dml commands?
What is SQL Azure Firewall?