Koen Verbeeck (8/20/2015)

---

Sean Lange (8/19/2015)

---

Ha Ha!!! I was just beating my head against the wall when inserting varchar data into an nvarchar column and struggling with why it was not...

David Burrows (8/19/2015)

---

Sean Lange (8/19/2015)

---

Thanks. Shouldn't be too bad. This is a super simple process. No need for the "T" portion. Just need to truncate a staging table and pull...

Brian Seib (8/19/2015)

---

Good afternoon - I am looking for a quick idea of a way to build a small GUI that a user can input the parameter, then click a...

Luis Cazares (8/19/2015)

---

Sean Lange (8/19/2015)

---

I am working on putting together my first SSIS package. I haven't done this type of thing since it was still DTS packages. This stuff is...

I am working on putting together my first SSIS package. I haven't done this type of thing since it was still DTS packages. This stuff is a LOT different. It...

owens.rusty (8/14/2015)

---

I have a table where we have created a column that has which contains a column which is a primary key tying back to another table. The problem...

Spanish Inquisition

Thanks for the correction Luis. 😉

ugbwuebfub (8/14/2015)

---

Hello,

I have the Database:

(NumbersAndLetter is VARCHAR, utf8_general_ci)

I try to change the database entry with PHP through the...

cstg85 (8/14/2015)

---

Is it possible to allow a user to insert and update data in a table but prevent them from performing deletes against that same table? For auditing purposes I...

Jonathan Marshall (8/14/2015)

---

Hello everyone,

I'm looking to dynamically remove records from tables dynamically using the information schema within SQL Server.

Looking to remove records from all the tables within a...

SQLRNNR (8/13/2015)

---

Or a user-defined table type?

Better yet...

A user defined memory optimized table type?

What about...

Something like this should work. Please notice how I posted ddl and sample data in a consumable format so this is easy to work with. You should do this on...

Luis Cazares (8/13/2015)

---

I don't have an Oracle database to test against it, but it seems that you can insert and delete rows from Dual if you have Admin rights.

The fun...

Luis Cazares (8/13/2015)

---

Sean Lange (8/13/2015)

---

Luis Cazares (8/13/2015)

---

For Oracle, the first query should be something like this:

select *

from quer a

cross join (select 'Text1' as MyText FROM Dual union all select 'Text2'...