Community Member Profile

Recent Blog Comments By Pinal Dave

• Running UPDATE And DELETE SQL Statements Using ColdFusion Query Of Queries

  Posted on Sep 12, 2009 at 1:03 PM

  This blog I have been reading for almost 3 years. I am commenting again on this particular post after almost one year. Ben, This is totally creative and hats off to you. Few may think what a big deal but if someone who have experience with SQL and ColdFusion both, can only truly appreciate... read more »

• Datasource Names For All The Database Tags Within CFTRANSACTION Must Be The Same

  Posted on Feb 8, 2008 at 3:11 AM

  Great Post! The workaround for the problem of CFTRANSACTION with different data source we have used earlier was. Use the same datasource but prefix the table with desired database. Following solution is not good and many times gives unexpected results. Not RECOMMENDED. I am li... read more »

• Thanks Adobe!

  Posted on Jan 21, 2008 at 1:43 AM

  Hey Ben, Wonderful wonderful. Actually your services to community are well noted by Adobe, you very well deserve this honor. Congratulations congratulations!!!... read more »

• Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

  Posted on Sep 5, 2007 at 10:51 AM

  Ben, I am sure my blog readers will find it useful. http://blog.sqlauthority.com/2007/09/05/sqlauthority-news-interesting-rea... read more »

• Using A SQL JOIN In A SQL DELETE Statement (Thanks Pinal Dave!)

  Posted on Sep 4, 2007 at 3:22 PM

  Ben, Thanks for posting this article. I glad that you find it useful. I think my blog reader will find this details very useful as I never wrote about this on my own blog. Tomorrow I will write down summary and point to this two wonderful (and well explained) post you have. I li... read more »

• Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

  Posted on Sep 4, 2007 at 10:46 AM

  Ben, As general rule you can write all your UPDATE, DELETE query the same way you can write SELECT Query. They have same structure of syntax. You could also DELETE using JOIN as well. Try following query you will love it. DELETE tableName FROM tableName tn INNER JOIN JoinedT... read more »

• Using CASE Statements In A SQL UPDATE Query

  Posted on Aug 30, 2007 at 7:26 PM

  SQL can do many magical stuff. I use SQL for all the business logic. I use ColdFusion for presentation. CASE statement can be effectively used in ORDER BY : read more »

• Ask Ben: Protecting Database Table Names In ColdFusion CFQuery

  Posted on Jul 26, 2007 at 4:05 PM

  Ben, Good post. That is very true that if we specify explicit names of tables it is the safest. Let us see with real example that SQL can do the table exist check how application help database with the task. We are using application where we create lots of dynamically created tables,... read more »

• Ask Ben: Getting the Previous Day In ColdFusion, Excluding Saturday And Sunday

  Posted on Jul 23, 2007 at 4:02 PM

  Hi Ben, Not as simple as your solution. However, I use the similar function in SQL. I dig it up after I read your blog. http://blog... read more »

• I Just Felt The Awesome Power Of SQL Table Indexing (Thanks Nate Nelson!)

  Posted on Jul 13, 2007 at 2:57 AM

  I recommend http://blog.sqlauthority.com/2007/07/05/sql-server-2005-best-practices-analyzer-tutorial-sample-example Thanks Tony. Pinal Dave... read more »

• I Just Felt The Awesome Power Of SQL Table Indexing (Thanks Nate Nelson!)

  Posted on Jul 12, 2007 at 9:06 PM

  Hi Ben, First congratulations. Indexing is very important. In SQL Server 2005, the functionality of non-clustered indexes is extended by adding non-key columns to the leaf level of the non-clustered index. Non-key columns, can help to create cover indexes.By including non-key columns,... read more »