insert into a (b) values (1), (2), (3)

The above statement will result in the error mentioned below in case u use any other version of SQL other than SQL 2008

Incorrect...

Hi,

Here are some SSIS related Interview Questions with answers. hope they help.

1) What is the control flow

2) what is a data flow

3) how do you do error handling in SSIS

4)...

I agree.

Only the second option will give the desired result.

Below is the set of results we'll get after executing all the 3 options:

create table #temp1

(

EmpName nvarchar(200),

DateOfLeaving Datetime

)

insert into #temp1 values('Abc',...

I think

sp_configure 'clr enabled', 1 actually enables clr

while sp_configure 'clr enabled', 1 GO RECONFIGURE GO, in theory enables and installs the feature.

Running sp_configure 'clr enabled', 1...