column (11,900)


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

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…



Python and MySQL

I can get Python to work with Postgresql but I cannot get it to work with MySQL. The main problem is that on the shared hosting account I have I do not have the ability to install things such as Djan…


sql What is the best way to handle multiple permission types?

I often encounter the following scenario where I need to offer many different types of permissions. I primarily use ASP.NET/VB.NET with SQL Server 2000. Scenario I want to offer a dynamic permissio…


sql server What is the best way to copy a database?

I always create a new empty database, after that backup and restore of the existing database into it, but is this really the best way? As it seems very error prone and over complicated for me.…


sql server Can I logically reorder columns in a table?

If I'm adding a column to a table in Microsoft SQL Server, can I control where the column is displayed logically in queries? I don't want to mess with the physical layout of columns on disk, but I wou…


c# CSV File Imports in.Net

I realize this is a newbie question, but I'm looking for a simple solution-it seems like there should be one. What's the best way to import a CSV file into a strongly-typed data structure? Again si…


Have you ever encountered a query that SQL Server could not execute because it referenced too many tables?

Have you ever seen any of there error messages?-- SQL Server 2000 Could not allocate ancillary table for view or function resolution. The maximum number of tables in a query(256) was exceeded.-…


What's the best way to determine if a temporary table exists in SQL Server?

When writing a T-SQL script that I plan on re-running, often times I use temporary tables to store temporary data. Since the temp table is created on the fly, I'd like to be able to drop that table…


How do I use T-SQL Group By

I know I need to have(although I don't know why) a GROUP BY clause on the end of a SQL query that uses any aggregate functions like count, sum, avg, etc: SELECT count(userID), userName FROM users GR…




columns how table sql value multiple with from data row