|
|
-
|
|
It is not possible to create the VIEW in another database directly - unlike CREATE TABLE, CREATE VIEW statement doesn't have a "database_name" - part in its syntax. But you can do it by calling sp\_executesql stored procedure:
DECLARE @s nvarchar(1000...
|
|
-
|
|
If you want to create a row based checksum, you can use build-in functions CHECKSUM or BINARY\_CHECKSUM. Unfortunately, these functions are not precise enough - the chance to get the wrongly equal values is relatively high.
There is another function - H...
|
|
-
|
|
Hello friends today i check foreign key constraint can't support in bulk insert task.please take corrective action when you upload data.
Create table Tbl1
(
id int primary key,
varname varchar(50),
fk_ID int
)
Alter table T...
|
|
-
|
|
Copy And paste Query
Create table #temp1
(
id int ,
Name varchar(50),
City varchar(50)
)
Create table #Staging_temp2
(
id int,
Name varchar(50),
City varchar(50)
)
insert into #temp1
se...
|
|
-
14
Liked
| 10
Learned
| 3
Comments
|
|
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 sin...
|
|
-
|
|
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
Sample 2: Time-Series
WITH T(Date) AS
(
SELECT CONVERT(datetime, ...
|
|
-
|
|
In the earlier versions of SSIS the parameterization of OLE DB Command Task was restricted to the stored procedure parameters and the values of INSERT command.
Now it is possible to use parameters much more widely. For example, you can use the following...
|
|
-
|
|
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...
|
|
-
|
|
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)...
|
|
-
|
|
We all use expressions while working with SSIS and most of us know that SSIS is Case Sensitive in many aspects like for instance, Lookup Operation is Case Sensitive. But do we all know if the text inside the expressions is Case Sensitive?
*@[User::varS...
|
|