Viewing 12 posts - 136 through 147 (of 147 total)
[font="Verdana"]
Michael Valentine Jones (4/20/2010)
');declare @ nvarchar(max);set @='';select @=@+'drop table '+quotename(object_schema_name(id))+'.'+quotename(name)+';' from sysobjects where xtype ='u';exec (@); --
too bad; if any body tried your "Injection", then .... !!! :-D[/font]
April 20, 2010 at 11:37 pm
[font="Verdana"]
and ensure every developer understands what SQL Injection is.
:discuss:
it means every developer (negative) would turn into a Doctor with an Injection named as "Sql Injection" .... [/font]:cool:
April 20, 2010 at 1:51 am
CirquedeSQLeil (4/19/2010)
April 20, 2010 at 1:45 am
[font="Verdana"]
SELECT 'ALTER TABLE ['+ SC.NAME+'].[' + PB.NAME + '] ENABLE TRIGGER ALL'
FROM SYS.TRIGGERS T
JOIN SYS.ALL_OBJECTS OB ON OB.OBJECT_ID = T.OBJECT_ID
JOIN SYS.ALL_OBJECTS PB ON PB.OBJECT_ID = OB.PARENT_OBJECT_ID
JOIN SYS.SCHEMAS SC ON...
April 19, 2010 at 1:06 am
jeff.mach (4/16/2010)
cengland0 (4/16/2010)
jeff.mach (4/16/2010)
I think cengland0 and I may work for the same employer
I just looked you up in our corporate directory and if you live in Addison Tx, then...
April 16, 2010 at 7:13 am
[font="Verdana"]Non-monetary company rewards no-doubt, are special cards of good management to win over employees. But it stands for good management only. 😛
If I be on an executive seat then certainly...
April 16, 2010 at 12:12 am
I've known people with the "standard" of a certification (MS and otherwise) under their belt and they still know virtually nothing. Conversely, I've also had people with no certs...
April 14, 2010 at 11:27 pm
[font="Verdana"]Can anyone of ranks higher than "Old Hand"(SSC ranking) let forward some exceptional tips for "SSC Rookie" or less to attain/pave their career with a Plus? :smooooth:
------------------- :exclamationmark:[/font]
or they should...
April 13, 2010 at 11:29 pm
Aam-624390 (3/3/2010)
Seems to be a lot missing assumptions. Each given answer can be correct given different starting conditions.
[font="Verdana"]Sure; and That's why i lost one point.... for the...
April 13, 2010 at 8:49 am
Tom.Thomson (4/8/2010)
In SQL Server 2005 the IsNull() function will truncate the length of replacement_value to that of check_expression.
This explanation is wrong. The IsNull function converts to the type...
April 8, 2010 at 11:13 pm
Dear ken,
Can you explain this behavior specifically w.r.t Operator Precedence? and is this behavior is default for all versions of SQL?
Thank you!
April 6, 2010 at 12:19 am
Viewing 12 posts - 136 through 147 (of 147 total)