Are you talking about:

select *

from dbo.Table

where KEY = '8:72057605279514624(6d020e2b1505)'

Or do you mean something else?

I think I've seen that kind of thing happen before when there was a problem with the network between the two servers. Not sure that applies to your situation,...

On the subject of a Common or Tools database (good name for it, "Tools", but I'll stick with "Common" from habit), the main thing to remember is that cross-database queries,...

I do have a question for anyone that cares to answer... What do folks use things like a 100 million row Tally table for? I can see some uses...

I'm not sure what you're asking for. I gave several examples of possible matches, and one select statement using Like.

Good question. Actually made me turn my brain on and think, and no "how many months have 28 days in them" type tricks.

Just hope that data doesn't end up in the hands of a competitor.

I don't know if that kind of thing matters much. Check out what the query does (as...

Scope_identity() is definitely a more efficient way to do this.

Have you tried running it using xp_cmdshell, instead of trying to create a shell object?

From what I've read, most SQL injection attacks these days are attempts to get sensitive information. If, for example, you have credit card data in your database, and it's...

The other thing to do is cast the binary data as nvarchar and then you'll be able to see what he did, at least at first. Just don't execute...

Another excellent article on tally/numbers tables is at:

http://www.simple-talk.com/sql/t-sql-programming/the-helper-table-workbench/

by the lovely Robyn Page and the hillarious Phil Factor (I hope I didn't get that backwards 🙂 ).

The only thing I can...

David (5/5/2008)

---

Thanks for the replies, I suppose that what I am unsure about is whether querying the table directly performs some sort of lock on the table that maybe a...

Very interesting numbers. Since I have to ship backup files across a low-speed network, this could come in very useful.

bvesperman (5/5/2008)

---

I agree that this doesn't work. I was pretty sure it wasn't going to do an implicit conversion. Then I cut and pasted it into a query and executed...