Database

Select replace(fullname,' ','')

select convert(varchar(15), cast(getdate()+ ' 17:00' as datetime) - cast(getdate()+' 08:00' as datetime),108)<br />
select convert(varchar(15),cast(getdate()+' 17:01' as datetime) - cast(getdate()+1+'08:29' as datetime),108)

select *,<br />
datediff(hh,cast(start_datetime as datetime),cast(end_datetime as datetime)) as [Time_spent__hrs_]<br />
 from MyTable

<br />
select count(*) from student where studentNumber = [myStud]<br />
<br />
if count = 0 then <br />
  insert StudentNumber,ModuleCode into STUDENTModule values (myStud,myMoodule)<br />

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