Database

if(select count(*) from students where studentnamecolumn = 'studentname') = 0<br />
begin<br />
insert into students  values (value1,value1......)<br />
end

insert into mytable (value1, value2, value3)
select @value1, @value2, @value3
where @myitem not in (select myitem from table2)

<br />
select * from tablename <br />
where ([Staff Number] like '%value%')<br />
or ([Staff Number] in ('value'))

select [name],<br />
(select top 1 t1.[date] from MyTable as t1 where t1.[name] = MyTable.[name] order by t1.[id] desc)<br />
 from MyTable <br />
group by [name]

select name, max(date)
from table
group by name

IF Not exists (select 1 from tablex where columny = 'z')
begin
  insert ....
end
else
begin
   update ...
end

justintimberlake wrote:

whats wrong with this one

justintimberlake wrote:

why is it opening a new sqlqury ide

Jesu Prabhu.J wrote:

Plzzzzzzzzzz help urgent!!!!!!

Jesu Prabhu.J wrote:

I need ur help to write a trigger.

Jesu Prabhu.J wrote:

I am using SQL Server 2000, If i change any value Ex: Employee Name in the (Employee Master) the value Employee Name must get updated in the other 2 tables..