Some SQL Tips

Some SQL Tips (Some DateTime Conversons)

Mar 7 2007 3:17PM convert(varchar, getdate() ,100)
03/07/2007 convert(varchar, getdate() ,101)
2007.03.07 convert(varchar, getdate() ,102)
07/03/2007 convert(varchar, getdate() ,103)
07.03.2007 convert(varchar, getdate() ,104)
07-03-2007 convert(varchar, getdate() ,105)
07 Mar 2007 convert(varchar, getdate() ,106)
Mar 07, 2007 convert(varchar, getdate() ,107)
15:17:03 convert(varchar, getdate() ,108)
Mar 7 2007 3:17:03:847PM convert(varchar, getdate() ,109)
03-07-2007 convert(varchar, getdate() ,110)

Getting no of rows affected

u can get no of rows affected by @@rowcount
simply print ,@@rowcount after any type of sql statement and u can get no of rows affected.
Copying a datatable to another table

SELECT * INTO old_emp 
FROM Employee
print(convert(varchar,@@rowcount) +' rows were copied')

Comparing Time in SQL

Since there is no time datatype in sql so we have to be tricky by appending a 
constant date with time and than compare them. likeDeclare @Date Datetime
Declare @Date1 Datetime
Declare @Date2 Datetime
Declare @Time varchar(20)
set @Date='1/1/2008'
set @Time=(select convert(varchar,getdate(),108)+' '+ (select right(getdate(),2)))
set @Date1=convert(DateTime,@Date+' '+@Time) -- first time
set @Date2=convert(DateTime,@Date+' '+'4:00:00 PM') --second time
if(@Date1>@Date2)
print 'First time is greater'
else
print 'Second time is greater'