Welcome!

How to return Modified data in SQL Server

In SQL Server, there is a cool functionality by which you can get the modified data as a result set. Suppose there is a table containing rating information about any…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Split Delimited String Using XQuery

Most of us have encountered situations like splitting delimited string in a column of a table in SQL SERVER. The very first idea we get is to build a TABLE VALUED…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
SQL Server Index – V (Index Fragmentation)

Rebuilding an Index Rebuilding an index means dropping an existing index and creating a new one. Any fragmentation that was in the older index ie deleted with the drop and…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
SET and SELECT in SQL Server

3. Third difference can be found when the query returns more than one value. In this case , SET would return an error. For instance,the following code: Declare  @Year_of_PassOut int SET @Year_of_PassOut= (SELECT…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
How to read data from text file and search for a word in the file in iPhone

// get text file path from application bundle. _string_filePath =  pathForResource:@”fileName” ofType:@”txt”];  // get the contents of file. _string_myFileText = ;  // pass the range of text within which the search has to…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Dynamic Where Clause

Some times we may encounter situations like getting the data from data base with numerous parameters which become optional based on the conditions. For example , Case 1. Get All…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Access an Web Service from a SSL enabled Website

If you want to access an web service from a website which is SSL enabled (used HTTPS), you have to download SSL certificate from the SSL enabled website and install…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Using Yield Keyword in C#

 Yield is a keyword which is used to get list of  items from a loop. The method implementing yield keyword returns an enumerable object.Yield retains the state of the method…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!
Avoiding the use of Triggers in SQL Server

Sometimes we need to audit all DML operations for tables in a MSSQL database. There are many methods for achieving this, one of the most common approaches is using  DML Triggers…

150 150 Burnignorance | Where Minds Meet And Sparks Fly!