Answer Posted / gowrishankar.s

join is used to join the two or more based on join tables.
in A table having 100 rows and b table having 50 rows in
this situation innerjoin join the related columns only.
select A.sutdid,B.empid, from A innnerJoin B
on A.studid=B.empid;
innerjoin is used retrieve all rows from both tables as
long as there is a matching between two columns.

Explain about merge replications?

1009

---

What is the difference between createstatement and preparedstatement?

929

---

what is a deadlock? : Sql server database administration

1047

---

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

118

---

What is clustered index

995

---

Is sql server a database?

981

---

explain different types of joins? : Sql server database administration

974

---

How real and float literal values are rounded?

1149

---

What does the on update no action do?

1020

---

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1096

---

In which sql server version report builder introduced?

148

---

What are the fixed server level roles? : sql server security

1119

---

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1000

---

What is data file in computer?

939

---

What is the downside of using udf?

1098

---