CREATE PROCEDURE Error

#native_company# #native_desc#

#native_cta#

This site is best viewed in a modern browser with JavaScript enabled.

Philosophaie

I am getting a error in the opening 3 lines:

CREATE P*****

Here is my code:

CREATE PROCEDURE [sql1] (@Latin int(4)) 
AS
DECLARE @max int(4), @min int(4), @col3 int(4),@datetime datetime(8);

Thanks in advance.

NogDog

What DBMS are you using?

Philosophaie

NogDog;1310849 wrote:
What DBMS are you using?

1and1 MS SQL

NogDog

ooh...I only have access to MySQL and PostgreSQL, so can't really try it myself.

I'm pretty sure you don't want those square brackets around the procedure name, however?

Khalid_Ali

the code you have in the thread here is incomplete...here is a full example of a stored procedure, which takes 2 parameters (you can add/remove them at will), just follow the syntax

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE proc_myStoredProcName(@variable1 varchar(20),@variable2 int) 

AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from interfering with SELECT statements. u can comment it or delete it if not needed
	SET NOCOUNT ON;
	--your select,update,insert statement below
	SELECT id,user_id,login_time FROM somedatabasename.dbo.user_activity WHERE login_time='this works'
END
GO

Hope this helps..:-)