Monthly Archive:: April 2012

Convert string to titlecase using javascript

Introduction: In my previous article I have explained about  how to How to set deadlock priority in sql server. In  this article I will explain about converting string to title case using javascript. Explanation: To convert the string to javascript below Javascript  function is used. function toTitleCase(str) {     return str.replace(/wS*/g, function (txt) { returntxt.charAt(0).toUpperCase()

How to set deadlock priority in sql server

Introduction: In my previous article I have explained about Insert values into identity column in sql server. In this article I am going to explain about how to set the DEADLOCK_PRIORITY  in sql server. Explanation: DEADLOCK_PRIORITY Specifies the relative importance that the current session continue processing if it is deadlocked with another session. Syntax:         SET

Insert values into identity column in sql server

Introduction: In my previous article I have explained about Use of SET NOCOUNT in sql server. In this article I am going to explain about how to insert values into identity column or the use of  SET IDENTITY_INSERT in sql server. Explanation: SET IDENTITY_INSERT Allows explicit values to be inserted into the identity column of

Use of SET NOCOUNT in sql server

Introduction: In my previous article I have explained about  how to Restrict the number of rows affected in SQL Server. In  this article I will explain about the use of in SET NOCOUNT sql server. Explanation: When SET NOCOUNT is ON, the count is not returned. When SET NOCOUNT is OFF, the count is returned.

Restrict the number of rows affected in SQL Server

Introduction: In my previous article I have explained about  how to Get number of affected rows in sql. In  this article I will explain about how to restrict the number of rows affected in  sql server. Explanation: To restrict the number of rows affected by sql server  SET ROWCOUNT is used. It Causes SQL Server

Get number of affected rows in sql

Introduction: In my previous article I have explained about  how toDifferent isolation levels in sql server. In  this article I will explain about different how to get the number of rows affected or the use of  @@ROWCOUNT in sql server. Explanation: To get the number of rows affected by a query below sql query is

Different Isolation levels in sql server

Introduction: In my previous article I have explained about  how to Get system name using sql or c#.net. In  this article I will explain about different transaction levels in sql server. And which one we should use for better performance. Explanation: Transaction isolation level Controls the default transaction locking behavior for all Microsoft SQL Server

Get system name using sql or c#.net

Introduction: In my previous article I have explained about  Check textbox is changed or not using javascript C#.net. In this article I am going to explain about how to get the system/computer/local machine name using c#.net and sql server. Explanation: To get the system name using c#.net below code is used. System.Environment.MachineName; To get the

Check textbox is changed or not using javascript C#.net

Introduction: In my previous article I am explained about the Check uncheck all checkboxes in grid view using jquery . In this article I am going to explain about how to check whether the textbox value is changed or not using javascript and c#.net. Explanation: While working in a project I came to the following situation. There

Check uncheck all checkboxes in grid view using jquery

Introduction:                                   In my previous article I have explained about  Select deselect all checkboxes in grid view using javascript.In this article I am going to explain the same process using jquery.   Explanation: While working with grid view I got a requirement to select and deselect all checkboxes in a grid view in a single click.