Welcome!

TRY_PARSE In SQL Server 2012

The output will be an Error with zero rows and the query fails! Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value ‘L00’ to…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Some Useful SQL Queries

Some Useful SQL Queries Here are some SQL queries that I like to use. TO COUNT NUMBER OF TABLES IN A DB SELECT = COUNT(OBJ.ID) FROM SYSOBJECTS OBJ WHERE XTYPE=’U’…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Customizing FCK Editor in ColdFusion

The content is all about customizing FCKEditor that is well integrated with ColdFusion. The content is all about customizing FCKEditor that is well integrated with ColdFusion. We have an editor…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Calculating Cart total with discount applied at runtime in MS Commerce Server

This tip demonstrates how to format a cart at runtime and calculate the total (including discount amount) in MS Commerce Server. The steps are: Step 1: Create a new basket.…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Difference between @@IDENTITY, SCOPE_IDENTITY() and IDENT_CURRENT() in SQL SERVER

This tip elucidates the difference between @@IDENTITY, SCOPE_IDENTITY() and IDENT_CURRENT() in SQL SERVER When we set IDENTITY for a column, the column is known as AUTO INCREMENT column whose value is…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Using Global DB Config file in PHP

At times we do face problems modifying names of a table or a column after the application has been scaled. This is more problematic when working with large applications as…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Including Checkbox in SQL Server Reporting

Description: Suppose we have a form that should appear automatically filled out based on information pulled from a database. We have several datatype fields. Printing out “True” or “False” ,…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Random Unique Code Generator

Challenge: I was given a scenario in which i need to represent a large number by few character it must be hard to break the code. For ex: A 8…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Using NULL-COALESCE Operator in C#

To my knowledge perhaps the least used operator in C# is the null-coalescing operator . But you can use it effectively to reduce the lines of code you write .…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!