-
Hi,
I need to insert a large number of rows to a temporary table prior to running a query that will use them (making joins with other data on the database). Any advise on how to accomplish this maintaining reasonable performance?
I know sqlserver has the concept of a bulk insert, although i'm still not sure which are its limitations, and if it would be useful here. In either case, is this...
2009-11-10 20:24:38 UTC by filipecorreia
-
OOps.
I have been in!
With version in cvs problem doesn't appear.
When will next release appear? 1.0.3 :)
BTW, in freebsd ports still version 1.0.1.
Thank you for good lib!
2009-10-26 12:45:29 UTC by igorpotapenko
-
Hello!
I have a problem with recieving serveral sets by one query.
I am using python 2.5 and pymssql 1.0.2.(from http://sourceforge.net/projects/pymssql/files/) on freebsd with freetds (and on windows - same problem).
SQL server 9.0.3042
After execute following code:
[code]
self.con = _mssql.connect(192.168.1.1:1433', 'USER', '12345',)
sql = '''select 1,2,3.
2009-10-26 12:41:29 UTC by igorpotapenko
-
Is there a way to get the results of "set statistics time on" via pymssql? I tried using cursor.nextset() after retrieving the SELECT results, but there is no other data set. If there is no way, it would be a nice feature to have.
2009-10-06 23:19:09 UTC by kmartine
-
It worked for me. Had to ensure create table permissions were granted for the user in the database. Try running your SQL from Query Analyzer or sqlcmd to verify it is correct. Also, use semicolons, not "go" as command delimiters.
2009-10-05 18:30:21 UTC by kmartine
-
Nevermind, it seems the parameters were actually different. Doh!
2009-10-05 14:46:04 UTC by grebekel
-
I'm running a query that should return at least 20000 rows. The query returns the whole of them when I run the query on a small test script, but returns nothing when I run it in my full app. The connection parameters are the same on both scripts and the query is a simple select:
select cola, colb, colc, cold from sometable where create_date >= '2009-01-01'
On my full app I'm executing...
2009-10-05 14:40:31 UTC by grebekel
-
Hi everyone,
i am trying to create a table with a query, but, after it ran, nothing happens: the table is not created and no error message is thrown.
The same query done with SQL Server Management Studio instead have successful ending (ie the table is created)
The problem occours with both pymssql and _mssql.
What could be the problem?
I'm running Python 2.5 under Windows Vista Business...
2009-09-30 10:54:56 UTC by maloe
-
I got exactly the same problem. I can guees why : _mssql has an extention **.pyd**
I have no idea what that is, but when Python is trying to import modules, it's looking for **.py** files with source code in them.
I've sent an email to the person who maintains this project.
2009-09-23 00:32:18 UTC by vzingertal
-
akukula added damoxc to the Simple MS SQL Python extension module project.
2009-09-17 09:41:50 UTC by akukula
