Most sql server date format related news are at:
Generate msbuild file from solution 5 Aug 2013 | 06:11 am
Here is a quick way to generate a start up msbuild file from your solutions file. Launch Visual Studio Command prompt and change directory to your project directory and then type the following 2 comm...
++ operator in VB.Net 14 Jun 2013 | 10:40 am
We do miss the power of ++ operator in Vb.Net. Here is a quick way to achieve the same result Use System.Math.Max(System.Threading.Interlocked.Increment(i),i – 1) to achieve the same result as i++ ...
More sql server date format related news:
SQL Server Date Format and Convert DateTime to particular format chiragrdarji.wordpress.com 31 Jul 2010 | 12:28 am
I was playing with different date format in SQL Server as need to display date in YYYY-MM-DD HH:MI:SS.MMM format. I knew there is a CONVERT function which can do this however I did not have the ex...
DateTime in SQL Server codebarlet.com 15 Jan 2012 | 09:10 am
Date and Time in SQL Server is very important, in almost every application you have good reasons to use the date and time. Since it’s very useful for us, SQL Server has the data type datetime and smal...
Format Tanggal MSSQL sawahurang.wordpress.com 25 Jun 2010 | 09:36 pm
Referensi Format data MS SQL Standard Date Formats Date Format Standard SQL Statement Sample Output Mon DD YYYY 1 HH:MIAM (or PM) Default SELECT CONVERT(VARCHAR(20), GETDATE(), 100) Jan 1...
convert() function in sql codebarlet.com 10 Jan 2012 | 12:31 am
This function in sql server is used for mostly two reasons; to convert one datatype into another datatype or for conversion of date/time formats. So you can convert integer to varchar, varchar to date...
OBIEE Date Features oasisbiee.wordpress.com 10 Mar 2011 | 06:11 pm
Hi all, One of my clients wants to build OBIEE reports using the SQL Server data source. We created the data model, reports and started doing the testing. During our testing the OBIEE reports are ru...
Exporting data from SQL Server Express 2005 to CSV using PHP daipratt.co.uk 10 Jun 2011 | 08:55 pm
Annoyingly, one of the limitations of SQL Server Express 2005 is that it doesn’t allow you to export data as CSV, or any other format (bar SQL) for that matter. This is fine is you have a small datase...
SQL Server Sorting By Multiple Columns kavidesign.com 19 Aug 2011 | 06:33 pm
Today I have asked a question from a friend of mine developing with sql server and converting some oracle queries to mssql format. Here is oracle query: SELECT * FROM HIZMETBELGESI WHERE PERSONELID =...
SQL Server: Find modified Stored Procedures with Dates rjpargeter.com 3 Jun 2011 | 09:03 pm
Good little query to find modified dates of SQL Server stored procedures. The following example will find stored procs that have been modified in the last 7 days. SELECT name, modify_date FROM sys....
有用的sql 语句 blog.dic123.com 6 Aug 2009 | 09:20 pm
In a recent post, I demonstrated how the sys.procedures catalog view could be used to determine the date and time that a stored procedure was last modified in SQL Server 2005. A similar technique can...
