Sql Server Oracle Scripts

Here is a procedure for SQL Server which can be created in a module and called from a query using InitCap([fieldname])....thanks to Paul

Author: Sachin Pendgaonkar   Category: Data Conversion   License: freeware   Size: 1024 B

Universal high-speed Delphi Data Access Components for Firebird, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, IBM DB2, SQL Anywhere and more.

Author: DA-SOFT Technologies   Category: Direct Data access   License: shareware   Size: 63.3 MB

The DBX Commander directly supports all major databases such as: ORACLE, Microsoft SQL Server, Sybase, Informix, DB2, Interbase, Paradox, Micros

Author: Branislav Cobanov   Category: DataBase - Misc.   License: shareware   Size: 1.4 MB

The MSSQL LogManager Product Family is a suite of tools which helps you to keep track of data changes in your Microsoft SQL Server database.Key Features:Supports Microsoft SQL Server 2000 Server-side logging mechanism Table operation

Author: Upscene Productions   Category: DataBase - Misc.   License: shareware   Size: 2.2 MB

The Database Commander directly supports all major databases such as: ORACLE, Microsoft SQL Server, Sybase, Informix, DB2, Interbase, Parad

Author: crystal-soft.com   Category: DataBase - Misc.   License: shareware   Size: 1.4 MB

SQL data recovery software recovers data from corrupt .MDF files of SQL server version 2000 and 2005. Deleted records, tables, views, triggers, foreign keys are easily recovered by the software.

Author: Data Recovery Software   Category: Database Tools   License: shareware   Size: 2.0 MB

idxScout - Database Discovery, Accurate SQL Joins and Data Modeling. Hunts for relationships hidden in a database. Create machine accurate SQL joins. Unique interface. Supports SQL Server, MySQL, Oracle, MS Access, DBF, & MS JET.

Author: idxSoft LLC   Category: Miscellaneous   License: shareware   Size: 820.0 KB

Count Records from SQL Server Database using ADO.NET, SQL, and Visual Basic.NET is a tutorial for those who needs to show the record count on the ASP page. In this tutorial author demonstrates it by calling the executescalar method.

Author: Easerve.com   Category: Database Tools   License: freeware

Automating Server Side Tracing in SQL Server is an reference article which helps the webmasters and developers to outline the SQL server tracing. This article provides various details about the functionalties to trace systems stored procedures and fu

Author: Narayana Vyas Kondreddi   Category: References   License: freeware

Developing SQL Server Database Explorer is a tutorial for those who needs to list various databases, tables and columns of the tables. In this tutorial the author gives you the sample source code for a windows based application that helps you to expl

Author: Dotnetbips.com   Category: Database Tools   License: freeware

Extend the reach of SQL Server with SQLXML classes in .NET is an user friendly tutorial which concentrates on SQLXML, through which XML features can be used along with SQL server in .NET. In this tutorial the author explains about SQLXML classes like

Author: Builder.com   Category: XML & ASP.NET   License: freeware

How To Call SQL Server Stored Procedures in ASP.NET by Using Visual Basic.NET is an article which briefly explains the method of creating and executing the stored procedures of the Sql Server database in ASP.NET. The article demonstrates it by desigi

Author: Microsoft Corporation   Category: Database Tools   License: freeware

How To Update a SQL Server Database by Using the SqlDataAdapter Object in Visual Basic .NET is an article in which the author demonstrates the procedure for utilizing SQLDataAdapter objects for updating the modified data of the dataset in the databas

Author: Microsoft Corporation   Category: Database Tools   License: freeware

HOWTO: SQL Server with Integrated Security, IIS on Same Machine is a tutroial which concentrates on securing the SQL server and IIS in a same machine. Here author provides step by step method for performing the security on the server from controlling

Author: Microsoft Corporation   Category: Security Systems   License: freeware

Manage Multiple SQL Server installations and Databases with OSQL is a tutorial which helps you to execute repetitive tasks against several numbers of databases using OSQL. OSQL is a command line utility which helps you to run Transact-SQL statements,

Author: Randy Dyess   Category: Database Tools   License: freeware

Part 1: Retrieving Data From SQL Server 7.0 with C# is a tutorial in which the author shows the step-by-step process of creating table in Sql Server database, establishing the DSN connection and using various object of the ADO.NET it fetches the Sql

Author: Csharphelp.com   Category: Database Tools   License: freeware

Performance problems accessing SQL Server via COM+ is an article which gives the detailed information about the serialization. Memory, processor, SQLserver- databases, buffer manager, memory manager, general statistics, etc., are the objects which ef

Author: Vyaskn   Category: References   License: freeware

This article instructs about SQL server and .NET: Dynamic duo and guides the programmers to build web based applications by their own to store data on SQL server. The author also describes about the use of SQL server and about the implementation of A

Author: Rick Dobson   Category: Server Management   License: freeware

SQL Server Performance Audit is a multi-part article is used to improve the performance. It use quasi scientific method which helps the user to find out the performance problem occured in the SQL server. The main advantage of using this check list wh

Author: Brad M. McGehee   Category: References   License: freeware

Use OPENXML to Minimize SQL Server Database Calls is a reference which offers detailed description about the newly added OPENXML function which offers adding row set view to the XML documents. This article discusses about various process done by this

Author: Jay Buchta   Category: References   License: freeware