CR: Date Format
|
Pattern Result
d Numeric day of month without leading zero (1, 7, 31)
dd Numeric day of month with leading zero (01, 07, 31)
ddd Three day abbreviation of day of week (Mon, Sat)
dddd Full name of day of week (Monday, Saturday)
M Numeric month without leading zero (1, 7, 12)
MM Numeric month with leading zero (01, 07, 12)
MMM Three letter abbreviation of month (Jan, Feb, Mar)
MMMM Full name of month (January, February, March)
yy Last two digits of year (11, 14, 22)
yyyy Full four digits of year (2011, 2014, 2022)
Usage: ToText(CurrentDate, "MM")
POSTED BY juong |
SSMS: Reset Auto-Increment Value
|
Value will be 1 for the next record insert
DBCC CHECKIDENT ("YourTableNameHere", RESEED, 0);
POSTED BY juong |
Popular Posts
-
Rumi Ke Jawi 1. Convert rumi ke jawi secara online. senang sekali! 2. Lepas covert, copy dan paste kat microsoft word, 3. dan pilih font ...
-
Nowadays, peoples know about programming and think that programming is killer subject. This case, you must set your mind what is better to d...
-
1) Kaedah persenyawaan teknik bantuan Re-produktif (ART). Kaedah ART ialah kaedah yang dilakukan dengan memasukkan sperma/embrio ke dal...
-
Encoding JSON in PHP Some years ago, JSON support was provided through the json pecl extension. Since PHP 5.2, it is included in the core ...
-
Chapter 1: Function Definition: function is relation of object and image. In other word, function is a correspondence between two sets A and...
-
This means that you have too many database connections basically. Unfortunately since the demise of svrctl, it also means that you as a DBA ...
-
First step we must to do is get a PM or IM with your friend user name or id. Then try to send a file (picture, mp3, etc), then wait unti...
-
In Windows 8, now that the Start Menu is now gone and replaced by the Start Screen and Charms bar. This means that if you want to restart yo...
-
Not set up a security code so that anyone trying to access your phone will need to code to get into it. Press the Nokia Menu key to the left...
-
1. Problem Statement I am wondering if there is a way to transfer over a parent element with all of its children elements that have the same...