27,850 reputation
766117
bio website
location United Kingdom
age
visits member for 2 years, 11 months
seen 18 mins ago

Email: stackoverflowmartinsmith@gmail.com


10h
comment How to resolve stored procedure output parameter error?
You need to show how you are executing this procedure.
10h
revised How to resolve stored procedure output parameter error?
added 96 characters in body
22h
comment Tsql Query speed slow due to Or within where clause, causing index scan instead of seek
What version of SQL Server?
1d
comment Why does a simple select query produce a deadlock?
@Shanky - I prefer the code here for the reasons here
Sep
17
comment What is the logic behind ISNUMERIC for certain special characters?
@AaronBertrand There seems to be a reasonably significant number of cases where it does not even meet that intention too.
Sep
17
comment What is the logic behind ISNUMERIC for certain special characters?
Though from NCHAR(0) - NCHAR(65535) I see 112 discrepancies. Including characters such as ₁,₂,₃,4,5,6,7,8,9 which look numeric but don't cast successfully to anything for me. Fiddle
Sep
17
comment What is the logic behind ISNUMERIC for certain special characters?
@Jeroen - It's on Wikipedia FWIW
Sep
17
comment What is the logic behind ISNUMERIC for certain special characters?
Ah that's an interesting theory. It is money that it casts to as well.
Sep
17
comment What is the logic behind ISNUMERIC for certain special characters?
The only ones that seem incorrect to me are that it falsely reports 0 for five of the values that actually cast fine to money. The others seem accurate. SQL FIDDLE
Sep
16
comment Converting a Unicode value to a non-Unicode value (SQL Server)
SQL Server uses what this paper calls homoglyphic transformation and often converts characters that can't be represented to near equivalents. Such as losing the accent on a character or changing smart quotes to plain quotes. I agree that doesn't look very close though! I'm not sure if or where these transformations are documented.
Sep
15
awarded  Enlightened
Sep
13
comment Inserting to table: Insert rows with Left Outer Join or Insert rows then Update?
If you tag "performance" and "optimisation" you should generally tag the RDBMS you are using too.
Sep
10
comment Explain plan shows a table not in the query
And my guess is that it is CAUFV that is the view referring to AUFK as I don't see that in the explain. Maybe the V is a clue.
Sep
9
awarded  Good Answer
Sep
9
awarded  Enlightened
Sep
9
awarded  Nice Answer
Sep
9
reviewed Approve suggested edit on Sql Server - Select while insert on another transaction gives unexpected results
Sep
9
awarded  Nice Answer
Sep
8
comment A lot of data in the table is only accessed for 4 days or so, how to handle it afterwards?
What RDBMS are you using?
Sep
8
revised Iterate through all non-system databases and empty them
Took a guess at what follows "em"