Some of the queries in SQL may require a temporary holding place in the memory for doing some logical process.For example, select certain number of rows from a table and remove/update some rows within this based on some condition.This may require a temporary variable or table in SQL server 2005 to achieve this task.
There are four ways we can have temporary recordset or a dataset in SQL server.
1) Temporary Table Variables
2) Temporary Tables
3) Derived Tables
4) Common Table ex-pressions (CTE)
Read more on this topic…
Posted in Technical.
By Shiju Rajan
– July 28, 2008
Web is evolving rapidly these days with some powerful features. Users don't want to wait for response from the server that will refresh the full web page they are visiting. They expect the web pages they visit behave like a desktop application.Read more at : http://www.dev-exchange.com/cms_view_article.php?aid=30
Posted in Software.
By Shiju Rajan
– June 19, 2008
This article shows an example about how to create and call .net component in PHP applications.
http://www.dev-exchange.com/cms_view_article.php?aid=15
Posted in Software.
By Shiju Rajan
– July 19, 2007
LIKE statement can be used in query if applican needs to match certain values in a database field.This article explains about using wildcards in LIKE statement. Also this will show example on regular expression usage in LIKE statement which should be handy for database admin.
Read more at:
http://www.dev-exchange.com/cms_view_article.php?aid=14
Posted in Software.
By Shiju Rajan
– July 11, 2007
Database performance may be getting affected if many users try to connect to it at same time. This article explains about how to improve database performance by using connection pooling in ADO.net. A connection pool is a cache or pool of database connections maintained by the application so that the connections can be reused when the database receives future requests for data. Have a look at this article to read more.
http://www.dev-exchange.com/cms_view_article.php?aid=12
Posted in Software.
By Shiju Rajan
– July 3, 2007
Creating pagination code in ASP.net is easy but if you need to do the coding for this then you can take a look at this article.
http://www.dev-exchange.com/cms_view_article.php?aid=11
Posted in Technical.
By Shiju Rajan
– June 28, 2007
Preventing SQL injection hack is a major programming headache when writing web based applications. Inorder to write a hack proof application there are many thing to be taken care
Some of the important things to remember while writing applications are
a) Replace all the ‘ quote with ” quotes which will make all the query string values to string
b) Check for the integer values if your code is expecting a numeric value through the query string.
For more reference to this subject visit following link
http://www.dev-exchange.com/cms_view_article.php?aid=10
Posted in Technical.
By Shiju Rajan
– June 25, 2007
