|
|
-
Mani255 Commented 2 Years ago through Just Learned | 1 Point
Actually this is a logical puzzle.
If we have 2 integers, as DAY and MONTH, and then their multipliers. Here multipler can be 12 and 31 or 14 and 51 or any other even odd pair.
Then we can divide the SUM(DAY * 12 + MONTH * 31) with 12. Now as DAY * 1...
|
-
Mani255 Commented 2 Years ago through Just Learned | 1 Point
Actually this is a logical puzzle.
If we have 2 integers, as DAY and MONTH, and then their multipliers. Here multipler can be 12 and 31 or 14 and 51 or any other even odd pair.
Then we can divide the SUM(DAY * 12 + MONTH * 31) with 12. Now as DAY * 1...
|
-
Mani255 Commented 2 Years ago through Just Learned | 1 Point
Actually this is a logical puzzle.
If we have 2 integers, as DAY and MONTH, and then their multipliers. Here multipler can be 12 and 31 or 14 and 51 or any other even odd pair.
Then we can divide the SUM(DAY * 12 + MONTH * 31) with 12. Now as DAY * 1...
|
-
Mani255 Posted 2 Years ago through Just Learned | 5 Points
Following are the 3 comparison operators that most of the developers do not use commonly. These are not in ISO standards.
[code]
!=
(Not Equal To) (less uncommon)
!<
Not less than
!>
Not greater than
[/code]
There are alterna
|
-
Mani255 Posted 2 Years ago through Just Learned | 5 Points
Following are the 3 comparison operators that most of the developers do not use commonly. These are not in ISO standards.
[code]
!=
(Not Equal To) (less uncommon)
!<
Not less than
!>
Not greater than
[/code]
There are alte...
|
-
Mani255 Posted 2 Years ago through Just Learned | 5 Points
Following are the 3 comparison operators that most of the developers do not use commonly. These are not in ISO standards.
[code]
!=
(Not Equal To) (less uncommon)
!<
Not less than
!>
Not greater than
[/code]
There are alte...
|
-
Mani255 Learned 2 Years ago through Just Learned | 1 Point
Following are the 3 comparison operators that most of the developers do not use commonly. These are not in ISO standards.
[code]
!=
(Not Equal To) (less uncommon)
!<
Not less than
!>
Not greater than
[/code]
There are alte...
|
-
Mani255 Learned 2 Years ago through Just Learned | 1 Point
Following are the 3 comparison operators that most of the developers do not use commonly. These are not in ISO standards.
[code]
!=
(Not Equal To) (less uncommon)
!<
Not less than
!>
Not greater than
[/code]
There are alte...
|
-
Mani255 Learned 2 Years ago through Just Learned | 1 Point
Just learned from pinal's blog about the usage of DBCC CLEANTABLE. When we drop any variable length column, immediately space will not be reclaimed. By using DBCC CLEANTABLE we can reclaim the space.
[code]
DBCC CLEANTABLE ('TestDB','TestTable', 0)
...
|
-
Mani255 Learned 2 Years ago through Just Learned | 1 Point
Just learned from pinal's blog about the usage of DBCC CLEANTABLE. When we drop any variable length column, immediately space will not be reclaimed. By using DBCC CLEANTABLE we can reclaim the space.
[code]
DBCC CLEANTABLE ('TestDB','TestTable', 0)
...
|