The reason why telecommuting (inspite of all its' very serious advantages) is still not the norm nationally - leave alone globally is because employers have a very great fear of...

If you do your scripting via the EM scripting wizard you can specify "script triggers" under the options tab - in fact, the table scripting options will script indexes, primary...

Not quite sure what you mean but I would capture these values in local variables and "PRINT" the local variables....

hth!

What is the "rule" behind your personal order - you should use this in your "order by"  etc..

The easiest thing to do would be to create a new database using enterprise manager - and then use the restore database wizard to restore your .bak file to the...

Are you passing a parameter to a stored procedure ?! The only thing I see in the result that you want is that you seem to want an "order by" on...

I'm not sure I understand what relationship you want to reflect, but if you make the fruit column a clustered index (see above), you will have apple stored before bananas.....

same question answered here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=191784

This happens only when the number of columns in the destination table does not match the number of columns in the source table - one way to eliminate this is...

You can generate an autonumbering ID field by:

Create Table Fruits

(

fruitID int IDENTITY(1,1),

fruitname varchar (50)

)

However, the only way you're going to see the 'fruitname' column inserted in an alphabetical...

Remi - what a master of T-Sql you are...

I'm sure you were in a hurry so you omitted a couple of things...(that B.col_3 needed to be 1 and there was...

Before you guys go and knock yourselves out (:sick...please answer this for me...

Remi (not a stupid question - only a very confused one)..

what is...

sswords - we'll have to agree to disagree on this one (makes a change what ?!?!)...

For my part, one of the things that I DO like is that the forums...

jamais!!!!

<;-)

I COMPLETELY misunderstood the original post....sorry - I take back all my stupid questions!