Generate sql insert script from excel worksheet?

I have a large excel worksheet that I want to add to my database. Can I generate an SQL insert script from this exc...

SQL Server loop - how do I loop through a set of records?

how do I loop through a set of records from a select? So say for example I have a few records that I wish to loop t...

Is this the proper way to do boolean test in SQL??

Assume active is a "boolean field" (tiny int, with 0 or 1) # Find all active users select * from users where active...

CountIf formula within MS Access report?

Something terrible as happened with my poor attempt at adding a CountIf forumula to my access report. I am trying t...

How to change the column position of MySQL table without losing column data??

I want to change the column positions of my database table without losing data. For example: Current table: +----...

SQL sum with condition?

I currently have a large SQL statement which i add the following line to in order to get the total cash for each tra...

Linq version of SQL “IN” statement?

I have the following 3 tables as part of a simple "item tagging" schema: ==Items== ItemId int Brand varchar ...

How do I comment SQL code out in Microsoft Access??

Is it possible to comment code out in the SQL window in Microsoft Access? ...

What is the difference between a stored procedure and a view??

I am confused about a few points: What is the difference between a stored procedure and a view? When should I use ...

Merge Multiple Databases into a Single Database?

All, I have to create a single database which has a basic schema. This database is going to be large (100GB plus), a...

how to join two views in single View in sql??

I have two Views I want to merge into single view for example View 1 is defined as: CREATE VIEW view1 AS select D...

How can I create database tables from XSD files??

I have a set of XSDs from which I generate data access classes, stored procedures and more. What I don't have is a ...

AJAX update MYSQL database using function called from HTML generated from PHP?

I have a php page generating and displaying a table. for the last row in the table i want to display an image with a...

Disable all table constraints in Oracle?

How can I disable all table constrains in Oracle with a single command? This can be either for a single table, a lis...

Doing a WHERE .. IN subquery in Doctrine 2?

I'd like to select order items from all orders with a specific item. In SQL I'd do it like this: SELECT DISTINCT i....