|
| Recent Articles |
Microsoft Tool Reduces SQL Injection Attacks
Microsoft has introduced a new security filter for its Internet Information Service (IIS) Web server that is aimed at reducing SQL injection attacks. The application called UrlScan 3.0 is free and is an add-on tool...
Prevent SQL Injections With CFQUERYPARAM
If you haven't been using the cfqueryparam tag, chances are you had a baptism by fire this week. As you may have heard, lots of ColdFusion powered sites were...
SQL Injection Finder Tool
Running a SQL This handy newly updated tool from the Code Plex can help parse your IIS Logs looking for the standard command sequences that indicate someone is trying to do an SQL injection attack against your...
Tracking ColdFusion Problems With SQL Server Trace
Running a SQL Trace in the SQL Server Profiler can be a great way to track down performance problems in your ColdFusion application. However if you have tried...
SQL Ninja Hacking Tool
There is a certain amount of respect earned when someone makes a hacking tool that not only does what it is supposed to do, but does it elegantly as well. While this tool is aimed at professional pen testers, this is...
|
|
09.16.08
Emulating LIMIT With MSSQL 2005
 By Daniele Salatti
I don't like MSSQL, I prefer MySQL, but many times I have to deal with it at work. Lots of developers, including me and my co-worker Enrico, hate that Microsoft SQL hasn't something like MySQL's LIMIT(from, to). With some new T-SQL commands in Miscrosoft SQL Server 2005 there is a not-so-simple solution.
What about performances? Take a look at the images below!
Comments
About the Author:
Daniele Salatti is a 23 years old Italian guy. Informatic Engineering student at the University of Pisa, he is a passionate Linux user. Check out his blog at Salatti.net.
|
SQLproNews is brought to you by: