Reputation
623
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 6 14
Newest
 Constituent
Impact
~61k people reached

Jun
10
comment Duplicate records referenced across different databases
Hi Ralph are you connected with Dataladder in any way?
Jun
1
comment MySQL incremental backups per database (not global)
Hi nima02, please take a look here
May
27
comment Can't select 2 tables at the same time
Hi Vasque, please remove the solution from the question. You might add an own answer if you like and it differs from given solutions.
Jan
7
comment SQL Server Express to SQL Server Standard upgrade?
This question appears to be off-topic because it is about licensing/legal advice and POB
Aug
21
comment SET IDENTITY_INSERT equivalent in Access
I have no problem in Access 2003 and 2007 to add any value via insert sql, even if there are foreign keys defined to the Autonumber column. An update per SQL on the field however is not possible.
Aug
21
comment SET IDENTITY_INSERT equivalent in Access
stackoverflow.com/a/7691439/1699210
Jun
5
comment Can I install SQL Server 2012 on a machine with 2008 R2 already?
superuser.com/questions/402785/…
May
31
comment Parent-Child Tree Hierarchical ORDER
+1 but using [ICFilterID] [int] IDENTITY(1,1) for sorting will only work it items are inserted in correct sequence, but an other field for sorting is not yet implemented by OT
May
17
comment Convert a date to yyyymmdd format
no direct reference to your question msdn.microsoft.com/en-us/library/ms176089.aspx
May
14
comment Check programmatically if SQL Server needs restarting
@Rav did an edit
May
10
comment Get Maximum Value
@MitchWheat I know Tie from SQL-Server, do you know from MS-Access?
Feb
25
comment Named Pipe Provider Error code 40
you might find this useful: stackoverflow.com/questions/9945409/…
Feb
15
comment LIKE character length limitation
@ dezso sqlfiddle.com/#!6/d41d8/2586, -- commented select will give 1, last select will give 0
Feb
15
comment LIKE character length limitation
to fit the conditions t2 would have to have a productlist with at least the exact same "text" as t1. Similar in order, spacing, content ...
Jan
28
comment Could not find stored procedure
sqlserverlearner.com/2011/…
Jan
28
comment Could not find stored procedure
[ACT] is the correct database?
Jan
22
comment How to select row and column name where field is null?
@msi77 sorry, of course, usually you are right Declare @a Varchar(10) Declare @b Varchar(10) Select @a ='Test' SET CONCAT_NULL_YIELDS_NULL OFF Select @a+@b SET CONCAT_NULL_YIELDS_NULL ON Select @a+@b
Jan
18
comment SQL Subquery , One to Multiple rows
Sorry :-( ... I did an edit...
Jan
16
comment How to select row and column name where field is null?
@msi77 this would be AND not OR
Jan
7
comment How to determine SQL server version install history? I.E. When it was updated last
social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/…