I just learnt that, we can access environment variables simply by typing "%VariableName%" in "Run Window" (Win + R). Most of you might have used "%temp%" in your run window to reach the temp folder on your computer and that "temp" actually refers to ...

I just learnt that, we can access environment variables simply by typing "%VariableName%" in "Run Window" (Win + R). Most of you might have used "%temp%" in your run window to reach the temp folder on your computer and that "temp" actually refers to ...

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...

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...

Using WITH statement you can create a series of data and use them in your queries. Sample 1. Integer-Series

WITH T(ID) AS
(
	SELECT 1 ID
	UNION ALL SELECT ID + 1
	FROM T
	WHERE ID < 1000
)
SELECT * FROM T
OPTION (MAXRECURSION 1000)

Sa...

Using WITH statement you can create a series of data and use them in your queries. Sample 1. Integer-Series

WITH T(ID) AS
(
	SELECT 1 ID
	UNION ALL SELECT ID + 1
	FROM T
	WHERE ID < 1000
)
SELECT * FROM T
OPTION (MAXRECURSION 1000)

Sa...

Hello friends, one interviewer asked that suppose you have two tables `Employee_Details`, `Employee_Details_History` now I want to delete original table `Employee_details` and maintain it’s history to other table. How can it’s possible with only ...

Hello friends, one interviewer asked that suppose you have two tables `Employee_Details`, `Employee_Details_History` now I want to delete original table `Employee_details` and maintain it’s history to other table. How can it’s possible with only ...

Data accuracy is the main job of the DBA and provide the accurate data to other. It is good to provide nothing than bad data. There is lot of occurrences where typo occurs and we get the wrong result. To over come this problem SQL server 2012 (Dena...

Data accuracy is the main job of the DBA and provide the accurate data to other. It is good to provide nothing than bad data. There is lot of occurrences where typo occurs and we get the wrong result. To over come this problem SQL server 2012 (Dena...