Tags → Execute Sql Statements

Using Stored Procedures with MSSQL and ASP.NET 2.0

If you haven''t used MSSQL stored procedures before with SQL Server and in your ASP.NET 2.0 pages then you need to read this article. In this article I will list down basic questions like the following :what is a stored procedure? How can I crea...

• Categories
  • ASP.NET →
  • Tips and Tutorials
• Platforms
  • Windows
• Licenses
  • Other Free / Open Source License

SQL Server Tutorials - Getting Started with Transact-SQL Statements

A collection of 10 tutorials for you to get started quickly with running Transact-SQL statements on SQL Server 2005. Clear examples are provided for running CREATE TABLE, INSERT, UPDATE, DELTE, SELECT, CREATE USER, GRANT EXECUTE statements.

• Categories
  • Tools and Utilities →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • Freeware

table exists

I find this little script very useful for web applications that need to automatically generate tables. I wrote it because I felt it was wrong to have a script execute create table SQL statements for tables that already existed.

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • Freeware

Creating JDBC SQL Statements. Displaying Records from a MySQL Database.

A tutorial on how to create and execute JDBC SQL Statements and display records from a table in a MySQL Database. Also covers topics like creating databases and tables in MySQL. All code is explained in detail.

• Categories
  • Java →
  • Tips and Tutorials →
  • Database-Related
• Platforms
  • Linux
• Licenses
  • Freeware

Village

Village is a 100% Pure Java API that sits on top of the JDBC API. The purpose of this API is to make it easier to interact with a JDBC compliant relational database. By using Village, it is possible to execute and manage select/insert/update/delete S...

• Categories
  • Java →
  • JSP and Servlets →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • Freeware