optimize insert statement

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » T-SQL » optimize insert statement

optimize insert statement

Rate Topic

Display Mode

Topic Options

Author

Message

Carla Cabingan

Posted Tuesday, September 15, 2009 9:04 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, April 25, 2010 10:41 PM
Points: 4, Visits: 12

hi guys!

i want to hear some ideas from you. i'm performing an insert statement in this fashion:

insert into worktable
select A.column1

from table1 A
inner join table 2 B
on A.key = B.key
inner join table 2 C
on A.key = C.key
where A.key = 'something'

Post #788683

Garadin

Posted Tuesday, September 15, 2009 10:56 PM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, November 07, 2012 4:08 PM
Points: 1,525, Visits: 4,047

That's not enough information for us to go off of. Are there any triggers on the table? Locking Contention possibly? We need a bit more information about your environment.

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. Wink

Links: How to Post Sample Data :: Running Totals :: Tally Table :: Cross Tabs/Pivots :: String Concatenation

Post #788697

Greg Snidow

Posted Wednesday, September 16, 2009 8:09 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 9:29 AM
Points: 1,561, Visits: 2,315

Carla, the first thing I see is that unless your table only has one column, if you don't supply the column name into which you would like to insert the values, you will get an error like this

Server: Msg 213, Level 16, State 4, Line 1
Insert Error: Column name or number of supplied values does not match table definition.

Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.

Post #788968

« Prev Topic | Next Topic »

Permissions