So...the...

Which colour makes more sense to you? Pink?

SQL Server does not have Sequences in quite the same way as Oracle.

There is a workaround, not sure if it will help you though:

http://sqlblog.com/blogs/paul_white/archive/2010/10/19/sequence-tables.aspx

WayneS (10/16/2010)

---

I just love these!

"I've got this task, needs to be done in an insert trigger".

So, I give the code for doing so.

"Now, can you incorporated it into my...

i c

If something like IN (@variable) is needed, Erland Sommarskog covers the options extremely well:

http://www.sommarskog.se/arrays-in-sql-2005.html

DROP TABLE

dbo.TempCustomer,

dbo.Contact,

dbo.ContactAudit;

GO

CREATE...

The original question doesn't give expected output or the number of rows to be processed, so this is a valid alternative:

SELECT *

FROM #membership M

WHERE ...

To put the timings in context, the T-SQL solutions ran for about 30-45 seconds on...

The SQLCLR test results are in:

Craig's test data (267,150 rows): 360ms

Jeff's test data (889,892 rows): 1386ms

Test rig and csv data for both runs attached, along with C# source code.

This SQLCLR...

Craig Farrell (10/14/2010)

---

I've never actually needed to do that in a trigger, so I've never ran into that. That's... odd. Do you know if it still occurs if...

Craig Farrell (10/14/2010)

---

Part of the issue, I guess, is that I don't see the QU as being Jeff's method, as I was using it long before I ever saw his...

No need to apologise. My reply was shorter...

Nope.

CREATE SCHEMA InjectionAttack

CREATE TABLE Test ([1;DROP TABLE TEST;--] SQL_VARIANT NULL);

GO

EXECUTE dbo.Dynamic_Query_Example '1;DROP TABLE TEST;--';

...still drops the Test...

Why not? Try:

exec dynamic_query_example '1;DROP TABLE TEST;--'

with your example code? It drops the test table!