|
|
-
Clark Baker Liked 7 Months ago through Just Learned
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
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 Liked 7 Months ago through Blogs
SQL injection refers to the ability of an attacker to inject a rogue SQL command to the database within a seemingly legitimate request. One of the most common myths that surrounds SQL Injection is that it is due to the use of EXEC or EXECUTE. Some say –...
|
-
Clark Baker Liked 8 Months ago through Just Learned
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 Learned 8 Months ago through Just Learned
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
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
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
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
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 ...
|
-
Which SQL Server database does not follow ACID properties? Explain the reasons behind your answer....
|