Welcome!

Hide/Show columns

CFgrid is the one of the most coolest ajax feature provided by coldfusion. Here i have used a static Cfgrid to explain how we can hide and show the cfgrid…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
CFQUERY bug on using different datasources within a single query

Recently, I encountered an interesting bug in CFQUERY. Here is an example with detailed explanation. SELECT parkname, region, state FROM Parks ORDER BY parkname, state If we call an UDF named…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Renaming Database Objects

A lot of times we need a change . While working on an existing database,  we may need to change the database name and in some cases want to rename…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
GO (Transact-SQL)

GO is the default batch separator keyword for T-SQL. It signals the end of a batch of Transact-SQL statements to the SQL Server utilities. Actually, GO is not a Transact-SQL…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
How to create a CatalogProperty and add enum values to it in CommerceServer using API

The Catalog schema consists of metadata like definitions for Products, properties and categories stored in the site’s product catalog database. Commerce Server Catalog System provides a set of APIs to…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Common Table Expression in SQL Server

Syntax of CTE:WITH CTE_NAME (Represents the column names for the defined CTE)** AS ( // SELECT statement whose result set populates the common table expression. ) SELECT * FROM CTE_NAME…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
FileTable in SQL 2012

Please make sure to point to right directories as per your SQL server’s installation and data and log file storage policies. We can create a FileTable now with the following…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Usage of Extension Methods in C# 3.5

Introduction: C# 3.0 provides a new feature called Extension Methods.  Extension methods are methods that can be added to previously defined classes without rebuilding/compiling those classes. Process: To define an…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Insert bulk data using XML serialization and XQuery

Suppose I have a grid showing the entries of all employees (ID, Name, Exp etc.) and I have to store the checked row’s ID , Name, Address, Contact to a…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!