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…
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 ev…
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 wh…
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 correct…
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 …