Emad Ibrahim

SQL Script to generate data inserts for existing tables

Here is a great sql script that will look at your table and generate a script to insert all the data. This is very useful when moving databases or when you want to create a database setup in your application with some default data. Note that I haven’t tried this procedure and it was sent [...]

Flip a SQL table around

I have a sql table that looks like this Id Name Value 1 First name Bob 1 Last name Johns 2 First name John 2 Last name Smith 3 First name Bill 3 Last name Gates I want to return the data like this: Id First name Last name 1 Bob Johns 2 John Smith [...]