you can also use the transcender application for 70-229.it will help you with the particular sections that you want to understand

i don't follow what you are trying to ask but try this site

http://www.datamodel.org

yes refer to bol you can use the DATEADD ( datepart , number, date ) function.

hope you know how to run a stored proc from vb 6

Yes you can have an SQL DBA on other platforms other than MS SQL Server, such as those listed by Gabor.

sorry i had left out the sample xml file for the earlier post

<NewDataSet><Table>

<OrderNo>1</OrderNo>

<Product>1</Product>

<Quantity>23</Quantity>

<Price>23.36</Price>

</NewDataSet></Table>

I am failing to understand what sort of help you require.What exactly do you want to do?

I am uploading an xml file and this is how i am doing it

ALTER...

refer to this site for all you need

http://www.perfectxml.com/Articles/xml/importxmlsql.asp

Hie Troyk

I believe in all that you have said.i am also actually waiting to get enough experince before embarking on any of the exams, notably 70-300.as i am developing right...

You can use transcender material, by the way which sql are you intending to write coz there is 70-228 for sql admin, and 70-229 for sql development.you can also get...

thanks bbdpress i didn't know about that one.

What about when you are using complete compare, how do you set it up?

the only solution that is there for you if the tables have already been created and you are using complete compare is to actually go into the script when you...

you have to use enterprise architect

1. For identity fileds it generates IDentity(1) not Identity(1,1)

---

on erwin on the identity field put the input as 1,1 instead of 1.this should solve your problem

****************

2. For the fileds it...

Could not agree more with Michael, i also think you need to stick to option A.stored procs is the best way of ensuring users don't mess up you database.

You could...

since you have created a table dbo.UserRoles there is no need to to have a roleid column in the user table.

you need to create a table dbo.UserOffice that will link...