Avoiding Unexpected Results with DATEDIFF in Year Comparisons
Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.
2018-04-09
1,695 reads
Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.
2018-04-09
1,695 reads
2016-12-22
1,528 reads
Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? This first part in an ongoing series of cursor-killing handles inter-row analysis.
2015-12-18 (first published: 2014-05-27)
22,536 reads
Have you ever wanted to compute age, but the results from the DATEDIFF function seemed to be wrong some of the time? This tip covers why the DATEDIFF function does not always reliably compute age.
2012-05-23
4,752 reads
This function returns the difference between the date in text format
2011-10-03 (first published: 2011-08-30)
1,010 reads
Learn how to use Dateadd/Datediff functions to manipulate dates in this short article from Seth Phelabaum.
2010-04-07
31,530 reads
Days, hours and minutes since SQL Server service was started
2010-11-05 (first published: 2010-01-15)
2,477 reads
Okay. Just went through this several weeks ago. This ended up being my solution. Because of the amount of events that I'm tracking I had to create a stored procedure because the set events went beyond the length of the Jobs window. Here is the header for the stored procedure. First step is to output […]
2005-03-30
"As per my experience, uploading file by natual DTS is so flexible. For example, the file name is not allowed to changed. "The name of the file can be changed by using the Visual Basic Active X Script functionality within DTS. Just send the output of the text file destination icon to the active x icon and […]
2005-03-30
HelloSQL Authentication, its normal user not belong to any group its a son of SQL server only I've just create it in Logins in EM and assigened it to 1 view only, Acctually he can read the data from that view, but also he can browse the whole other views design, even all DTS logic […]
2005-03-25
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
Hi everyone, In below code I am creating a table and inserting some english...
backup log to int run every hour. If a log init backup is run...