sql (18,802)


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 li…


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

Closed. This question is off-topic.It is not currently accepting answers. Want to improve this question? Update the question so it's…


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 ty…


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 INSERT…


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 ar…




server how mysql query table from with database oracle select