|
|
-
Clark Baker Liked 7 Months ago through Just Learned | 1 Point
I am working a Data Quality Services Demo where i had to figure out how to write a domain rule to validate a email address. for this task, i re-learned how to write a regular expression; here's my basic version: [A-Za-z0-9._-]+@[A-Za-z0-9.-]+.[A-Za-z...
|
-
Clark Baker Learned 7 Months ago through Just Learned | 1 Point
I am working a Data Quality Services Demo where i had to figure out how to write a domain rule to validate a email address. for this task, i re-learned how to write a regular expression; here's my basic version: [A-Za-z0-9._-]+@[A-Za-z0-9.-]+.[A-Za-z...
|
-
Clark Baker Learned 8 Months ago through Just Learned | 1 Point
Normally, people uses PARSENAME fuction to retrieve Server,Database,Owner and Object from four part query.
Here is another use of same to remove decimal points
SELECT PARSENAME('$12,345.00',2) -- $12,345...
|
-
Clark Baker Liked 8 Months ago through Just Learned | 1 Point
Normally, people uses PARSENAME fuction to retrieve Server,Database,Owner and Object from four part query.
Here is another use of same to remove decimal points
SELECT PARSENAME('$12,345.00',2) -- $12,345...
|
-
Clark Baker Liked 9 Months ago through Just Learned | 1 Point
Recently I came across a code written by a developer. He was trying to solve a problem to find max and min value among multiple column for each row. Through Below dummy code I am trying to explain -
--Use tempdb
USE tempdb
--Create ...
|
-
Clark Baker Liked 9 Months ago through Just Learned | 1 Point
Recently I came across a code written by a developer. He was trying to solve a problem to find max and min value among multiple column for each row. Through Below dummy code I am trying to explain -
--Use tempdb
USE tempdb
--Create ...
|
-
Clark Baker Learned 9 Months ago through Just Learned | 1 Point
Recently I came across a code written by a developer. He was trying to solve a problem to find max and min value among multiple column for each row. Through Below dummy code I am trying to explain -
--Use tempdb
USE tempdb
--Create ...
|
-
Clark Baker Learned 9 Months ago through Just Learned | 1 Point
Recently I came across a code written by a developer. He was trying to solve a problem to find max and min value among multiple column for each row. Through Below dummy code I am trying to explain -
--Use tempdb
USE tempdb
--Create ...
|
-
Clark Baker Learned 10 Months ago through Just Learned | 1 Point
Typically when we require a number to be represented as a string we employ a CAST or CONVERT.
Sometimes though we want to preserve the natural 'sortability' of the numbers **after** the conversion and this poses a problem as string '8' is "bigger" t...
|
-
Clark Baker Learned 10 Months ago through Just Learned | 1 Point
Typically when we require a number to be represented as a string we employ a CAST or CONVERT.
Sometimes though we want to preserve the natural 'sortability' of the numbers **after** the conversion and this poses a problem as string '8' is "bigger" t...
|