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
|
May 17 |
comment |
convert(varchar, getdate(), 112) or convert(varchar(8), getdate(), 112) 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. |
|
Dec 24 |
comment |
Sql server update query locking stages? @ThomasStringer why didn't you post this as answer? |
|
Dec 21 |
comment |
Monitor Sql Server 2000 this might be useful: zabbix.com/screenshots.php |
|
Nov 26 |
comment |
Bitwise operations in TSQL AFAIK no, sorry |
|
Nov 26 |
comment |
Bitwise operations in TSQL anything is stored binary, just a arrangement (perhaps bad translation) what's the meaning of the data, perhaps you are looking for a funtion for displaying data in binary format as varchar? |
