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...
-
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 ...
-
Sebelum download Arabic Dotted / titik-titik, Aracbic font perlu di install terlebih dahulu. Install arabic font di sini Kalau dah install, ...
-
This means that you have too many database connections basically. Unfortunately since the demise of svrctl, it also means that you as a DBA ...
-
Step to remove: Go to Start > Run and type: MSCONFIG , and hit enter. Click on the BOOT.INI tab and then click on "Check All Boot ...
-
Learning content is a digital resource that can be reused to support learning (Wiley, 2002). A learning content can be a single file materia...
-
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...
-
1) Kaedah persenyawaan teknik bantuan Re-produktif (ART). Kaedah ART ialah kaedah yang dilakukan dengan memasukkan sperma/embrio ke dal...
-
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...