Blog Archives

Replace Sub Queries within “IN” or “Not IN” command by JOIN Operator to improve SQL Query Performence

As a developer we have to ensure faster response time of our applications. From our practical experiences, we found that most of the performance degradation are caused by non optimized SQL query. At the very initial stage developers may not

Posted in Database, SQL Server, SQL Server SQL/TSQL Performence Tuning

Getting last ID value of identity column from SQL Server for the most recently inserted record using ASP.Net C# & VB.Net

For the relational database like SQL Server, Oracle, and Microsoft Access/Jet we have to maintain a primary key to establish relation among entities. To do that we can use business code if applicable, but in some cases we have to

Posted in .Net, Asp.net, C#, Database, SQL Server, VB.Net

JQuery AJAX Example Code in Asp.net to Insert or Save Data into SQL Server Database without Postback in C#.Net VB.Net

In almost each and every web application we need to save or insert data into database. To save or insert data into database we need to postback into the server. Using AJAX we can provide the functionality without refreshing the

Posted in .Net, Ajax, Asp.net, C#, Client, Database, JQuery, SQL Server, VB.Net

How to Check or Handle NULL Values in Where Clause in SQL Server

NULL is an interesting value in any relational Database. Sometimes its same (for Grouping), some times not (for equality). In many cases we need to identify records those contains NULL value. Some times we need to discard records if any

Posted in Database, SQL Server

Efficient way to Save or Insert TextBox Value into MS Access DataBase Table In Asp.net Using C#.Net VB.Net

We can use MS Access Database for small scale applications. Asp.net Ado.Net provides us an easy, efficient way to develop Database driven application using MS Access as back end. To start an application here I have described “How to Insert

Posted in .Net, Asp.net, C#, Database, MS Access, VB.Net

Runtime Bind Data from SQL Server Table to Datagridview in Windows Application in C# VB.NET

DataGridView is an essential control for windows applications. This control can be used in both C#.Net windows applications as well as VB.Net Applications. Specially we use this control for tabular data representation. Here in this article I will show “How

Posted in .Net, C#, Database, DataGridView, SQL Server, VB.Net

How to Create RDLC Report Step by Step Example in ASP.net using C# and VB.net

Now a days for reporting purposes we have a lots of choice. RDLC report is one of the most popular reporting engine for Asp.net developers. Using RDLC report you can easily represent data to the end user. You can also

Posted in .Net, Asp.net, C#, Database, RDLC Report, SQL Server, VB.Net

SQL SERVER – SQL CASE Statement Conditions Examples Syntax and Explanation

The SQL CASE statement is used as a conditional operator that considers a value or expression, examines it, and return values if matched. CASE is used to provide if-then-else type of logic or Switch Case type of logic to SQL.

Posted in Database, SQL Server

Using SQL Server SUBSTRING Function

SUBSTRING() function is one of the most useful and popular string manipulation function of SQL Server. This function allows you to extract a specific substring or a portion of substring from a string. In this SQL Server Tutorial I will

Posted in Database, SQL Server

How to TRIM a String in SQL Server

TRIM is a very popular string function in many SQL. But SQL Server does not have TRIM function directly. Instead of TRIM string function SQL Server provides us LTRIM and RTRIM function to remove specified prefix or suffix from a

Posted in Database, SQL Server