• Random

    Posted on May 10th, 2007

    Written by Emad Ibrahim

    Tags

    ,

    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 [...]

  • Programming

    Posted on April 10th, 2007

    Written by Emad Ibrahim

    Tags

    , ,

    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 [...]

  • Newer Posts Yeah! There are more posts, check them out.