SQL Helper : SQL tips and tricks
SQL Server - Convert Datetime Format
If you want to see datetime field in difference format
SQL Server - Case When Then Else
If you want to use "If Then Else" in SQL query you can use "CASE".
SQL Server - Transaction Log is Full
When you've found error like "..transaction log is full.." in MS SQL Server.
Displaying number in currency format in SQL
If you want to display the number 12345 as 12,345.
Days of Month
To find how many days in specific month.
Round Function & Floor Function
Display float number as integer.
SQL Server - Add / Drop Primary Key
To add or drop constraint primary key in Microsoft SQL Server.
SQL Server - Alter Column Set Default
To default value of a field in Microsoft SQL Server.
| Comment no. 1 |
1
From ½ø¿ÚÖá³Ð Date 09/07/50 Time 17.31 [60.191.36.91]
|
| Comment no. 2 |
1
From 163Öá³ÐÍø Date 15/09/50 Time 23.56 [60.190.240.76]
|
| Comment no. 3 |
ÕâÑù
From 1 Date 03/04/51 Time 20.30 [60.190.240.76]
|
|
