Inserting PictureNames as ID

[hykyit]

Hi,

I am working on a part where i use Store Procedures to Insert rows into a table (adding a new employee, to be precise).. The thing is, I am auto incrementing the ID field and there is a field where the picture name will be stored.. I am having problem trying to save the picture name same with the ID..Here is my stored procedure:

-- My Employees table has three fields (ID, name, picture)
CREATE PROCEDURE insertEmployeeDetails(@name varchar(50), @salaryApplied DateTime, @salaryLevel int)
AS
    INSERT INTO Employees VALUES (@name, convert(varchar, @@IDENTITY) + '.jpg');
    SET @id = @@IDENTITY
    INSERT INTO Salaries VALUES (@id, @salaryApplied, @salaryLevel); 
 

It seems that my picture name is always saved as NULL and I cant figure it out.. Can some one help me out here?? Thanks!

[aplus]

Hi,

I am working on a part where i use Store Procedures to Insert rows into a table (adding a new employee, to be precise).. The thing is, I am auto incrementing the ID field and there is a field where the picture name will be stored.. I am having problem trying to save the picture name same with the ID..Here is my stored procedure:

-- My Employees table has three fields (ID, name, picture)
CREATE PROCEDURE insertEmployeeDetails(@name varchar(50), @salaryApplied DateTime, @salaryLevel int)
AS
    INSERT INTO Employees VALUES (@name, convert(varchar, @@IDENTITY) + '.jpg');
    SET @id = @@IDENTITY
    INSERT INTO Salaries VALUES (@id, @salaryApplied, @salaryLevel); 
 

It seems that my picture name is always saved as NULL and I cant figure it out.. Can some one help me out here?? Thanks!

.


Change the code as follows

CREATE PROCEDURE insertEmployeeDetails(@name varchar(50), @salaryApplied DateTime, @salaryLevel int)
AS
INSERT INTO Employees VALUES (@name);
SET @id = @@IDENTITY

UPDATE Employees set picture = CAST(@id AS VARCHAR) + '.jpg' WHERE Employees.ID = @id


INSERT INTO Salaries VALUES (@id, @salaryApplied, @salaryLevel);
[/code]

- Ankit

[hykyit]

It worked! Thanks a lot for the help!! Really appreciate it!!