|
|
-
Alpesh Patel Learned 7 Months ago through Just Learned
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 ...
|
-
Alpesh Patel Liked 7 Months ago through Just Learned
Using WITH statement you can create a series of data and use them in your queries.
Sample 1. Integer-Series
<pre>
WITH T(ID) AS
(
SELECT 1 ID
UNION ALL SELECT ID + 1
FROM T
WHERE ID < 1000
)
SELECT * FROM T
OPTION (MAXRECURSION 1000)
</pre>
Sa...
|
-
Alpesh Patel Learned 7 Months ago through Just Learned
Using WITH statement you can create a series of data and use them in your queries.
Sample 1. Integer-Series
<pre>
WITH T(ID) AS
(
SELECT 1 ID
UNION ALL SELECT ID + 1
FROM T
WHERE ID < 1000
)
SELECT * FROM T
OPTION (MAXRECURSION 1000)
</pre>
Sa...
|
-
Alpesh Patel Liked 8 Months ago through Just Learned
Master data service is a entry point to make Master data up to date. To do that SQL server has provided the Add in for Ms Excel to update data and publish back to the Master Repository using Master Data Service.
To compare the data using the Data Qu...
|
-
Alpesh Patel Learned 8 Months ago through Just Learned
Master data service is a entry point to make Master data up to date. To do that SQL server has provided the Add in for Ms Excel to update data and publish back to the Master Repository using Master Data Service.
To compare the data using the Data Qu...
|
-
Alpesh Patel Liked 8 Months ago through Just Learned
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...
|
-
Alpesh Patel Learned 8 Months ago through Just Learned
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...
|
-
Alpesh Patel Posted 8 Months ago through Just Learned
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 (Denali)...
|
-
Alpesh Patel Posted 8 Months ago through Just Learned
Master data service is a entry point to make Master data up to date. To do that SQL server has provided the Add in for Ms Excel to update data and publish back to the Master Repository using Master Data Service.
To compare the data using the Data Quali...
|
-
Alpesh Patel Liked 8 Months ago through Just Learned
SQL Server 2012 Reporting Service provides new feature of Data Alerts by email.
For example :- Sending an email to Director of sales when any invoice having more than $250K amount....
|