sql Archives - Page 29 of 45

I have a database called foo and a database called bar. I have a table in foo called tblFoobar that I want to ...

I’m looking for a good way to perform multi-row inserts into an Oracle 9 database. The following works in MySQL but doesn’t seem ...

I want to insert data into my table, but insert only data that doesn’t already exist in my database. Here is my code: ...

I would like to force the auto increment field of a table to some value, I tried with this: ALTER TABLE product AUTO_INCREMENT ...

When using SQL, are there any benefits of using = in a WHERE clause instead of LIKE? Without any special operators, LIKE and ...

Could someone please explain the following behavior in SQL? SELECT * FROM MyTable WHERE MyColumn != NULL (0 Results) SELECT * FROM MyTable ...

How can I accomplish this using Postgres? I’ve tried the code below but it doesn’t work: ALTER TABLE mytable ALTER COLUMN mycolumn BIGINT ...

How to change the column size of the salary column in the employee table from numeric(18,0) to numeric(22,5) 10 Answers 10

I’ve got a SQL Server table with about 50,000 rows in it. I want to select about 5,000 of those rows at random. ...