|
|
Browse by Tags
- copy
- database design
- ddl script
- Internet Explorer
- mysql
- normalization
- oracle
- RDBMS
- sql
- SQL 2005
- SQL query
- sql server
- vb
-
One to One Relationship and ON DELETE CASCADE - RDBMS Design
Customer and CustomerPrivateInfo are meant to be one to one relationship. If CustomerPrivateInfo record is attempted to be deleted, prevent deletion. If Customer record is deleted, delete its associated CustomerPrivateInfo. Does the DDL below fulfill my request? I'm using Oracle... Code Snippet:... -
SQL*Plus Error While Running a DDL Script - Oracle
I have DDL Script. When i run every table DDL script individually, tables gets created. However, when i run the whole script by doing: SQL> @C:\Users\Home_User\Desktop\motel_db_schema.sql I got error for one the tables which screws up all the child tables too. This is the error i get: SP2-0734: unknown... -
Why Can't I Use Currval in Select Statement? - Oracle
I was trying to do SELECT employeename, job_id_seq.CURRVAL FROM employees; I got an error. Can't i call CURRVAL of a sequence via SELECT like above? Why? I know it would work if i do it on DUMMY table. Can i use name.CURRVAL via INSERT INTO? Why? -
Can I Put CREATE SEQUENCE - NEXTVAL Within CREATE TABLE - Oracle?
I created some sequences. I would like to indulge into the primary key column in CREATE TABLE script. How can i do it? -
Simple Question About INSERT INTO Using Select Query - Oracle
INSERT INTO CustomerFamilyHistory (customerfamilyhistory_id_seq.nextval, firstname, lastname, age, ?????, sibling, customerid) SELECT customerfamilymemberfirstname, customerfamilymemberlastname, customerfamilymemberage, customerfamilymembersibling, cusfamilymembcustomerID FROM CustomerFamilyMember; Insert... -
Please Check My Simple DDL Script - Fix Mistakes If Any
Is it ok to do CHECK (leavingdate >= hiredate)? I don't have the tools yet to check my script. Code Snippet: 1: 2: 3: 4: 5: 6: 7: 8: 9: CREATE TABLE EmployeeHistory ( employeehistoryid number(10) CONSTRAINT employeehistoryid_pk PRIMARY KEY, salary number(9,2) NOT NULL, motelname varchar2(50) NOT... -
SQL Where Statement capture Null Value
Trying to capture a Null value in SQL WHERE statement. Currently I am receiving no data back from this (even though there are Null fields). Current code is as follows: SQLQuery = "Select EmployeeID, FirstName, MiddleName, LastName, HomeAddress1, city, state, ZipCode, HireDate, TerminationDate, UDF8... -
Problem: copy database from one to another
Hi experts, I want to copy a whole database, including its tables and contents, to another machine. For example, if the database is named as "my_db", what I did was made an SQL dump for the my_db, then on another machine I created a database with name "my_db" as well. And I tried... -
Problem: SQL Stored procedure to count each row that has the same value
I have a question in concerns with counting rows. I have two tables table1 CaseID, UserID, CaseTitle, CaseDescription Table2 ID, CaseID, CaseNotes How can I create a stored procedure that will enable me to count al of the notes for the same CaseID and only select table1 and add an extra column for the... -
Problem: SQL Script Runs in SQL2005 but recieves errors in SQL2000. How to convert without losing needed code?
How do I convert a script for SQL Server 2005 to run in SQL Server 2000? The attached code snippet running in Query Analyzer in SQL 2000 produces several incorrect syntax errors. I suspect all the errors are due to the syntax used in SQL Server 2005. Would you provide the changes I need to make to run...
Page 1 of 1 (10 items)