Different Date Formats
You Can Find Some Date Functions and extracting the different Date Formats using the Convert and Cast
2012-03-23 (first published: 2007-10-26)
3,674 reads
Datetime Manipulation
Working with Time Spans and Durations in SQL Server
What is the best way to return the "duration" of an event in SQL, given the start and end datetime values? How can we add up these durations to return grand totals? What data types should be used to return this data to our clients? How do we handle overflows, such as when hours go over 23 or minutes total up to over 59? Are there any T-SQL functions or other techniques that are useful in these scenarios?
2007-10-24
4,455 reads
Payment due date function
Calculates the nth due date for any given date, while accounting for weekends.
2012-05-16 (first published: 2007-10-11)
2,902 reads
Gates on Parade
Gates were one of the big stories in the world this week. No not the ones in Central Park visited by delegates from around the world, but rather the keynote speech at the RSA Conference. Bill Gates wasn't too arrogant at this one. I'm sure security isn't an area that he feels completely confident in […]
2005-02-17
3 reads
RE: what is S-Lock?
Would you please give me an example that how can i set the lock on all the sp or queries?Please Thanks
2005-02-17
Software Development Engineer/Test Needed!!
Does the prospect of working with the latest technology on a site that reaches millions of people sound challenging and exciting? Then come be a part of MSN Entertainment, making the web more useful every day by combining the best content with the latest technology. Our team is looking for an experienced Software Design Engineer/Test […]
2005-01-07
RE: Cleaning up Replication Monitor
I'v encountered the same problems with a replication, When the publication was removed it didnt get totally deleted from the publication server. It all happend some time ago so I don't quite know anymore how I solved it, but I do remember that it made a difference how I removed the publication: by unchecking the […]
2004-07-13
1 reads
RE: Question of the Day for 29 Jan 2004
I disagree. Licensing is quiet different from building, developing and implementing systems or databases. Ofcourse, dba's will be asked about licensing, but I think this is rarely the case. It will happen as much as a VB developer will be asked about VS.NET licensing. Most orginizations I have worked have a dedicated manager taking care […]
2004-01-30
RE: PHP, MSSQL extensions connecting to SQL SERVER 2000
Does this help?http://www.php.net/manual/en/ref.mssql.php
2004-01-27
RE: Question of the Day for 19 Jan 2004
Creating a DTS package and saving it locally is correct, but so is creating a user database.I don't need to do a backup of the master for that (Assuming I have the files for it)-rich
2004-01-19
2 reads
Blogs
Step Up Your Data Game: Learn Advanced SQL Techniques for Analysis
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers