Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 109144

SQL Server 2008 R2 (major build version 10.50.xxxx). Please also tag with sql-server.

4
votes
There are three delete methods in sql server: Truncate , Delete , Drop DROP, TRUNCATE are DDL commands (DROP is used to remove objects like tables, columns, constraints,...but not rows) DELETE is a …
answered Apr 12 '17 by Hadi
2
votes
There are many ways you can achieve this using SSIS: Using Lookup Transformation Using Script Task Using Execute Sql Task Also you may find other methods... I have a detailed answer on a similar …
answered Jun 4 '17 by Hadi
1
vote
Try removing then adding the Excel Source component in the DataFlow Task, Also try to set the DataFlow Task Delay Validation property to True If the Error persists, i think that the issue is not with …
answered Dec 19 '17 by Hadi
1
vote
You cannot achieve this if you do not have a historical or archive table that store this data. You have to create an AuditDb and create some DML trigger. OR You have to use a third-party log reader …
answered Apr 4 '17 by Hadi
1
vote
You can alter the table header using a script task: Note: you have to add Microsoft.Office.Interop.Excel.dll file to the following directories (.Net Framework dll directory) C:\Windows\Microsoft.NET …
answered Dec 25 '17 by Hadi