|
|
-
Guru Samy Liked 8 Months ago through Just Learned | 1 Point
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...
|
-
Guru Samy Liked 8 Months ago through Just Learned | 1 Point
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::v...
|
-
Guru Samy Liked 8 Months ago through Just Learned | 1 Point
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
...
|
-
Guru Samy Liked 8 Months ago through Just Learned | 1 Point
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 ...
|
-
Guru Samy Liked 8 Months ago through Just Learned | 1 Point
Yes, You can overload methods in a webservice using Message Attribute...
|
-
Guru Samy Learned 8 Months ago through Just Learned | 1 Point
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
...
|
-
Guru Samy Learned 8 Months ago through Just Learned | 1 Point
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 ...
|
-
Guru Samy Learned 8 Months ago through Just Learned | 1 Point
Yes, You can overload methods in a webservice using Message Attribute...
|
-
Guru Samy Learned 8 Months ago through Just Learned | 1 Point
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 ...
|
-
Guru Samy Learned 8 Months ago through Just Learned | 1 Point
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 tabl...
|