Database

SELECT column FROM table<br />
LIMIT 10

SELECT column FROM table<br />
WHERE ROWNUM <= 10

SET rowcount 10<br />
SELECT column FROM table

SELECT FIRST 10 column <br />
FROM table

SELECT EM.empId, EM.empName, TC.carddate, TC.reportingtime,
  TC.leavingtime, SD.Whrs, TC.shift, TC.projectid,
  (SELECT SUM(MedicalLeave) FROM dbo.tblMonthHourDetails MHD
    WHERE MHD.EmpId = EM.empId AND YEAR(MHD.SDate) = 2007) AS ML,
  (SELECT SUM(AnnualLeave) FROM dbo.tblMonthHourDetails MHD
    WHERE MHD.EmpId = EM.empId AND YEAR(MHD.SDate) = 2007) AS AL
FROM dbo.tblEmployeeMaster EM
INNER JOIN dbo.tblTimeCardmain TC
ON EM.empId = TC.empid
INNER JOIN dbo.tblSalaryDetails SD
ON EM.empId = SD.EmpID 
WHERE TC.carddate = '5/2/2007' 
AND TC.app1 = 1
AND TC.projectid = 100

Magh_M wrote:

Query doubt.

andreumv wrote:

How can I use the table in the external database?

alter table MyTable alter column
  ID integer identity(1,1) not null

Insert into MyTable (FirstName, LastName, Email)
  values ('Andy', 'Harman', 'Andy@AndysWorld.com')
Select @@Identity