Which notation, methodology and tools for database designing, modeling, diagraming you prefer and why? Which notation, standards, methodology are the most broadly used and covered by different vendors? Which are standard and which are not? i.e. which are to stick with and which to avoid? And why do you prefer IDEF1X? Is not it more comfortable to stick with tools,
SQL UPDATE all values in a field with appended string CONCAT not working
Here is what I want to do: current table: Mystery Query ( something like “UPDATE table SET data = CONCAT(data, ‘a’)” ) resulting table: thats it! I just need to do it in a single query, but can’t seem to find a way. I am using mySQL on bluehost (I think its version 4.1) Thanks everyone. Answer That’s pretty much
What is the keyboard method for filtering in SQL Management Studio?
I make very heavy use of filtering in SQL Server Management Studio when working with a large number of stored procedures – but find it a slow process as I have to right click, move my mouse to select ‘filter’, type in filter, and then click OK. Is there hotkey to pull up the filter dialog when I have the
How to list relations in postgres schema
I need help with a pretty basic Postgres command, but I cannot find a reference anywhere. My cluster is set up like this: database_1 – schema_1 – schema_2 – relation_1 – …
How to get missing values in sql?
I need help. I have a sql table t2 related to two other tables t1 and t3. t2 has fields: I’m searching for values, where ifFromt3 is missing. I want to fint in this example, the value ifFromt3 = 3, because of it’s not present. I’m doing it like this example, but it doesn’t work correctly. This are the 3
using DateDiff to find duration in minutes
I am trying to use Datediff to find out the duration between columnA and columnB. This produces errors. Can anyone please help me with what I’m doing wrong? Answer how about trying this, not sure why you have stime = [exceptions2].starttime and etime = [exceptions2].endtime
How to set numwidth in the grid output of PL/SQL developer?
I’m running some queries in PL/SQL Developer, and one of the columns in the result has 18-digit numbers. Instead of displaying the entire number in the resulting grid, PL/SQL Developer displays only …
How to divide two columns?
I tried to divide two columns from joined tables but the result (value of column relative_duration) is always 0. The query is the following: SELECT t1.[user_1] ,t1.[user_2] ,t1.[…
c# Object obj’s value is {}. What is “{}”?
I’m using some old code that runs a sql query as a reference. At some point, it gets to something like: sqlDataAdapter.Fill(dataSet); DataRow dataRow = dataSet.Tables[0].Rows[0]; Object obj = …
Update values in identity column
How do I override the identity column in MSSQL? I tried : SET IDENTITY_INSERT GeoCountry ON UPDATE GeoCountry SET CountryID = 18 WHERE CountryID = 250 But I get back a Line 2: Cannot …