ShamsiTech

This article explains how to join tables in SQL Server. Joining in SQL There are various type of SQL joinning. A few of them that are commonly used are described below. 1: Inner join 2: Right Outer Join 3: Left Outer join First Step First create a SQL table named bio. The following is the second table named fee.   Now  insert  values into the bio table. Now  insert  values into the fee table.   Second Step   using  System; using  System.Collections.Generic; using  System.Linq; using  System.Web; using  System.Web.UI; using  System.Web.UI.WebControls; using  System.Data.SqlClient; using  System.Data; public   partial   class   SQLJoins  : System.Web.UI. Page {      protected   void  Page_Load( object  sender,  EventArgs  e)     {     }      Sql...

INSERT INTO tbl1 SELECT s . id , s . Name , s . Fname FROM tbl2 s        LEFT JOIN tbl1 d ON ( d . id = s . id ) WHERE d . id IS NULL

Select a . Name as TblName , Sum ( b . Rows ) as RowsCount from Sys . Tables as a , Sys . Partitions as b where a . Object_Id = b . Object_Id Group By a . Name Order By Sum ( Rows ) Desc

Generate Sql Script with Data In this Article we learn how to generate sql Database script with Data.  Step1: Open Sql Server and right click on the Specific database(for which you want to creat script)  ­Database -------> Right click --------> Task‑‑‑‑‑‑‑>Generate Scripts                                      Step2: Now Click on Next Button                                          Step3: Click on Next button                          Step4: Now Click on Advanced .                                                  ...