Members

Technology Zones

IBM Learning Center

Articles

Hosted By

Info

• Index
• / Programming Languages
• / SQL

Forum Messages

• Re: [1002] Wrap text in a label control posted 18 Jul, 21:17 by paigew in User Comments

• Re: how can i change registry value from vb posted 18 Jul, 19:35 by depash in Visual Basic 6

• Re: INSERT data into Access from VB .NET posted 18 Jul, 19:26 by SAGUTI in VB.NET

• windows explorer columns posted 18 Jul, 19:25 by Madanjeet in VB.NET

• Help me to make a form!!~!! posted 18 Jul, 18:53 by graphicsbybcd in VB.NET

• Re: Simple Unique Document Numbering. posted 18 Jul, 16:06 by TimL in VB.NET

• Re: Publishing an .exe app using VB.net posted 18 Jul, 15:39 by TimL in VB.NET

• Re: Publishing an .exe app using VB.net posted 18 Jul, 15:28 by konikula in VB.NET

• Re: Monitoring application name in task manager using VB.NET posted 18 Jul, 15:20 by konikula in VB.NET

• how to refresh access 2003 database posted 18 Jul, 10:55 by sathyan_8294 in ASP.NET

• More Forum Posts...

Articles & Tutorials

• Dynamic Search Conditions in T-SQL

  by Erland Sommarskog

  A very common requirement in an information system is to have a function (or several functions) where the users are able to search the data by selecting freely among many possible criterias. In this text I will look at various techniques to solve this problem..

• High-Performance .NET Application Development & Architecture

  by DMarko1

  This article demonstrates the art of creating and architecting high-performance and scalable .NET applications, covering all stages, from planning to development and their perspective best practices..

• SQL Injection Attacks by Example

  by SJFriedl

  Steve Friedl takes a look at how your site could be vulnerable to SQL injection attacks - complete with numerous examples - and the action you can take to prevent them..

• SQL In Simple English

  by kiranpai

  Kiran Pai introduces the basics of Structured Query Language in an Q & A session.

• SQL Commands

  by James Crowley

  If you want to use databases, in VB, Access, ASP or anything else, at some stage you will need to learn SQL. This tutorial shows you how to use this powerful and universal language..

Sample Code

• Bulk Insert from Flat File Using Transact-SQL

  by mmharinath

  Importing Data from Text File using Transact-SQL is not a tough task, we can import data from Flat File in just 3 steps..

• SQL Running Total

  by neilc

  One SELECT statement to calculate running total in Access OR MS-SQL (And anything else for that matter)..

• Deleting duplicate rows in a table

  by kconcept

  Eliminating duplicate rows of data from an Oracle database.

• Running total in an SQL query

  by James Crowley

  How to create a running total column in an SQL query.

• How to include Text, nText and Image datatypes in a Union query

  by ElementK Journals

  How to include Text, nText and Image datatypes in a Union query.

• More SQL Sample Code...

Sample Chapters

• Stored Procedures

  From Beginning Visual Basic SQL Server 7.0

  An introduction to Stored Procedures, from the book Beginning Visual Basic SQL Server 7..

Reviews

• Review of SQL Server 2000 Programming

  by James Crowley

  SQL Server 2000 Programming claims to be a comprehensive guide to SQL Server 2000, and at a hefty 1390 pages, you can't argue with that. Being a programming guide, it concentrates only on issues that affect an SQL Server developer, but it still covers topics such as Database Administration to a reasonable level..

Books

• Professional SQL Server 2000 Programming

  Published by Wrox Press

  Read the review of this extensive guide for all SQL Server 2000 developers.

• Beginning Visual Basic SQL Server 7.0

  Published by Wrox Press

  Most Visual Basic applications involve database programming of some kind, and SQL Server 7.0 is gthe database of choice for many Visual Basic programmers. This book introduces SQL Server 7.0, cover....

• Hands On SQL 7 with VB6

  Published by Unknown

  This is a SQL Server tutorial aimed at improving decision making and simplifying business processes with Microsoft's SQL Server 7 and Visual Basic 6. It includes comprehensive coverage of VB6 in bu....

Jobs in United States

• ASP.NET Senior Developer and Architect

  Salary $100k+ with benefits, Permanent in Boston, US

  We are a venture-funded software startup in Cambridge, MA seeking top-notch ASP.NET developers (C#). This is a permanent position for local candidates in the Boston area.

Blogs in United States

• Review of NDepend

  Published on 17 Jul 2008 from Nick Berardi's Coder Journal

  When I was asked to review NDepend I didn’t want to do just another review. Because there are plenty of great reviews and I would just be adding to the noise. So I am going to use this time to give a personal story of how NDepend has helped me restructure some code I have been [...]

• iTunes 7.7 + Windows Vista x64 == OK

  Published on 11 Jul 2008 from Nick Berardi's Coder Journal

  iTunes 7.7 has been released! Windows Vista x64 I am happy to announce that iTunes 7.7 and Windows Vista x64 work well together. The Apple downloader even chooses the correct 64-bit version of iTunes through every browser that I have tried, so they obviously fixed something where you don’t nee

• Ladies Night on Coder Journal

  Published on 08 Jul 2008 from Nick Berardi's Coder Journal

  I received a ton of nice comments from Rob, John, Scott, and Phil related to my previous post, What Software Bloggers Do Girls Like Better? Phil even did a nice follow up post, with some good humor gloating, until the end where his wife let the air out of his sails; like only a [...]

• Which Software Blogger Do Girls Like Better?

  Published on 27 Jun 2008 from Nick Berardi's Coder Journal

  Today I received an invite to Google Ad Planner. As I was playing around with this new tool, I was really blown away by how much information Google has collected on specific websites. So much so that I wanted to share this tool with my readers, but I couldn’t come up with an interesting way [.

• MVC CAPTCHA for Preview Release 3

  Published on 24 Jun 2008 from Nick Berardi's Coder Journal

  Since my last release of the MVC toolkit some major changes have taken place in the MVC Framework. I am going to do a quick run through of how they changed the MVC CAPTCHA for the better. Originally in MVC Preview Release 1 for the MVC CAPTCHA many of you remember that the indicator for [...]

• More SQL Blogs in United States...

Web Sites

• Code Generation Network

  The Code Generation Network covers all aspects of code generation and model-based development. The site's resources include a database of code generation tools, interviews with leading exponents of code generation and book reviews on code generation and software development in general.

• Getting started with SQLXML

  SQLXML allows you to send queries to your SQL Server database and to be able to retrieve the results in XML over the web. This article will tell you how to set it up.

• SQL Guru

  In depth articles on SQL

• SQL Team

  Great SQL Site for Q&A as well as how to. Fast and sound response

Search

Code Samples

New Members