547 reputation
1411
bio website devworx-software.de
location Augsburg, Germany
age 49
visits member for 2 years, 1 month
seen 7 hours ago

Softwaredeveloper and shareholder of http://www.devworx-software.de/

Main interests component development (Delphi), SQL.

Hobbys: sports shooter, diver

proud father of 4 wonderful children

origin Brotkasten C64 Basic PDS assembler Foxpro Delphi 1 - XE3 MS SQL Server, Access

main field of work , developing of customer-specific solutions


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/…
Jan
7
comment Update many-to-many relationship table
What about never deleting and using a structure like: taskmembers (task_ID id, member_id id, active_Since DateTime, active_until DateTime) active members would be (active_until IS NULL) or active_until>GetDate())
Dec
29
comment Max connections SQL Server Express could have?
Last edition with limitation in concurrent users was Server 2000 msdn.microsoft.com/en-us/library/ms165672%28SQL.90%29.aspx
Dec
28
comment How much do foreign keys affect performance?
stackoverflow.com/questions/507179/…
Dec
25
comment Pivot a table to repeat the first column for each following column
You can find examples here ewbi.blogs.com/develops/2005/01/access_sql_tran.html msdn.microsoft.com/en-us/library/office/… but if I got you right you are searching for the opposite.