Below are some of the tips for SQL query optimizations in the form of question/answers. 1. Which of the following query is the most optimized? a. SELECT column_name FROM table_name WHERE LOWER(column_name) = ‘name’. b. SELECT column_name FROM table_name WHERE column_name = ‘NAME’ or column_name = ‘name’. c. SELECT * FROM table_name WHERE LOWER(column_name) = [...]

In this article we will look into how to write a sql query to get a particular row in sql. Lets write the code to find 2nd row in a table named mcc_measures. So first we declare a temporary table No in this temp table we insertrow numbers of the table Now from the temp [...]

Session states of the asp.net application can be easily saved into SQL Server using the following steps: Change the settings in the web.config file. In the database create the appropriate tables.It is done automatically wen we execute the exe aspnet_regsql.exe located at C:\WINDOWS\Microsoft.NET\Framework\v2.0. location