Viewing 15 posts - 1 through 15 (of 149 total)
Ok, then it's due to my english knowledge. I missed the 'in' and understood it as 'for'. 🙂
July 1, 2019 at 8:18 am
Please clear it up for me. Why isn't an option to create a procedure. If i'm using that SQL snippet from an application with different parameters, i'd surely create a...
June 28, 2019 at 9:45 am
Datatype precedence!! :ermm:Where is my coffee, please! 😀
December 4, 2018 at 1:24 am
Actually not only money type can be initialized this way. It works at any type where an implicit conversion from 0.00 is available, as select \; returns...
November 30, 2018 at 3:03 am
Would never guess. It seams to be illogical for me. 🙂
October 10, 2018 at 2:38 am
Compressed backups have CHECKSUM by default or is the BOL wrong? Or is it too early and i have to wake up first?
June 25, 2018 at 12:48 am
June 18, 2018 at 7:41 am
I don't think you wanna do what you wrote in the trigger. You should find a unique column or a set of columns in your table to use in the...
May 10, 2018 at 12:19 am
But we are restoring on a new instance and not on the same one. Or am i understanding something wrong?
April 12, 2018 at 1:06 am
Is it a typo?
September 29, 2017 at 12:08 am
The only proper answer would be:SIGN(n)*FLOOR(ABS(n))
August 22, 2017 at 12:14 am
In my opinion there is no right answer to choose.If we are using CEILING instead of FLOOR we will scrap the result of 'Coffee'. The FLOOR(ABS()) is a much...
August 22, 2017 at 12:08 am
July 20, 2017 at 7:16 am
In my opinion RTO is playing a role as well, for example in live data collection systems, where downtime is very critical.
July 20, 2017 at 1:59 am
select * from(SELECT COUNTY.CountyName,ORDERS.UserDate2 AS LastCovered, FSLog.CompletedDate, property.State, ROW_NUMBER() over (partition by COUNTY.CountyName order by ORDERS.UserDate2 desc) as ordering
FROM ORDERS INNER...
June 5, 2017 at 9:55 am