Ok, I'm trying to write a query in a stored procedure in SQL Server 2000. Because some of the parts of the query vary based on certain situations I construct a string that contains the query and ...

I need to call a stored procedure from python. The stored procedure is performing a database backup; an output value is to be returned to python. conn = pyodbc.connect(self.master_conn_string, ...

cursor.execute () with params returns TypeError: not all arguments converted during string formatting #808 ...

This is a pain when trying to display the amounts on a VB form and having to reformat .00 to 0.00.<BR>I am thinking of just using null and >0 values instead of allowing a zero value. <BR><BR>So ...