I have used the following function to convert dates according to desired textual formats that were not immediately available in the standard styles on offer.
2013-10-18 (first published: 2013-10-01)
1,866 reads
2013-03-11 (first published: 2013-02-20)
2,075 reads
This utility will generate column and parameter metadata in various useful formats for tables, views, and procedures.
2013-02-12 (first published: 2013-01-18)
716 reads
Performance test of new SQL 2012 functions DateTimeFromParts and Format
2012-05-10
6,067 reads
Everyone knows that in SQL 2000, yes 2000, Microsoft jumped aboard the bandwagon of other platforms, and gave the developers...
2011-04-07
12,319 reads
Another in the series of articles to help you "fill in the cracks" in your T-SQL knowledge. MVP Jeff Moden shows us a super simple, high performance method to solve this timeless problem.
2013-07-19 (first published: 2011-01-20)
22,136 reads
Display a row vertically when a table has hundreds of columns to avoid scrolling.
2010-01-21 (first published: 2009-12-30)
3,141 reads
You can create a view to hold the output of the two queries as CREATE VIEW MYUNIONDATE AS(SELECT Name, MaxOfDateQC FROM vw_vendor_current_mech UNION ALL SELECT Name, MaxOfDateQC FROM vw_vendor_current_elec)GOUPDATE TblVendors SET TblVendors.Vendor = 1 WHERE TblVendors.Name IN (SELECT [Name] FROM MYUNIONDATE)Thanks
2005-05-18
Last time I checked, it was not needed. As always, run the tests to verify. Most firewall admins balk at allowing any NetBIOS traffic, so I think you'd have heard about it if it was allowed. As for articles, I'll cite mine from the November 2004 issue of SQL Server Standard. http://www.sqlserverstandard.com/issue/200411.aspx There's also information […]
2005-03-16
1 reads
do you mind to post what - print @strSQL - looks like after the last select
2005-02-23
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers