by Daniel Siegl | May 18, 2016 | General
Wir werden immer wieder gefragt, wie man in Enterprise Architect herausfinden kann welche Anforderungen bereits an Software- oder Systemkomponenten verlinkt sind, um die Architektur-Anfoderungs-Traceability zu erfüllen. Im Bereich des Systems Engineering mit SysML...
by Daniel Siegl | Aug 26, 2014 | General
Please note, that this article belongs to EAP files only! You won’t have a problem with the given SQL Statement, if you’re running the repository on SQL Server or Oracle or whatever database. Except EAP: As you might know, EAP files are MS Access database...
by Daniel Siegl | Feb 14, 2012 | General
Sometimes you need to search your database case-sensitive. But: Microsoft SQL Server is usually configured to be case-INsensitive. But there’s no need to reconfigure the whole database, here are my 2 favorites to lookup data: cast column-value and searchterm to...
by Daniel Siegl | Jul 1, 2011 | General
Anybody ever tried to search in ntext or text fields on MS SQL Server? Common experience is to fail. Solution: cast your search-term to text type, and try again. Example, using EA-Database: SELECT * FROM t_xref x WHERE x.Description LIKE...
by Daniel Siegl | Jan 13, 2011 | General
This is a very simple scenario, but is taken from a very complex one. A Customer may have more than 1 address, some may have none. You only want each customer to appear only once. So what can you do? SELECT C.Name, A.Address FROM Customer AS C OUTER APPLY (SELECT TOP...
by Daniel Siegl | Oct 5, 2010 | General
SQL Server Management Studio In some cases the user might install the SQL Server Express Edition, before a “real” SQL Server (Developer Edition). This can result in a basic version of Management Studio. Keep in mind, that with SSMSE (e = Express), you...
by Daniel Siegl | Sep 28, 2010 | General
Im Rahmen eines OCF basierten Projektes brauchten wir die Möglichkeit komplexe Sql Abfragen abbilden zu können. Eine QueryBuilder musste her, dabei sollte die Anwendung aber möglichst einfach sein. Auf der Codeproject Seite “SelectQueryBuilder: Building complex...
by Daniel Siegl | Apr 14, 2010 | General
There are a lot of scripts out there promising to create insert scripts. You pass in the name of the table, and the scripts create an insert statement for each record contained. Only problem they have: the more columns there are, the greater the chance of lines being...
by Daniel Siegl | Mar 1, 2010 | General
How to use an Update Cursor on MS SQL Server. Requirements: If the update-table does not have a Primary Key, the cursor is read-only. So I advise to create at least a temporary Primary Key, and delete it afterwards. Usage: DECLARE curs as CURSOR FOR SELECT * FROM...
by Daniel Siegl | Jun 3, 2009 | General
Im Folgenden habe ich zwei Varianten einer sich ziemlich ändelnden SQL Abfrage: SELECT Top 1 Employees.Country, Employees.LastName, Employees.FirstName, Orders.ShippedDate, Orders.OrderID, “Order Subtotals”.Subtotal AS SaleAmount FROM Employees INNER JOIN...
Recent Comments