Database

.CS wrote:

select *

John Mecas wrote:

select * statement should return only those columns which don`t contain a NULL value

<br />
select name,isnull(occupation,'yadayadayada'),age<br />
from persons<br />
where occupation <> 'yadayadayada'

<br />
select name,occupation,age<br />
from persons<br />
where occupation is not null

LyndonJohn wrote:

the user can search for the different products

select month(Post_Date) as Post_Month,
    year(Post_Date) as Post_Year,
    sum(case when Status = 'Active' then 1 else 0 end) as Active,
    sum(case when Status = 'Inactive' then 1 else 0 end) as Billed
from tbl_Post_Job
where Company_Id_Fk = 60
group by year(Post_Date), month(Post_Date)
order by year(Post_Date), month(Post_Date)

veereshIndia wrote:

i want to insert data into first table i need sql query for this

INSERT INTO tblEmployee(
     EmpolyeeID,
     EmployeeName)
VALUES(
     @EmpolyeeID,
     @EmployeeName)

Regards
J O H N

"Even eagles need a push." David McNally

---

INSERT INTO tblEmp1(
                         EmpID,
                         EmpName
                      )
          VALUES(
                         @EmpID,
                         @EmpName
                       )

<code>INSERT INTO tblEmp2(
                        RowID,
                        EmpAddress,
                     )
         VALUES(
                        @RowID,
                        @EmpAddress
                       )</code>

Regards
J O H N

"Even eagles need a push." David McNally

---