same (5,800)


Deploying SQL Server Databases from Test to Live

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…


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…



sql server - Editing database records by multiple users

I have designed database tables(normalised, on an MS SQL server) and created a standalone windows front end for an application that will be used by a handful of users to add and edit information. We…


web applications - How to make subdomain user accounts in a webapp

I am looking to allow users to control of subdomain of an app I am toying with, much like Basecamp where it is customusername.seework.com. What is required on the DNS end to allow these to be created…


actionscript 3 - Using multiple SQLite databases at once

I have 2 SQLite databases, one downloaded from a server(server.db), and one used as storage on the client(client.db). I need to perform various sync queries on the client database, using data from…


Multiple Updates in MySQL

I know that you can insert multiple rows at once, is there a way to update multiple rows at once(as in, in one query) in MySQL? Edit: For example I have the following Name id Col1 Col2 Row1 1 6 1 Row2…


sql - How should I organize my master ddl script

I am currently creating a master ddl for our database. Historically we have used backup/restore to version our database, and not maintained any ddl scripts. The schema is quite large. My current th…


Multiple foreign keys?

I've got a table that is supposed to track days and costs for shipping product from one vendor to another. We(brilliantly:p) stored both the shipping vendors(FedEx, UPS) with the product handling…


Oracle XE or SQL Server Express

I'm starting a new project here(Windows Forms). What's the best option today for a small(free as in beer) DBMS? I've used SQL Server Express on the past projects, but time and time again I hear peo…


c++ - Removing icon from Windows title bars without ditching close button or system menu?

I'm developing an MFC application and I've recently been searching for a good method to remove the icon from a Windows title bar, but retain the close button. The two obvious candidate solutions are…




multiple how with the and two from one example different