SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Enter Data in table and allow some data transfer
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jedistev
Starting Member

Ireland
1 Posts

Posted - 01/18/2010 :  12:00:41  Show Profile  Reply with Quote
Hi

i have look book and Pdf, but cannot find right one, or maybe it don't have one right now

here is example

Create table Vacation.Employee_Details(
EmployeeID INTEGER PRIMARY KEY,
Name VARCHAR (215) ,
Task_Manager VARCHAR (215),
People_Manager VARCHAR (225),
Another VARCHAR (215)

Create table Vacation.request (
Request_ID integer PRIMARY KEY,
EmployeeRequestID integer references Vacation.Employee_Details(EmployeeID),
Name VARCHAR (15),
Date_start DATE,
Date_Finish DATE,
Total_Day VARCHAR (2),
Task_manger VARCHAR (50),
Comments VARCHAR (50),
Notes VARCHAR(50)
);

if i insert into Details on Table Employee Details like

Name Joe Blogg
EmplyeerequestID 5453
Task_manager Mr Men

and there is data on this which auto data gentrated without me put it on data on vacation

EmployeeID 5453
Name Joe Bloggs
Task_Manager Mr Bean

and it on database record,when open Vacation request i will find it there without me add on it but some are blank as well ,so the rest of it all i gotta type down blank
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000