Monthly Archive:: April 2012
25 Apr 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()
25 Apr 2012
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
25 Apr 2012
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
24 Apr 2012
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.
24 Apr 2012
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
24 Apr 2012
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
20 Apr 2012
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
18 Apr 2012
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
18 Apr 2012
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
17 Apr 2012
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.