Download Database tool scripts

«« « 1234567891011 » »»
336 336

It returns a combined date.

Sql | Sep 12, 2010 | downloaded 15 script(s) | N/A

This procedure works for SQL Servers 2000 and above.

Sql | Sep 12, 2010 | downloaded 4 script(s) | N/A

The user can select a few values to except from the ordering process.

Sql | Sep 11, 2010 | downloaded 3 script(s) | Oracle

It restores / copies the most recent backup for given databases / devices.

Sql | Sep 12, 2010 | downloaded 7 script(s) | N/A

Table names, table columns, column sizes and column types will be compared between them.

Sql | Sep 12, 2010 | downloaded 7 script(s) | N/A

It handles databases on the same server or in different servers.

Sql | Sep 12, 2010 | downloaded 12 script(s) | N/A

Information like database name, table column, info type, id, keys and more can be displayed.

Sql | Sep 12, 2010 | downloaded 8 script(s) | N/A

It works with different databases or servers.

Sql | Sep 12, 2010 | downloaded 5 script(s) | N/A

The number '23' will be converted to 'TWENTY THREE' in capital letters.

Sql | Sep 12, 2010 | downloaded 5 script(s) | MSSQL

This can be easily used in any SQL environment to optimize a database.

Sql | Sep 12, 2010 | downloaded 9 script(s) | MSSQL / MySQL / PostgreSQL / Oracle / Access

It can be used by developers to determine the size of other functions, to help them optimize the database.

Sql | Sep 12, 2010 | downloaded 4 script(s) | N/A

The procedure is recommended to be used inside other MS-SQL functions to process date and time data.

Sql | Sep 12, 2010 | downloaded 3 script(s) | MSSQL

It's a SQL stored procedure to find foreign keys inside a database table.

Sql | Sep 12, 2010 | downloaded 1 script(s) | N/A

It skips over checking for nulls or other non-numeric values at the client application or when passing values to other functions.

Sql | Sep 12, 2010 | downloaded 1 script(s) | MSSQL

It needs as input a comma separated list.

Sql | Sep 12, 2010 | downloaded 1 script(s) | MSSQL

Normally, the server collation is specified during SQL Server installation.

Sql | Sep 12, 2010 | downloaded 4 script(s) | MSSQL

It cancels the need to use text editors.

Sql | Sep 12, 2010 | downloaded 4 script(s) | MSSQL

Resulted data can be used in geographical applications.

Sql | Sep 12, 2010 | downloaded 2 script(s) | MSSQL

The script shows how to enumerate directories and files using NT DIR commands.

Sql | Sep 12, 2010 | downloaded 2 script(s) | MSSQL

It will scan the date values and determine what is the date for the first and last day of a week.

Sql | Sep 12, 2010 | downloaded 2 script(s) | Oracle

It can be used to shut down a server just by running a procedure, or to play a joke on somebody.

Sql | Sep 12, 2010 | downloaded 2 script(s) | Oracle

It is even possible to replace the whole text.

Sql | Sep 12, 2010 | downloaded 3 script(s) | N/A

Data is left intact, not interacting directly with it.

Sql | Sep 12, 2010 | downloaded 1 script(s) | N/A

It uses SQLDMO’s PingSQLServerVersion method.

Sql | Sep 12, 2010 | downloaded 9 script(s) | N/A

The sp_dropuser and sp_adduser procedures will be used to perform this task.

Sql | Sep 12, 2010 | downloaded 1 script(s) | MSSQL

It introduces a really easy way to manually run database maintenance operations.

Sql | Sep 12, 2010 | downloaded 5 script(s) | MSSQL

It does not parse or loop through the CSV string to convert it.

Sql | Sep 12, 2010 | downloaded 2 script(s) | N/A

The code is at beginerrs level.

Sql | Sep 12, 2010 | downloaded 3 script(s) | MSSQL

The admin can even specify which databases should be left out of the scheduled maintenance operation.

Sql | Sep 12, 2010 | downloaded 6 script(s) | MSSQL

It works for SQL Server 2000 and SQL Server 7.0.

Sql | Sep 12, 2010 | downloaded 2 script(s) | MSSQL

«« « 1234567891011 » »»