
November 12th, 2012, 01:56 AM
|
|
Contributing User
|
|
Join Date: Oct 2012
Posts: 31
Time spent in forums: 4 h 42 sec
Reputation Power: 1
|
|
|
Creating functions
ok guys, i have this code to create a function in SQL Server 2000
CREATE FUNCTION dbo.FncBasicRate (@emp_cde varchar(8))
RETURNS int
AS
BEGIN
declare @return as int;
set @return = select basicrate from employee where emp_cde = @emp_cde
return @return
END
i cant save it, it says 'incorrect syntax near the keyword select'
|