If Browsers were Celebrities
I take no credit in this – I just find it funny and true.
If Web Browsers Were Celebrities is brought to you by Wix.com
Use creative design to make a Flash website.
You are most welcome to share this infographic with your audience.
Rename objects in SQL Server
Recently I had to rename some columns and a couple of tables in a database that I work on. Clearly I could go through SQL Server Management Studio and rename them, but I wanted something I could save to a script and run. Ladies and gentlemen, boys and girls, let me introduce a little stored procedure called sp_rename.
Rename database columns
To rename a column in a database table, simply execute the following code:
sp_RENAME 'TABLENAME.COLUMNNAME', 'NEWCOLUMNNAME', 'COLUMN' GO
While the first and second parameter are to be replaced with your specific objects, the third parameter is the string literal “COLUMN”.
Rename database tables
To rename a table, simply execute the following code:
sp_RENAME 'TABLENAME', 'NEWTABLENAME' GO
Notice the lack of a third parameter.
Silent Auction
Last night I attended a silent auction run by my in-law’s church. My father in-law is in charge of the event and basically puts it all together. A few years ago, he asked me to create some sort of application to help him manage the whole thing. It started as a desktop application, and last year was revamped into a web app. Installed on his laptop, he was able to streamline it into a much more organized process than before (using excel documents). Anyway, back to last night – I have thought of new features to put in the next version. The current version utilizes asp.net webforms and telerik ajax controls; the next one will be pure mvc and open source javascript libraries (jquery – no third party tools). I also want to consider opening the app up to be commercially sold to other groups needing to run an auction.
