Is there any way to prevent a Value from being deleted in a table that is being used as a foreign key. Example:
if a table called DEPT has a primary key of DeptNo (Dept list all the valid Dept...
http://www.experts-exchange.com/Database/Oracle/Q_20119890.html
Zones:
OracleDate Answered: 05/21/2001 Grade: B Views: 0
Here's what's in the db:
role_cd, with a CHECK (role_cd IN ('M','S','R','C','I'), I need this to be:
CHECK (role_cd IN ('A','M','S','R','C','I') ---> note the addition of 'A'...
Now this c...
http://www.experts-exchange.com/Database/Oracle/Q_20719558.html
Zones:
OracleDate Answered: 08/25/2003 Grade: B Views: 0
http://msdn.microsoft.com/library/en-us/tsqlref/ts_create2_8g9x.asp?frame=true
Almost at the end of this web site it shows an example of an employee table.
CREATE TABLE employee
(
emp_...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20725917.html
Zones:
DatabasesDate Answered: 04/26/2004 Grade: A Views: 0
Hello guys and gals,
I need to drop a PK in one of my table. Unfortunately, it need to be done automatically since most of the users dont have EM or QA.
Im trying to read the result set of SP_H...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20732897.html
SQL2000...
I'm trying to make a check constraint expression to satisfy the following:
- Username anywhere between 4 and 16 characters
- Username consisting only of [A-Za-z0-9] or underscore ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20761256.html
I have this table:
CREATE TABLE [dbo].[rateCategory] (
[rateCategoryId] [int] IDENTITY (1, 1) NOT NULL ,
[rateId] [int] NOT NULL ,
[categoryId] [int] NOT NULL
) ON [PRIMARY]
GO
I wou...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20850542.html
I need to generate a cross-tab report for a travel and expense reporting system. I have the following tables in a SQL Server 2000 database:
CREATE TABLE [setTandEReport] (
[TandEReportID] [in...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_20879840.html
Zones:
.NETDate Answered: 02/11/2004 Grade: A Views: 0
Must I activate something in MySQL before I can use check contstraints? Cos it seems like my check constraints are useless. I can remove rows that are supposed to be bounded to a check constraint t...
http://www.experts-exchange.com/Database/MySQL/Q_21237541.html
Zones:
MySQL ServerDate Answered: 01/16/2006 Grade: A Views: 0
I would like to have a vb app that will allow people to select an image and have it appear on a form later on.
1. what kind of images can vb handle?
2. Is there any sort of resolution const...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_21353040.html
Hey everyone,
When creating a table can you force a constraint (or in access terms, an input mask) on a field. I need the field to have the format Mnnn where M is always just M, and n is a digit...
http://www.experts-exchange.com/Database/Oracle/Q_21370982.html
Zones:
OracleDate Answered: 03/31/2005 Grade: A Views: 0
