is there anywhere else i can practice test questions which is not breaking violations..

You can use the import Wizard in SSMS, by rt clicking on the database - Tasks - Import data.

/* CREATE A NEW ROLE */

CREATE ROLE Rolename

/* GRANT EXECUTE TO THE ROLE */

GRANT EXECUTE TO Rolename

Is there a reason why you don't want to use SSIS or DTS?

Try this:

select * from tablename where fieldname like '%32062%'

I guess i just have to read up on 'Stuff' and XML path.

Is there a way to use the seq number in such a way that i do not need to specify each row. It would be tidious if there are 100...

Thanks dave, but i was wondering if it can be achieved using CTE as used in my query.

How can i tackle that Gail.

This is what i did following the link from Dave. Worth checking out the link. Thanks Dave.

; WITH CTE ( EM_EmpId, EM_DeptName, seq )

AS (...

Something in the lines of this should work...

select sum(field1),datepart(mm,billingdate) as month

from tablename

where billingdate between '2009-06-01 09:00:00' and '2009-12-01 08:59:00'

group by datepart(mm,billingdate)

Thanks Jack. That's a very useful link. I have added that to my favourites. 🙂

Try this

select * from customer where upper(surname) surname

Try this:

SELECT J.name AS JobName

, L.name AS JobOwner

FROM msdb.dbo.sysjobs_view J

INNER JOIN

master.dbo.syslogins L

ON J.owner_sid = L.sid

Please try this as far as update statement is concerned.

UPDATE Audit

SET a.BatchID = b.Id

FROM Audit a inner join Batch b on a.BatchCode = b.Name

AND a.BestBeforeDate = b.BestBefore

AND a.ProductionDate = b.ProductionDate

As...