Information générale
Forum:
Microsoft SQL Server
Hi Mike,
Good eyes!
Thanks
Jim
>You're missing a closing paren on the CREATE TABLE statement.
>
>-Mike
>
>>Hello Group,
>>
>>I am getting an error near Insert. What have I done wrong.
>>
>>CREATE PROCEDURE cissetschoolyear
>>(@Schoolyear INT)
>> AS
>>/****** Object: Table dbo.schoolyear Script Date: 7/15/2002 2:33:01 PM ******/
>>if exists (select * from sysobjects where id = object_id('dbo.schoolyear') and sysstat & 0xf = 3)
>> BEGIN
>>
>> DELETE Schoolyear
>>
>> INSERT INTO dbo.Schoolyear (schoolyear)
>> VALUES(@Schoolyear)
>> END
>>
>>ELSE
>>
>> BEGIN
>> /****** Object: Table dbo.schoolyear Script Date: 7/15/2002 2:33:01 PM ******/
>> CREATE TABLE dbo.schoolyear (
>> schoolyear decimal(5, 0) NOT NULL
>>
>> INSERT INTO dbo.Schoolyear (schoolyear)
>> VALUES(@Schoolyear)
>> END
>>
>>Thanks
>>Jim
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement