select * from OpenDataSource
	( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\test.xls";Extended properties=Excel 8.0')...['2007data$']

select * from OpenDataSource
	( 'Microsoft.Jet.OLEDB.4.0',

select * from OpenDataSource 
	( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\test.xls";Extended properties=Excel 8.0')...[Sheet1$]

Update TableName set Result =
case when (case when col_1 > col_2 then col_1 else col_2 end) > col_3 then 
(case when col_1 > col_2 then col_1 else col_2 end) else col_3 end

create procedure procSearch
@TrainingCertification varchar(50) = null
as
begin
select *
from TrainingCertifications
where (';' + replace(@TrainingCertification, '; ', ';') + ';') 
like ('%;' + TrainingCertificationsType + ';%')
end

where (','+isnull(@var,EnterpriseId)+',') like ('%,'+EnterpriseId+ ',%')

where (','+isnull(@var,convert(varchar(20),EnterpriseId))+',') like ('%,'+convert(varchar(20),EnterpriseId)+ ',%')

select @concat = isnull(@concat,'') + @CrdPinNo