|
|
-
LadyRoot Learned 1 Years ago through Just Learned | 1 Point
Recently I got a requirement to display groups along with number of products in the group, where cost of product falls in certain range. Additional requirement is, even if a group doesn’t have any items in the range; still show that group with the Numb...
|
-
LadyRoot Learned 1 Years ago through Just Learned | 1 Point
Recently I got a requirement to display groups along with number of products in the group, where cost of product falls in certain range. Additional requirement is, even if a group doesn’t have any items in the range; still show that group with the Numb...
|
-
LadyRoot knew 1 Years ago through Just Learned | 1 Point
Set `ARITHABOBRT` and `ANSI_WARNINGS` as OFF to handle division by Zero error
SET ARITHABORT OFF
SET ANSI_WARNINGS OFF
SELECT 1/0
This will not throw an error. Result will be NULL
...
|
-
LadyRoot knew 1 Years ago through Just Learned | 1 Point
Set `ARITHABOBRT` and `ANSI_WARNINGS` as OFF to handle division by Zero error
SET ARITHABORT OFF
SET ANSI_WARNINGS OFF
SELECT 1/0
This will not throw an error. Result will be NULL
...
|
-
LadyRoot Liked 1 Years ago through Just Learned | 1 Point
Today, I could not remember quickly how we check for the existence of schema in a database. This is not something I just learned, but something I forgot over the course of time. Since I don't want to rummage through my scripts or hit the web and to h...
|
-
LadyRoot Learned 1 Years ago through Just Learned | 1 Point
Today, I could not remember quickly how we check for the existence of schema in a database. This is not something I just learned, but something I forgot over the course of time. Since I don't want to rummage through my scripts or hit the web and to h...
|
-
LadyRoot Liked 1 Years ago through Just Learned | 1 Point
Today, I could not remember quickly how we check for the existence of schema in a database. This is not something I just learned, but something I forgot over the course of time. Since I don't want to rummage through my scripts or hit the web and to h...
|
-
LadyRoot Learned 1 Years ago through Just Learned | 1 Point
Today, I could not remember quickly how we check for the existence of schema in a database. This is not something I just learned, but something I forgot over the course of time. Since I don't want to rummage through my scripts or hit the web and to h...
|
-
LadyRoot Learned 1 Years ago through Just Learned | 1 Point
Suppose you have a huge table which has say 30-40 columns and you want to select all of them or most of them say around 30 columns. It is a tedious job to type each of the column names. Here is a quick way to get a comma separated list of all the column...
|
-
LadyRoot Learned 1 Years ago through Just Learned | 1 Point
Suppose you have a huge table which has say 30-40 columns and you want to select all of them or most of them say around 30 columns. It is a tedious job to type each of the column names. Here is a quick way to get a comma separated list of all the column...
|