No. There is no such option available from Oracle SQL Developer. You have to execute a query by hand or use other tool (For instance PLSQL Developer has such option). The following SQL is that one used by PLSQL Developer: select table_name, constraint_name, status, owner from all_constraints where r_owner = :r_owner and constraint_type=”R” and r_constraint_name … Read more
From the now unavailable internet archive: Go to Edit -> Preferences -> SQL Editor and set to a higher value this parameter: DBMS connection read time out (in seconds). For instance: 86400. Close and reopen MySQL Workbench. Kill your previously query that probably is running and run the query again.
This should work: SELECT age, count(age) FROM Students GROUP by age If you need the id as well you could include the above as a sub query like so: SELECT S.id, S.age, C.cnt FROM Students S INNER JOIN (SELECT age, count(age) as cnt FROM Students GROUP BY age) C ON S.age = C.age
You could use CAST or CONVERT: SELECT CAST(MyVarcharCol AS INT) FROM Table SELECT CONVERT(INT, MyVarcharCol) FROM Table
SELECT logcount, logUserID, maxlogtm, DATEDIFF(day, maxlogtm, GETDATE()) AS daysdiff FROM statslogsummary WHERE ( DATEDIFF(day, maxlogtm, GETDATE() > 120) Normally you can’t refer to field aliases in the WHERE clause. (Think of it as the entire SELECT including aliases, is applied after the WHERE clause.) But, as mentioned in other answers, you can force SQL to … Read more
You can’t return two (or multiple) columns in your subquery to do the comparison in the WHERE A_ID IN (subquery) clause – which column is it supposed to compare A_ID to? Your subquery must only return the one column needed for the comparison to the column on the other side of the IN. So the … Read more
The question is tagged SQL Server 2000 but for the benefit of people developing on the latest version I’ll address that first. SQL Server 2014 In addition to the methods of adding constraint based indexes discussed below SQL Server 2014 also allows non unique indexes to be specified directly with inline syntax on table variable … Read more
You can simply add the two. if the Time part of your Date column is always zero and the Date part of your Time column is also always zero (base date: January 1, 1900) Adding them returns the correct result. SELECT Combined = MyDate + MyTime FROM MyTable Rationale (kudos to ErikE/dnolan) It works like … Read more
There are three formats of case expression. You can do CASE with many WHEN as; CASE WHEN Col1 = 1 OR Col3 = 1 THEN 1 WHEN Col1 = 2 THEN 2 … ELSE 0 END as Qty Or a Simple CASE expression CASE Col1 WHEN 1 THEN 11 WHEN 2 THEN 21 ELSE 13 … Read more
Expanding on Mitch Wheat’s code, the following script will generate the command to drop the constraint and dynamically execute it. declare @schema_name nvarchar(256) declare @table_name nvarchar(256) declare @col_name nvarchar(256) declare @Command nvarchar(1000) set @schema_name = N’MySchema’ set @table_name = N’Department’ set @col_name = N’ModifiedDate’ select @Command = ‘ALTER TABLE ‘ + @schema_name + ‘.[‘ + … Read more