Reputation
3,037
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
12 30
Newest
 Custodian
Impact
~118k people reached

Aug
19
revised Query to get result in Excel file
improved formatting, rephrased for clarity
Aug
19
revised Update all table's columns with another table's colums
added 27 characters in body
Aug
19
comment How to insert (file) data into a PostgreSQL bytea column?
@miracle173: Thanks, I guess my decision was just too hasty or superficial (or both). I'll be more careful next time. By the way, I don't get notifications when you address me as Andriy_M. The underscore is not in my username so the system doesn't find me. Andriy or AndriyM will work just fine. (Personally I'm fine with your version, it's just to make our communication more productive.)
Aug
19
comment How to insert (file) data into a PostgreSQL bytea column?
@miracle173: Because I got the impression that some of the suggested tags were irrelevant (well, just one actually, blob). If that was a mistake, I sincerely apologise.
Aug
19
reviewed Reviewed Mysql error “#1030 - Got error -1 from storage engine” when doing insert/update queries
Aug
19
revised Mysql error “#1030 - Got error -1 from storage engine” when doing insert/update queries
improved formatting, removed "thanks"
Aug
19
reviewed No Action Needed See SQL Server Reporting Services Reports without logging in?
Aug
19
reviewed Reject How to insert (file) data into a PostgreSQL bytea column?
Aug
19
revised Optimizing query using a WHILE statement
minor fixes to sooth my OCD
Aug
19
comment Optimizing query using a WHILE statement
Exactly, why 2x? What are we helping that guy with?
Aug
18
revised Cannot find one or more components. Please reinstall the application
deleted 12 characters in body; edited tags; edited title
Aug
18
comment Detect if two time periods overlap
Usually just @Start < EndDate and @End > StartDate suffices.
Aug
18
revised Detect if two time periods overlap
deleted 1 character in body
Aug
18
revised Detect if two time periods overlap
deleted 1 character in body
Aug
18
comment How to extract pipe-delimited data using BCP?
@CraigEfrein: Quotename expects a string (i.e. as the first param), so if you pass a different type, it will be converted implicitly.
Aug
18
comment How to extract pipe-delimited data using BCP?
@JPChauhan: It's the same login method as in your answer. If you want it to be different, you can read the manual and choose the appropriate combination of command-line parameters to match your requirements.
Aug
18
comment How to extract pipe-delimited data using BCP?
So in the end, there is no option in BCP to enforce the quotes, you have to generate them in the query. One would think it shouldn't be that hard to add support for them, but... Oh well
Aug
18
revised How to extract pipe-delimited data using BCP?
formatting
Aug
18
revised How to increment field value count using MySQL
formatting, grammar
Aug
18
comment User-shared queries: Dynamic SQL vs. SQLCMD
What is the purpose of use ... in your script? Is it important to the correct execution of the subsequent query? I'm asking because if changing the current database is one of the expected results of your query, the dynamic SQL version will only change it in the scope of the dynamic query, not in the outer scope, unlike the SQLCMD variation (which, of course, has only one scope).