If a "database" is a means of storing data in a retrievable, orderly manner, then Excel can be a database. So can text files. Deep under the hood,...

Rows in a table don't really have an "order" to them. They may be stored in a particular sequence (if they have a clustered index), but that's just a...

GilaMonster (2/2/2011)

---

Jason, Gus, Brandie, Wayne and Stefan. How do you want to be credited in tran log article? Blog link? twitter handle? Both? Neither? something else?

Please let me know by...

Honestly, I'd hit the SSIS tutorials online to get oriented to building SSIS packages, if I were you. I could outline the process, but it won't be as easy...

Bulk imports usually bypass triggers. You can turn that off, but instead I'd recommend having SSIS do the inserts into the other table directly.

Coalesce or IsNull can still work, since the variable/parameter will have no value assigned.

The problem with this method, or similar ones, is that it tends to kill performance because of...

That one's a good start.

The...

It depends on how well you know the data. If it can only fit certain patterns, you can code against those. You have to assume then that the...

Yes, there are several other methods. These...

Ninja's_RGR'us (2/1/2011)

---

Or plan B not using the temp table and saving some overhead.

DECLARE @tst VARCHAR(100)

SET @tst = 'fail'

SELECT 1 WHERE NOT @tst LIKE '%[^0-9]%'

SET @tst = '0123456789'

SELECT 1 WHERE NOT...

It won't choose a different plan, but the plan...

This article has data on when a SQL Server view is updatable (scroll down a bit to find the section on it): http://msdn.microsoft.com/en-us/library/ms187956.aspx

Edit: Given the right code, any view can...

Brandie Tarvin (2/2/2011)

---

It really does depend, mainly on...

Jeff Moden (2/1/2011)

---

GSquared (2/1/2011)

---

The first step is to build a Select statement that will get all the ones you want to exclude directly or indirectly.

select *

from MyTable

where ip = '1.1.1.1'

or...

Any other thoughts on what? You seemed to be asking about the order of the data returned from a Select statement. Do you have a different/other question?