If you open up the Business Intelligence Design Studio (BIDS), you'll see Integration Services as an option. Start a new one, and take a look at the options. ...

I'm willing to help with any of those three (that Tim outlined above). Just so long as it doesn't turn into a full-time job on its own (since I...

So long as your updates only hit one of them at a time, you'll be okay.

I don't think inserts will work. SQL can't know if there's theres a sequence...

All the jobs data is stored in msdb. You should be able to get what you need from there.

You don't need to put "with(rowlock)" on deletes. So far...

If you set nocount on, and all both scripts do is the select into, there's nothing to show on the screen except that it completed.

Do a conversion step that puts it in the format you want. Books Online has the available target formats, under Cast and Convert.

I just tested this:

select top 1 *

from dbo.Numbers

where number = 10;

select *

from dbo.Numbers

where number = 10;

There is a Top step in the first one with a cost of 0.0000001, which...

Just think... there must have been a time when Yoda was a padawan (or however you spell that). How annoying it must have been to be the master he...

Inside triggers, there's a "table" called "inserted" that has the rows that have been updated. There's also one called "deleted" that has what they had before they were updated....

It sure can. Doesn't mean it will be random, just means you can't count on which record it will be.

Edit: Well, unless there's only one row in the table,...

Jeff Moden (3/10/2009)

---

You bet, Todd... Thanks for the feedback. Heh... It's amazing how long the myth of Select/Into has managed to survive.

I'll have to look for it, but I've...

I can't see any way that Simple could cause that.

Books Online has the full data on how it works internally. It's worth reading and understanding if you're going to...

Do you have a Numbers/Tally table? If so, then it can be normalized pretty easily.

select substring(MyCol, Number, 1)

from dbo.MyTable

inner join dbo.Numbers

on Number <= len(MyCol);

Something like that will...

You are correct. That should do what you need.

No. Doesn't really have anything to do with that.

Simple recovery is basically for databases where you don't care if you lose some of the data, or where there just...