Database

string cmd = "SELECT UniversityDB.UniID, UniversityDB.UniCode, UniversityDB.UniName,<br />
UniversityDB.UniCity, UniversityDB.UniState, UniversityDB.UniAddress,<br />
UniversityDB.UniDetail, UniMajorDB.Major, UniMajorDB.Level, UniSourceDB.SourceName, UniSourceDB.Year, CDDB.CDNumber, CDDB.Year FROM UniversityDB LEFT JOIN UniMajorDB ON UniversityDB.UniCode=UniMajorDB.UniCode LEFT JOIN UniSourceDB ON UniversityDB.UniCode=UniSourceDB.UniCode LEFT JOIN CDDB ON UniversityDB.UniCode=CDDB.UniCode WHERE UniversityDB.UniCode = '" + UniCode_tb.Text + "'";

SELECT DB.UniID, 
       DB.UniCode, 
       DB.UniName, 
       DB.UniCity, 
       DB.UniState, 
       DB.UniAddress, 
       DB.UniDetail, 
       MDB.Major, 
       MDB.Level, 
       SDB.SourceName, 
       SDB.Year, 
       CDDB.CDNumber, 
       CDDB.Year 
  FROM UniversityDB DB  
  LEFT JOIN UniMajorDB MDB
    ON MDB.UniCode = DB.UniCode 
  LEFT JOIN UniSourceDB SDB
    ON SDB.UniCode = DB.UniCode
  LEFT JOIN CDDB
    ON CDDB.UniCode = DB.UniCode
 WHERE DB.UniCode = '" + UniCode_tb.Text + "'

si_69 wrote:

Select @rec = recVal from [dbo.northwind].Sometable

update [dbo.pubs].Sometable

<br />
Select @rec = recVal from northwind..Sometable<br />
<br />
update pubs..Sometable

Vikrant Badhai wrote:

Also I want to change the length of the data field of int datatype from 8 to 10, but I'm not able to change it.

SELECT d.[Date], SUM(a.Amount)
FROM MyTable AS d
INNER JOIN MyTable AS a ON a.[Date] <= d.[Date]

SELECT COUNT(*) AS Quantity,
       CarPart,
       CarPartPrice,
       SUM(CarPartPrice) AS CarPartTotalPrice
  FROM Orders O
  JOIN Customers C
    ON C.CustomerID = O.CustomerID
 WHERE C.CustomerID = 1
 GROUP BY CarPart,
       CarPartPrice
  WITH ROLLUP