How to Find The Actual SQL Query Executed By The ADO SqlCommand blog.bodurov.com 3 Dec 2010 | 05:26 am

When we use SqlCommand with a set of parameters, they are being executed as a parametrized query. You may or may not pass the desired type with each SqlParameter. If you do not specify desired databas...

SQL Injection biswajitroutray.wordpress.com 2 Oct 2011 | 10:53 pm

SQL injection is an attack that allows the attacker to add logical expressions and additional commands to an existing SQL query. This attack can succeed whenever a user submits data that is not proper...

Microsoft.Ace.OLEDB.12.0 and OPENROWSET Errors sqltutorials.blogspot.com 15 Feb 2012 | 10:08 pm

If you imports excel file into database using sql query INSERT INTO newtable select  * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=C:\temp.xls;HDR=YES', 'SELECT * FROM [sheet$]'....

Beginning SQL Server 2005 Programming topwaster.eu 12 Nov 2011 | 11:02 pm

Beginning SQL Server 2005 Programming (2006) After a quick primer on database design basics and the SQL query language (for those programmers who may be building their first database application), th...

How to calculate database size in MySQL using sql query? php4u.co.uk 16 Jun 2011 | 08:35 pm

NetBeans Database Explorer manikandanmv.wordpress.com 26 May 2011 | 09:33 pm

Are you working on sql queries often? Are you executing queries with different database servers (MySQL, PostgreSQL, Oracle)? Are you working on an application which should be tested on multiple data...

Objective-C SQL Query Builder iphonedev.com 30 Aug 2011 | 07:03 am

This Objective-C SQLite projects is a lightweight library that offers more than just a set of SQLite wrapper classes. It is divided up into five parts. The first part consists of a set of Objective-C ...

Add minutes or hours to current time mysql techispeaks.com 26 May 2012 | 12:09 am

Writing a SQL query is always interesting, and for me it’s never boring task. Recently I was developing a CRM for my company, In that I need to send mail to the users who have scheduled their task as ...

Change a column which is or has a foreign key in MySQL exoool.com 10 Nov 2011 | 01:24 am

When trying to change(alter) a column which is a foreign or has a foreign in MySQL, an error info like below shows up: Error SQL query: ALTER TABLE `city` CHANGE `CountryCode` `CountryCode` CHAR( 3...

SQL query performance test with JMeter scornik.blogspot.com 5 May 2011 | 04:40 pm

There are lot of tools in the market by which you can analyze performance of SQL query or stored procedures. Which tool you select is a matter of choice and compliance with your database server. Apac...