Well, the code you've posted is correct in terms of syntax, but it's fairly difficult for anyone to work out what's wrong without the full code (and DDL to create...

Well, I've never tried, but I assume that CLR UDF's have similar restrictions to T-SQL ones in that they're specifically not for this kind of purpose (e.g. data modification), so...

There are a number of possible solutions to this. Are you planning to do this as a batch process or as close to real-time as possible?

If it can be...

SQLkiwi (3/4/2011)

---

I see, so you were saying that running the SELECT first (and noting the row it selected) and then expecting the DELETE (with the same SELECT statement as a...

SQLkiwi (3/4/2011)

---

Hi Howard,

I agree with your...

It's important to note that none of these solutions will guarantee to delete the same rows as are being returned by the select statement (nor indeed is the select statement...

This seems fitting given the circumstances:

http://xkcd.com/292/

:hehe:

I suspect the OP is aware of the nature of the data and isn't trying to translate from Korean into English 🙂

I'd suggest reading up about collation.

To put it simply,...

Don't be hard on yourself, I'm sure you're not that ugly 😛

Script component is definitely...

I'd recommend having a look here, which answers all of those questions:

http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

No, pretty much everything that happens within the scope of an individual database is part of the transaction and can be rolled back, including DDL and indeed TRUNCATE (another transaction...

GSquared (2/28/2011)

---

HowardW (2/28/2011)

---

And it uses a very easily reversible algorithm - I think Red...

And it uses a very easily reversible algorithm - I think Red Gate SQL...

So, to clarify, which version of SQL Server are you using?

Interesting...

That is written for 2000 (this is the 2008 forum) - what it's saying is that because the inserted and deleted tables need to include all columns, not just the...