Database

Vuyiswa wrote:

Msg 512, Level 16, State 1, Line 6Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.The statement has been terminated.Warning: Null value is eliminated by an aggregate or other SET operation.(0 row(s) affected)

Arun Krishnan wrote:

-when i insert values into name & age of EMPDETAILS
table, the values r inserted with NULL values for empid
field.

Arun Krishnan wrote:

2.How can i insert values into empid of EMPDETAILS table & LOGIN table at the same time,without using IDENTITY constraint????.......
-empid in LOGIN table s d primary key & in EMPDETAILS s d foreign key.
- i have to insert a string value for empid

Arun Krishnan wrote:

-thr s a table EMPDETAILS with columns empid,name,age
-empid in EMPDETAILS foreign key references empid in
LOGIN table.
-LOGIN table has some data.
-when i insert values into name & age of EMPDETAILS
table, the values r inserted with NULL values for empid
field.
How can i solve this?????

Arun Krishnan wrote:

How can i insert values into empid of EMPDETAILS table & LOGIN table at the same time,without using IDENTITY constraint????.......
-empid in LOGIN table s d primary key & in EMPDETAILS s d foreign key.
- i have to insert a string value for empid

 Alter table EMPDETAILS (Alter column EMPID NOT NULL)
 ALter table EMPDETAILS ADD CONSTRAINT FK_LOGIN FOREIGN_KEY (EMPID) references LOGIN (EMPID)

  Create a stored procedure for the combined insert: 
  (use appropriate types and sizes for your tables,
  this is just an example of how, hot a solution)
Create procedure AddNewEMPID (@Empid nvarchar (20), @name nvarchar(20), @age int, @loginstuff1 varchar(10),...,@loginstuffN int)
as
begin 
 insert into login (empid, lofinstuff1,...loginstuffN) values (@empid, @loginstuff1,...,@loginstuffN);
 insert into EMPDETAILS(empid,name,age) values (@empid, @name,@age);
end

exec AddNewEMPID 'empidstring','l1,...,'ln', 'name','age'

.NET- India wrote:

So how can we say that a Delete can be rolled back but a truncate cannot be......