I have an XLS file. Let’s assume that it has 1000 rows in all, with 10 columns. I would like to import rows 5 through 995 (say), and columns 1 though 7 and 10. How can I do this using an SQL query, either though OPENROWSET or BULK INSERT? I am using SQL Server 2008.

• 0 Comments

Hi all, I am trying to select multiple rows from the database and then separate the rows into array values so I can use them throughout my code. This is what I have right now… $result = mysql_query("SELECT url, image, placement FROM advert  WHERE user=’1′") or die(mysql_error()); //This grabs 3 rows with placement name equal [...]

• 0 Comments

Hey all; I’m working on a forum/blog engine, and I basically want some opinions on whether or not I should separate the forum and blog as two separate entities or combine them into some hybrid type of table. At the moment, I’m working on the ER diagram, and they’re separate, but I’m wondering if thats [...]

• 0 Comments

Do anybody know where can i find example of database management system all topic especially fast food restaurant(if possible).

• 0 Comments