This category contains FAQ's for SQL & Database related such as Oracle.

This category contains FAQ's for SQL & Database related such as SQL Server.

This category contains FAQ's for SQL & Database related such as Stored Procedures.

Explore the FAQs

SQL Server

Using Triggers to "protect" data

Question:

There's a leak in database security, how can I protect myself from foulplay through a hole that is there by design ? Read More

February 16, 2003 Dennis van Galen

3272

SQL Server

Permissions

Question:

I created a new table in my SQL Server database but in DWMX I cannot get the tables to appear, why ? Read More

December 17, 2002 Dennis van Galen

4281

SQL Server

Creating a view

Question:

How do I create a view in SQL Server 2000 ? Read More

December 16, 2002 Dennis van Galen

3673

SQL & Databases

I have a table which contains invoice lines and I am trying to produce a recordset that will produce a list by client with the total owed by that client but I need to take a field with paid yes or no into account to only display open amounts. Read More

December 12, 2002 Dennis van Galen

8775

SQL & Databases

Sorting with Datepart()

Question:

I want to add a birthday list of my users but i cannot get them to order properly, the year of birth is taken into account and I do not want that. Read More

December 12, 2002 Dennis van Galen

7771

SQL & Databases

Get records with Date()

Question:

How do I filter my recordset so that it returns only results for today ?

December 4, 2002 Dennis van Galen

7526

Stored Procedures

Create a random number and Insert it into a DB field

How to create a random number and insert it into a database field along with information fom you web form.

June 9, 2002 Owen Eastwick

17536

SQL Server

OLE and OLEDB Provider Error Codes (0x800xxxxx)

Question:

Where can i get a complete list of OLE / OLEDB Error codes and descriptions ?

Answer:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q168354&GSSNB=1

December 27, 2001 Owen Eastwick

24041

SQL Server

How do I add UK Dates to SQL Server?

This FAQ shows you how to set SQL Server to allow UK Date format using a simple stored procedure call.

May 11, 2001 Nic Skitt

17616

Oracle

Calling an Oracle Stored Procedure

How do I call an Oracle Stored Procedure
by Surya Rao

Folks, contrary to popular belief there are many ways to call stored procedures from an ASP page.I've tried it with Oracle (the only REAL RDBMS ;-) and it works.

March 14, 2001 George Petrov

263987

Oracle

Connect to Oracle via ASP

I cannot connect to Oracle via ASP....

contributed by Bret H. Grade bgrade@aris.com
MCSE, MCP+Internet Senior Consultant,
ARIS Corporation Inquire at http://www.aris.com

March 14, 2001 George Petrov

58400

SQL & Databases

Bristle Software SQL Tips

This is one HUGE resource of SQL Tips!

February 28, 2001 George Petrov

3159