Viewing 15 posts - 2,461 through 2,475 (of 8,416 total)
Kit G (10/18/2010)
Heh. I dislike the whole "Green" thing. And that stems from my total disgust at the whole Global Warming/Climate Change "science" that isn't science, just propaganda.
So...the...
October 18, 2010 at 11:01 am
CirquedeSQLeil (10/18/2010)
Why is Green the color to represent tree huggers and eco-friendly?
Which colour makes more sense to you? Pink?
October 18, 2010 at 10:58 am
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
October 18, 2010 at 10:26 am
WayneS (10/16/2010)
"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...
October 18, 2010 at 5:05 am
Gianluca Sartori (10/18/2010)
As Dave pointed out, the IN predicate doesn't work that way.
If something like IN (@variable) is needed, Erland Sommarskog covers the options extremely well:
October 18, 2010 at 4:56 am
DROP TABLE
dbo.TempCustomer,
dbo.Contact,
dbo.ContactAudit;
GO
CREATE...
October 18, 2010 at 4:45 am
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 ...
October 18, 2010 at 2:03 am
WayneS (10/17/2010)
Paul, you must be slipping... those times seem a bit slow for your clr code...
To put the timings in context, the T-SQL solutions ran for about 30-45 seconds on...
October 17, 2010 at 11:19 am
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...
October 17, 2010 at 9:43 am
Craig Farrell (10/14/2010)
October 14, 2010 at 5:40 pm
Craig Farrell (10/14/2010)
October 14, 2010 at 3:19 pm
Craig Farrell (10/14/2010)
Sorry Paul, that was a bit abrupt and you deserve better than that, your explainations are always concise and instructive.
No need to apologise. My reply was shorter...
October 14, 2010 at 1:24 pm
sivaj2k (10/14/2010)
May be this one is better solution.
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...
October 14, 2010 at 9:18 am
sivaj2k (10/14/2010)
In this case sql injection is not going to occur.
Why not? Try:
exec dynamic_query_example '1;DROP TABLE TEST;--'
with your example code? It drops the test table!
October 14, 2010 at 5:09 am
Viewing 15 posts - 2,461 through 2,475 (of 8,416 total)