Hi its an interview question in IBM.But the guy told that with 3 dml staetments we can do this.

But when we diable using alter its as DDL .Please try to...

I got to wrong by misunderstanding the answer.

I got 10 rows.I am using sqlserver 2008.

I think the author answer is correct.It s depends

Good Question.good discussions

Great Question.Keep continue Posting.

Non Sense question.I thought correct answer. means it will through error.but due to hint given by him i did not consider date and got wrong. am not happy with question...

With remove the | bar i already done.But the source file they told that do not edit the source file.means that i did not delete | in source.Is it possible...

With out Sys admin permission it will work for remote user.but u have permission for select a table.

Hi,

As of my understading am pasting the scripts.Tell me if it provide solution for you.

USE [SSISDB]

GO

/****** Object: Table [dbo].[Emp] Script Date: 10/19/2010 14:45:36 ******/

SET ANSI_NULLS ON

GO

SET...

Hi,

you need to execute two system procedures as defined below.

follow instructions as given below.

USE master

GO

-- To use named parameters:

EXEC sp_addlinkedserver

@server = 'SF-PC035',

@srvproduct = '',

@provider = 'SQLNCLI',

@provstr = 'DRIVER={SQL...

Good question.keep on posting this type of questions.

Absolutly am not satisfy with the question and Explanation.

Lost two points because of misunderstanding of set arthiabort on.I already worked divide by zero errors and handle these type of errors.but little bit confused.with arthabort you can handle this...

Hi,

Here is the table format.

create table #temp(company varchar(50),name varchar(50),email varchar(50),Id int)

insert into #temp

select 'TCS', 'Suneetha','suneetha@tcs.com', 1

union all

select 'TCS', 'Suneetha', 'sunitha@tcs.com', 2

union all

select 'TCS', 'soumya', 'soumya@tcs.com',3

union all

select 'TCS', 'soumya' ,'soumya.raja@tcs.com',4

union all

select...

but the same will not return any rows when we use

select * from #temp where code ='0'

this will return nothing.When we use 0 in quotes it will not return...