Setting up SQL triggers on the MAX database
Setting up SQL triggers on the MAX database or scheduling jobs can be very helpful in coordinating business logic and workflows. Contact me to learn more about how you can use these tools.
SQL Server
Read More
More Date Logic
declare @ThisDate datetime; set @ThisDate = getdate(); select dateadd(dd, datediff(dd, 0, @ThisDate), 0) — Beginning of this day select dateadd(dd, datediff(dd, 0, @ThisDate) + 1, 0) — Beginning of next day select dateadd(dd, datediff(dd, 0, @ThisDate) – 1, 0) — Beginning of previous day select dateadd(wk, datediff(wk, 0, @ThisDate), 0) — Beginning of this week…
Exact MAX and SQL Server Collation Sequence
Hi Readers, I thought I would note that I had a customer who had SQL Server installed from a purchased SQL 2008 R2 in Canada. Depending on the country it is possible that default collation may be different than that of the default installed by MAX. The MAX DB install in the default English US…
- 1
- 2