Primary key on what columns? if it is based on Identity column then i dont see any use.

If it is on business Columns YES it will be benificial.

Thanks -- Vj

Hi

You can use the sample query

In your case you dont have any critirie to group by so in the below query i removed the group by.

SELECT SUM(EXP_5) from

Thanks...

I tried the queries and it looks to me Query 2 is better compared to Query 1.

But again There is very slight differernce between Query 1 and 2. this is...

Hi

I will go with first "INSERT THE DATA" and then based on the results I will issue "UPDATE". because Insert is always faster compared to UPDATE.

Thanks -- Vj

Hi

There are somany tools which provides this, but all these are based on comparing the DevDB with PrePordDB and list out the difference between these and prepare alter script for...

Hi

Its purely depends on what kind of role they are playing.

Assignemnts can be Upgrading from SQL Server 2005 to SQL Server 2008

or

Upgrading from SQL Server 6.0 to SQL...

Hi

Check out the below link

http://www.odetocode.com/Articles/70.aspx

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi

Why dont you use DTS or SSIS?? What my experience says Oracle Migration workbech gives several kinds of problems.

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi

There are several ways to do this and it is very basic thing in writing queries.

Check out the below link, i am sure you will be able to do it...

Hi

Merge Join :

SQL Server performs a join between two sets of row data using the merge

join algorithm. The inputs are two separate sets of row data. Output is

the results...

Hi

You can't use IN clause with any variables.. to do this you need to construct dynamic SQL..

Thanks -- Vj

http://dotnetvj.blogspot.com

http://oravj.blogspot.com

Hi

Are you expecting all the possible answers to your post, so that you can frame your question based on this :w00t:

Thanks -- Vj

http://dotnetvj.blogspot.com

http://oravj.blogspot.com

Hi

There is Question and but so many answers 😀

Thanks -- Vj

http://dotnetvj.blogspot.com

http://oravj.blogspot.com

Hi

You dont have to use ERWin Model to get the relationshhip diagram. Simple you can Database Diagramming in SQL Server. This is very good..

Check out thebelow link for more infromation.

Hi

The best option is to use XML data type to store this kind of information. So this way you can even validate the XML by having XSD. From performance point...