Hi,

In sql 2000

Try this in your sp

insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;DatabaseC:\TEST.XLS',

'SELECT * FROM [Sheet1$]')

Select COL1,

COL2

from Table (Nolock)

whereCONDITIONS

Ensure that in that drive(C:\) the excel file available with name TEST and all...

Hi,

Show you’re schema of the mytable

And

Which statement you’re using?

A)select * into temp from mytable

or

B)insert into temp

select * from mytable

ARUN SAS

🙂

Thanks a lot Gail Shaw

Now the issue rectified by your guide

ARUN SAS

😀

Hi,

Thanks,

After run your statement

I got

typexusertypeprecscale

108987288

(1 row(s) affected)

xtypexusertypeprecscale

(0 row(s) affected)

Then got the id from syscolumns, and located the table thro syscommends

Table structure also attached

and i find out the col having the...

Hi,

SQL 2000 server Only,No upgread to 2005

ARUN SAS

🙂

Hi,

try this

create table #ABC (C1 char(2),C2 char(2))

insert into #ABC values('1','a')

insert into #ABC values('1','b')

insert into #ABC values('1','b')

insert into #ABC values('a','1a')

insert into #ABC values('a','1b')

insert into #ABC values('b','2a')

insert into #ABC values('2','x')

insert into #ABC...

Hi,

Ok Paul,

How to locate the problem data type?

How to resolve this issue?

ARUN SAS

🙂

Hi,

Direct affect ONE

and by trigger n nos of tables

ARUN SAS

Hi,

Check the length of the DESCRIPTION column

In SQL ,char or varchar max length is 8000

Beyond that, its raise error

ARUN SAS

HI,

Possible, when you create the table and store all the synonyms for the words

ARUN SAS

HI,

try this then exec the sp with null

CREATE proc Example

(

@empid int,

@Mode varchar (1),

@fname varchar (100)= null,

@lname varchar(100)=null

)

As

begin

-- CREATE TABLE [emp] (

-- [empid] [int] IDENTITY (1, 1) NOT NULL ,

-- [Fname]...

Hi,

Because the table column having IDENTITY (1, 1)

You should not pass the value to this column, so that its wound raises the error

ARUN SAS

🙂

Hi,

In your table shows all col are not null,

Then in the sp line

If (@Mode='I'

Begin

Insert into emp(fname,lname) values(@fname,@lname)

End

returns with error

AND what error you need to return,

Because it’s automatically return by not...

Hi,

See the sysjobhistory table in the msdb,

In run_duration col shows the time taken of the job or steps

ARUN SAS

Hi,

Show you emp table structure

Because during insert, your not call emp colums

ARUN SAS