When using XML in SQL Server you can try to cast to a data type and receive null values where the cast fails. declare @T table ( Col varchar(50) ) insert into @T values (‘1’), (‘1.1’), (‘1,1’), (‘1a’) select cast(” as xml).value(‘sql:column(“Col”) cast as xs:decimal ?’, ‘decimal(28,10)’) as Col from @T Result: Col ————- 1.0000000000 … Read more
No joins or recursive CTEs needed. The standard gaps-and-island solution is to group by (value minus row_number), since that is invariant within a consecutive sequence. The start and end dates are just the MIN() and MAX() of the group. WITH t AS ( SELECT InfoDate d,ROW_NUMBER() OVER(ORDER BY InfoDate) i FROM @d GROUP BY InfoDate … Read more
Declare @CategoryID as int SET @CategoryID = CASE WHEN EXISTS(SELECT 1 FROM Categories WHERE Categoryname = @CategoryName) THEN 1 ELSE 0 END Another way would be something like …. IF EXISTS (SELECT 1 FROM Categories WHERE Categoryname = @CategoryName) BEGIN SET @CategoryID = 1; END ELSE BEGIN SET @CategoryID = 0; END
It is now even simpler: PostgreSQL 9.4 introduced the mode() function: select mode() within group (order by food_id) from munch group by country returns (like user2247323’s example): country | mode ————– GB | 3 US | 1 See documentation here: https://wiki.postgresql.org/wiki/Aggregate_Mode https://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-ORDEREDSET-TABLE
To determine the storage engine being used by a table, you can use show table status. The Engine field in the results will show the database engine for the table. Alternately, you can select the engine field from information_schema.tables: select engine from information_schema.tables where table_schema=”schema_name” and table_name=”table_name” You can change between storage engines using alter … Read more
You are looking for CURDATE(): $db->query(“SELECT * FROM events WHERE event_date >= CURDATE()”); Or: $db->query(“SELECT * FROM events WHERE event_date >= CURRENT_DATE()”);
The first query should use SQL_NO_CACHE to tell MySQL not to put the result into the cache. The second query uses the cache and the tells MySQL not to cache the result of that query, which does nothing. tl;dr – Reverse your queries.
You’re darn close – you need to use two dots in your check: IF OBJECT_ID(‘tempdb..#tmpTable1′) IS NOT NULL ** | use two dots here! Basically, this is saying: check in the tempDB and I don’t care what schema the table is in As Joe rightfully said: this is not 100% correct: it doesn’t check in … Read more
without Dynamic SQL each option it’s clause for example: ORDER BY case when @var1 = ‘priority asc’ THEN priority END ASC , case when @var1 = ‘priority desc’ then priority end DESC, case when @var2 = ‘report_date asc’ then report_date end ASC, case when @var2 = ‘report_date desc’ then report_date end DESC
Three year later. You can cast SELECT to_date(cast(createddate as TEXT),’YYYY-MM-DD’) FROM product_trainings;