meta user
network profile
| bio | website | devworx.de |
|---|---|---|
| location | Augsburg, Germany | |
| age | 47 | |
| visits | member for | 6 months |
| seen | 6 hours ago | |
| stats | profile views | 19 |
Softwaredeveloper and shareholder of www.devworx.de.
Main interests component development (Delphi), SQL.
Hobbys: sports shooter, diver
|
Feb 21 |
answered | How can FLOOR(3) equal 2? |
|
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 ... |
|
Feb 7 |
answered | how to return table on sql function |
|
Feb 5 |
answered | Can SQL Server Management Studio Express be installed standalone? |
|
Jan 31 |
answered | Total of Same Customer ID from a Single DB Table |
|
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 21 |
answered | How to select row and column name where field is null? |
|
Jan 18 |
comment |
SQL Subquery , One to Multiple rows Sorry :-( ... I did an edit... |
|
Jan 18 |
revised |
SQL Subquery , One to Multiple rows deleted 3 characters in body |
|
Jan 18 |
answered | SQL Subquery , One to Multiple rows |
|
Jan 16 |
comment |
How to select row and column name where field is null? @msi77 this would be AND not OR |
|
Jan 16 |
answered | How to select row and column name where field is null? |
|
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()) |
|
Jan 6 |
awarded | Critic |
|
Dec 29 |
answered | Max connections SQL Server Express could have? |
|
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 |
