Browse DevX
Sign up for e-mail newsletters from DevX

Search the Tips
Tip Bank > Database Development > Relational Databases

Relational Databases

1-20 of 219     Previous     Next
Print the Length of the String Without Using strlen()
by Rajani Kanth
The following code reads one string, and prints the length of that without using ...
Use sp_executesql To Execute Dynamically Built SQL Statements in SQL Server
by Christoffer Hedgate
There are two ways in SQL Server to execute a T-SQL statement that has been dynamically built. The most common one is using EXECUTE to run ...
Execute an Operating System Command From Within SQL Server
by Mahyar Ghasemali
Close Connections When You Are Finished With Them
by Trong Ha
By proactively closing connections when they are no longer needed, you reduce demand on the database server and make resources available to other users. Connections are closed when they go out of ...
Don't Cache ADO Database Connections in the ASP Application Object
by Andrew Holliday
If you do, then all the pages will fight for the use of this connection. In addition, don't cache an ADO connection in the Session object. If you do, a database connection will be created for ...
Undocumented Encrypt and Decrypt Functions in SQL Server 7.0
by Andrew Holliday
There are two undocumented encryption functions. They are not supported by Microsoft, and I have had problems with some SQL Server service packs when using these functions. That being said, the ...
Method to Perform Case Sensitive Searches in SQL Server
by Andrew Holliday
By default, SQL Server 7.0 installation sets up SQL Server to run in a case insensitive mode. For most applications this may work great, but there are certain situations were case sensitive ...
Using INSTEAD OF In Place of Triggers In SQL Server 2000
by Andrew Holliday
The new INSTEAD OF functionality is not exactly like a trigger, but similar. Unlike AFTER triggers, the INSTEAD OF trigger replaces the incoming transaction data modification statement with its ...
Informix SQL
by DevX Pro
Are Transact SQL stored procedures currently running on a SQL Server 7.0 database compatible with a Informix database?
Temporary Table Creation
by DevX Pro
What is the advantage of creating temporary tables?
Connecting SQL Server 7.0 and MS-Access
by Narendra Bisht
You can connect a MS-Access database to SQL Server as a linked server, and query Access tables in SQL Server's Query Analyzer. This can help in porting data from Access to SQL Server. ...
Export HTML Table to Excel
by Jitendra Kumar
Here is a simple way to export an HTML table to Excel with a single line of code. For the technique to work, you must have Excel installed on the your machine.
SQL Stored Procedure to Run Single Command on All Tables
by Steve Smith
There is an undocumented stored procedure that you can use to run a single command on all tables in a database. It is very useful when doing routine jobs on all the tables. For example, re-indexing ...
Delete Files from SQL Server Local Machine
by Andrew Holliday
Ever wanted to delete files from the local machine that your SQL Server database is running? ...
Convert Informix File to Text File
by DevX Pro
How do I convert Informix data under Unix to a text file?
SQL Query to Update a Column Value in All Tables
by Venkat Alladi
This is a very simple but time-saving and powerful tip to build a ...
Filtering a Recordset
by Manoj K.
If you have a recordset already created and want to filter it by some criteria, you can use the Filter property of the recordset to do it. Just change the recordset's Filter property to a WHERE ...
Use SQL Server Savepoints Intelligently
by Jai Bardhan
You can use savepoints in rolling back portions of transactions to predefined locations. A T-SQL savepoint defines a location to which a transaction can return if part of the transaction is ...
XML and Oracle
by DevX Pro
Can the ORACLE database talk with XML like SQL Server can?
View SQL Behind System Stored Procedures
by David Satz
If you are ever trying to write SQL to access SQL server's system tables, it is often useful to look at SQL Server's own system stored procedures. You can do this by simply running EXEC ...
1-20 of 219     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date