CODEWITHSUNDEEP
sql-servert-sqlstored-procedures
Ammar Asjad
Ammar Asjad

Reputation: 3000

SQL Server stored procedure for getting rows from table

I am trying to create a stored procedure to retrieve rows from my database table... but it looks like I am missing some thing while typing query.

Here is my stored procedure:

CREATE PROCEDURE [dbo].[p_GetLeaveRecord_LMS]
    -- Add the parameters for the stored procedure here
    @LeaveType varchar(50),
    @IdEmployee int,
    @DateFrom date,
    @DateTo date,
    @Reason nvarchar(MAX)
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    SElECT * FROM cor_leave
    (
    id_leave_type,
    id_employee,
    dt_from,
    dt_to,
    txt_reason
    )
    Values 
    (
    @LeaveType,
    @IdEmployee,
    @DateFrom,
    @DateTo,
    @Reason
    )      
END

If anyone can give me better answer to make procedure correct.

I am very beginner of database.

thanks

Upvotes: 0

Views: 3456

Answers (2)

Kamal Deepak
Kamal Deepak

Reputation: 221

SELECT @LeaveType=id_leave_type, @IdEmployee`=id_employee,@DateFrom=dt_from,@DateTo=dt_to,@Reason=txt_reason FROM cor_leave

Upvotes: 2

Oded
Oded

Reputation: 498914

Your select statement is not valid SQL. It looks more like a modified INSERT statement.

It should be:

SELECT 
  id_leave_type,
  id_employee,
  dt_from,
  dt_to,
  txt_reason
FROM cor_leave

Upvotes: 2

Related Questions