I am new kid on the block, and by accident I have deleted all records from a table. Is there anyway to recover them back.I am using SQL server 2008
Any help will be greatly appreciated
Here's the OLE DB Apporach:
Create some parameters for your package. If you make them Required then they are, well, required and your package won't run without some values. The field in the Value column will be the default and used for debugging.
Then create a variable and add an expression:
...
Is there any way in SSIS by which I can transform only 1000 rows on every run.For E.g.from 0 to 1000 for first time run.Second time 1001 to 2000 and likewise till end of data in source.
0
First, there are plenty of questions on SO and across the web asking how to create dynamic column headings for PIVOT statements when the column headings aren't static. All answers point to the same answer-- build the list of columns into a string and then execute your SELECT\PIVOT statement from...
I've done this:
IF OBJECT_ID ('dbo.after_update','TR') IS NOT NULL
DROP TRIGGER dbo.after_update;
GO
CREATE TRIGGER [dbo].[after_update]
ON [dbo].[tb1]
AFTER UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
...
