The 'Insert Into' task can be used to insert values in existing tables.
The insert method for the value can be one of three types:
- Variable. With the 'Variable' option, you can insert values from any predefined variables.
- Fixed value. With the 'Fixed value' option, you can type in a fixed value to be inserted.
- Expression. With the 'Expression' option, you can use expressions/functions to insert a value.
Example: Inserting three different value types in a table
DECLARE @Count as int
SET @Count=1
CREATE TABLE [NewTable] (CountField int, DateField datetime, FixedValueField int)
INSERT INTO [NewTable] (CountField, DateField, FixedValueField) VALUES (@Count,GETDATE(),10)
SAVE
Comments
Please sign in to leave a comment.