Viewing 15 posts - 76 through 90 (of 171 total)
Grant Fritchey (2/21/2012)
... I'm pretty sure a healthy majority of people would be willing to sacrifice freedom for security...
It comes to my mind when we (at my town) started to...
February 27, 2012 at 11:37 am
Jeff Moden (2/15/2012)
jcb (2/15/2012)
ISNUMERIC is not perfect since chars like .+- can fool it.But if you use like it:
ISNUMERIC(value + 'e0')
ill improve correctness a lot.
In this case, the improvement...
February 16, 2012 at 3:09 am
ISNUMERIC is not perfect since chars like .+- can fool it.
But if you use like it:
ISNUMERIC(value + 'e0')
ill improve correctness a lot.
February 15, 2012 at 10:40 am
Are you trying to get the (workdays versus holydays+sundays) percentual between two dates?
February 15, 2012 at 10:36 am
You can also use ISNUMERIC and case to input only valid numeric or null when its invalid.
Depending of your tables and needs you can also log or create a log...
February 15, 2012 at 10:12 am
Like bteraberry said it's not a good chose to use dynamic SQL like that.
Instead you can use parametized dynamic SQL or static SQL.
A non parametized dynamic SQL ill be a...
February 15, 2012 at 9:50 am
Try change you query to not use dynamic SQL.
You can, for example, use
where (@param is null or table.column = @param)
to avoid dynamic setup of the where clause.
But first lear the...
February 15, 2012 at 6:57 am
Hey!
You are the guy from tthe job post!
http://www.sqlservercentral.com/Forums/FindPost1251850.aspx
What is it? An interview question?
Look, if you are in search for reviews for SQL tools you can google for it.
I dont know...
February 14, 2012 at 11:31 am
I have a situation where I can only run scripts in the server.
So, to import data from excel I just write insert statemens using the concatenation function from excel.
=CONCATENAR(",(";A2;",'";B2;"','";C2;"','";D2;"','";E2;"','";F2;"','";G2;"','";H2;"','";I2;"','";J2;"','";K2;"','";L2;"','";M2;"','";N2;"');'")
It ill...
February 14, 2012 at 6:30 am
Jeff Moden (2/13/2012)
...Heh... even without that bit of nightmarish code, I still find the same to be true... "sad bugs" and "bad coding".
Sure, someday I ill print "I see bad...
February 14, 2012 at 3:22 am
Thanks Paul,
I never though that I would live to see this day.
Sorry while tears drops at the keyboard but...
Too many sad bugs and bad coding I found writed with these...
February 13, 2012 at 12:03 pm
implicit outter joins are no more in SQL 2012?:w00t:
February 13, 2012 at 11:17 am
Your data security is good as is your staff.
Take your security measures, keep the data access to a minimum and don't forget to make a good investment in HR.
February 13, 2012 at 4:05 am
GSquared (2/10/2012)
...My point is simply that protecting the code when it's on their server is impossible. Can't be done
...
Sure, even a hardware token can be cracked.
The only way to "sell"...
February 13, 2012 at 3:23 am
When you create temp tables it lies in the tempdb.
When you drop temp tables or closes the connection they are erased from tempdb.
When you query needs to create "behind the...
February 10, 2012 at 4:39 am
Viewing 15 posts - 76 through 90 (of 171 total)