ADO.NET's SQL command builder reads a schema and generates SQL for you; this can be an excellent timesaver in the appropriate circumstances. When applied with sound judgment, this technique is a nice shortcut.
Latest SQL Server Articles - Page 5
If you're a Visual Basic .NET programmer who has to write stored procedures for MS SQL Server, this article is for you. Learn how to isolate SQL code from VB.NET code to clearly create divisions of labor and focus for your solution.
The database assembly build tool is a tool to allow a developer to select database schema items (tables, views, stored procedures, users, and so forth) and export the DDL to create these items to an SQL file.
A utility form that will show DataGrid events with parameters as they happen in realtime.
Learn how to find the country list from a computer's registry. You see how to read and write to the directory from SQLServer.
Generating 'next numbers' numbers in SQLServer should not be a problem. But problema arise when a customer asks for different types of next numbers that you cannot generate directly from SQL Server. Learn how to tackle this problem in different scenarios.
Latest Developer VideosMore...
Latest CodeGuru Developer Columns
It's essential to know the differences in these libraries and use them correctly. This brief tutorial will guide you.
Learn how to pass off the delegation of an operation to a different class.
The BitVector structure has many useful properties, and knowing how to make proper use of memory will always improve the performance of your applications.
Here are some guidelines to make implementing load testing easier and more likely to be well received by your team.