Advertisement

04.14.2008 at 10:41PM PDT, ID: 23322727
[x]
Attachment Details

Stored procedure : return count

Asked by vbturbo in MS SQL Server, Microsoft Visual C#.Net, .Net Editors & IDEs

Hi

im trying to return the count in this stored procedure but i keep an "incorrect syntax near the keyword AS"

what am i missing ?

CREATE PROCEDURE dbo.Upload_validate_token_existance_select

@guid uniqueidentifier = null,

AS

Set nocount on

if not @guid is null
begin
SELECT COUNT (*)FROM uploadRekvisitioner WHERE guid = @guid
end
return

GO

thanksStart Free Trial
[+][-]04.14.2008 at 10:45PM PDT, ID: 21356189

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL Server, Microsoft Visual C#.Net, .Net Editors & IDEs
Sign Up Now!
Solution Provided By: ee_rlee
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_EXPERT_20070906