Error: Incorrect syntax near the keyword as in SQL Server

nedash

SOLVED CLOSED ACTIVE ANSWERED
User: nedash
Posted: on Apr 03, 2017 02:51 AM
Forum: SQL Server
Answer: 1
Views: 2141

Hi I wrote below SP:

Create procedure [dbo].[CountPhone]
@Group1 NVARCHAR(40)
,@Group2 NVARCHAR(40)
as
begin

select count(*) as Phone from PhoneBook  where Group1=@Group1 and Group2=@Group2 as Phone

but this error happen:

Msg 156, Level 15, State 1, Procedure CountPhone, Line 7 c

where is code problem?

Best regards

neda

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Apr 03, 2017 02:52 AM
Report

nedash says:
Create procedure [dbo].[CountPhone]

@Group1 NVARCHAR(40)

,@Group2 NVARCHAR(40)

as

begin

select count(*) as Phone from PhoneBook where Group1=@Group1 and Group2=@Group2 as Phone

Replace with the below procedure.

Create procedure [dbo].[CountPhone]
    @Group1 NVARCHAR(40)
    ,@Group2 NVARCHAR(40)
as
begin 
    select count(*) as Phone from PhoneBook  
    where Group1=@Group1 and Group2=@Group2
end

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Error: Incorrect syntax near the keyword as in SQL Server

Company

Explore

Follow us

Contact Us