Monthly Archives: April 2017

SQL Server : Value Constructor Insight.

Posted on April 13, 2017 by Deepak Mahto

We all must be aware of VALUE Clause for Inserting values specified, in current blob we will explore different ways other then Insert were we can have use VALUE as handy.! 1. Generating Dummy Data! we can use Value to … Continue reading →

Rate this:

Posted in SQL Server Learning | Tagged , , | 1 Comment

SQL Server : ExecuteNonQuery shows incorrect rows affected.

Posted on April 6, 2017 by Deepak Mahto

For one of client as per functionality we were invoking a SQL Server procedure using ExecuteNonQuery method. Within procedure we had a DML statement performing update and on rows affected as return from ExecuteNonQuery performing further functional stuff. In one … Continue reading →

Rate this:

Posted in SQL Server Learning | Tagged , , , | Leave a comment

SQL Server : Get Numeric part from a varchar/string.

Posted on April 6, 2017 by Deepak Mahto

Found question to fetch only numeric information from a string/varchar in some of blogs, so thought let try and share my attempt. Implement logic: 1. Using Recursive With clause, segregated each and every character as separate row. 2. Using Regex … Continue reading →

Rate this:

Posted in Helper SQL, SQL Server Learning | Tagged , , | Leave a comment

Date Generator in SQL Server using Recursive With Clause.

Posted on April 5, 2017 by Deepak Mahto

During one of performance analysis, identified lofty insert statements populating static tables with Date information. As part of one of functionality, we were generating dates and applying necessary function on it within date range specified. As part of performance improvement, … Continue reading →

Rate this:

Posted in Helper SQL, SQL Server Learning | Tagged , , , | Leave a comment