Error Function in Sql Server

Question

Script:

USE Perpustakaan
GO
CREATE FUNCTION com(@id varchar(30), @tipe_item varchar(30))
RETURNS TABLE
AS
RETURN (SELECT left(id_tipe_item,3)+''+left(tipe_item,3)
      FROM tm_tipe_item
      WHERE id_tipe_item = @id and tipe_item = @tipe_item)

result:

Msg 4514, Level 16, State 1, Procedure com, Line 4
CREATE FUNCTION failed because a column name is not specified for column 1.

NJLaPrell · Accepted Answer · 2011-11-07 04:26:30Z

3

Try:

USE Perpustakaan
GO
CREATE FUNCTION com(@id varchar(30), @tipe_item varchar(30))
RETURNS TABLE
AS
RETURN (SELECT left(id_tipe_item,3)+''+left(tipe_item,3) AS MyColumnName
      FROM tm_tipe_item
      WHERE id_tipe_item = @id and tipe_item = @tipe_item)

Note "MyColumnName" and change it as needed.

edited Nov 7, 2011 at 4:26

answered Nov 7, 2011 at 4:23

NJLaPrell

3571 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error Function in Sql Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related