By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,035 Members | 1,984 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,035 IT Pros & Developers. It's quick & easy.

How to keep ado.AddNew() from causing a select *

P: n/a
Every time I call ado.AddNew() a select * from Table is generated.

This is a large table and the unqualified select * statement causes my add operation to get progressively slower as the table size grows.

How do I keep AddNew from generating the select * statement?

My db is sql server 2005.

My client code is in python, through ado.
Oct 28 '10 #1
Share this Question
Share on Google+
2 Replies


ck9663
Expert 2.5K+
P: 2,878
This is more of a Python question, than a SQL Server question. Try posting this in Python forum.

Good Luck!!!

~~ CK
Oct 28 '10 #2

NeoPa
Expert Mod 15k+
P: 31,560
I'll move this to Python for you, but you may want to consider explaining the situation more clearly. Where is the SELECT * created? In a variable? In a table? In your living room? I expect whoever chooses to try and help will need decent information if they're to be of any use to you.
Oct 28 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.