I followed this website by installing After install I try this code and it worked, it print all records from table2 However, I want to use SQLAlchemy with pyodbc and it does not work ProgrammingError: (pyodbc.ProgrammingError) (‘42000′, “[42000] [FreeTDS][SQL Server]’schema_name’…
Tag: sql-server-2000
How to get TOP larger tables in SQL Server 2000 and their sizes
Is there a way via T-SQL to get the larger tables and their respective size in a SQL Server 2000 engine? Answer I think this script works with SQL Server 2000 even if sp_msforeachtable was not documented
How to convert a varchar column to bit column in SQL SERVER
Flag1 is a varchar column with values “true” and “false”. I need to convert this into bit column. When I try to do this: Convert(Bit,Flag1) it shows an error Msg 245, Level 16, State 1, Line 2 …
Is there a way to list open transactions on SQL Server 2000 database?
Does anyone know of any way to list open transactions on SQL Server 2000 database? I am aware that I can query the view sys.dm_tran_session_transactions on SQL 2005 (and later) database versions, however this is not available on SQL 2000. Answer For all databases query sys.sysprocesses For the current databas…
How to Join to first row
I’ll use a concrete, but hypothetical, example. Each Order normally has only one line item: Orders: OrderGUID OrderNumber ========= ============ {FFB2…} STL-7442-1 {3EC6…} MPT-…
WHERE IS NULL, IS NOT NULL or NO WHERE clause depending on SQL Server parameter value
I have a stored procedure in SQL Server 2000 that performs a search based on parameter values. For one of the parameters passed in, I need a different WHERE clause depending on its value – the problem …
How to use a single SqlTransaction for multiple SqlConnections in .NET?
I have SQL Server 2000, it doesn’t support MultipleActiveResults. I have to do multiple inserts, and it’s done with one connection per insertion. I want to begin a transaction before all insertions and finish it after all insertions. How do I do it? Answer What is the reason you don’t use on…