| Stored Proc code. CREATE PROCEDURE spReturnArticleID as SELECT max(articleId) FROM articleInfo RETURN GO Table Code CREATE TABLE [dbo].[articleInfo] ( [articleId] [int] NOT NULL , [catID] [int] NOT NULL, [typeID] [int] NOT NULL, [fpTitle] [varchar] (255), [fpMessage] [varchar] (8000), [titleOfDemo] [varchar] (255), [href] [varchar] (150), [demoLink] [varchar] (255), [downloadLink] [varchar] (255), [dateSubmitted] [datetime] NULL, [dateUpdated] [datetime] NULL, [authorId] [int] NULL, [active] [bit] NOT NULL, [pageHits] [int] NULL, [fileName] [varchar] (150), [filePath] [varchar] (50), [fileCreated] [datetime] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[articleInfo] WITH NOCHECK ADD CONSTRAINT [DF_tblWhatsNew_new_Active] DEFAULT (1) FOR [active], CONSTRAINT [PK_tblWhatsNew_new] PRIMARY KEY NONCLUSTERED ( [articleId] ) WITH FILLFACTOR = 90 ON [PRIMARY] GO
| 
developerWorks - FREE Tools!