Can I write insert query in Function like following query?

CREATE FUNCTION myProc1(@ID Int,@name varchar(20),@salary money,@start_date datetime)
RETURNS Table
AS
RETURN
(
insert into employ(ID, name, salary, start_date) values (@ID,@name,@salary,@start_date)
)
GO


Thanks and Regards ,


Sarwarao Chakka
Aspire Systems || India
Tel:+91 -44-67404000
www.aspiresys.com






This e-mail message and any attachments are for the sole use of the intended recipient(s) and may contain proprietary, confidential, trade secret or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited and may be a violation of law. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

MS Sql Server LazyDBA home page