sql (18,244)


Check for changes to an SQL Server table?

Check for changes to an SQL Server table?

How can I monitor an SQL Server database for changes to a table without using triggers or modifying the structure of the database in any way? My preferred programming environment is.NET and C#. I'd l…


Paging a collection with LINQ

How do you page through a collection in LINQ given that you have a startIndex and a count?…


How to export data from SQL Server 2005 to MySQL

I've been banging my head against SQL Server 2005 trying to get a lot of data out. I've been given a database with nearly 300 tables in it and I need to turn this into a MySQL database. My first cal…


Versioning SQL Server database

I want to get my databases under version control. Does anyone have any advice or recommended articles to get me started? I'll always want to have at least some data in there(as alumb mentions: user…



Upgrading SQL Server 6.5

Yes, I know. The existence of a running copy of SQL Server 6.5 in 2008 is absurd. That stipulated, what is the best way to migrate from 6.5 to 2005? Is there any direct path? Most of the documenta…


SQL Server 2005 implementation of MySQL REPLACE INTO?

MySQL has this incredibly useful yet properitary REPLACE INTO SQL Command. Can this easily be emulated in SQL Server 2005? Starting a new Transaction, doing a Select() and then either UPDATE or INSER…


sql Is there a version control system for database structure changes?

I often run into the following problem. I work on some changes to a project that require new tables or columns in the database. I make the database modifications and continue my work. Usually, I remem…


Deploying SQL Server Databases from Test to Live

I wonder how you guys manage deployment of a database between 2 SQL Servers, specifically SQL Server 2005. Now, there is a development and a live one. As this should be part of a buildscript(standar…


python cx_Oracle: How do I iterate over a result set?

There are several ways to iterate over a result set. What are the tradeoff of each?…


sql Swap unique indexed column values in database

I have a database table and one of the fields(not the primary key) is having a unique index on it. Now I want to swap values under this column for two rows. How could this be done? Two hacks I know…




server how mysql query table from with database oracle select