Welcome!

SQL Server : Multiple record insert

USE GO INSERT INTO Table_Name (Column1, Column2, Column3) VALUES (Valu11, Value21, value31) INSERT INTO Table_Name (Column1, Column2, Column3) VALUES (Valu12, Value22, value32) INSERT INTO Table_Name (Column1, Column2, Column3) VALUES (Valu13,…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Self join and its usage

Problem: We have three table ‘questions’, ‘answers’ and ‘questions’. ‘Questions’ table is not used, have placed it as an reference. About relationships, Attendee table has one-many relationship with answers table,…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
PHP Class for unzipping ZIP file on Linux/Windows

In php unzipping a zip file is always different for  separate OS. Though most php sites are running on Linux there are a few on Windows too. Here I have written a class to…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
User friendly DATETIME Functions in SQL Server 2008

The DATETIME function’s major change in SQL Server 2008 is the four DATETIME data types that are newly introduced. They are : DATE, TIME, DATETIMEOFFSET and DATETIME2. In addition to…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Avoid Causing havoc with Live Site/DB

Most of the biggest blunders are caused by small – silly mistakes –ALWAYS be alert when you use the Live build.·         Check the back-up policy of your Live application DB…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
ColdFusion Beginner Tip. When to use and not to use # in your cfcode.

I have seen many beginners confused over the use of # sign in ColdFusion and most are so confused that they use it anywhere they can! I have been asked…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Integrate facebook in your site

Here are some steps through which we can integrate facebook in our site using php with zend framework. Here I am going to discuss on how to integrate facebook in…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Bug in script version of cfquery

We generally use ColdFusion tags in our coding. But sometimes we prefer to use script version of that, instead the tag. Also in ColdFusion 9.0.1 have a script version code…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Make Your “Order By” Clause Dynamic

SQL Server returns data in a random order. A simple SELECT returns data in the order they were entered.. Although we can have our results returned in the order in which…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!