SQL Script for Stored Procuder Samples
This sql script creates a sample table to use for some code snipts. First create a database and run this code in Query Analyzer.
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[articles]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[articles]
GO
CREATE TABLE [dbo].[articles] (
[articleID] [int] IDENTITY (1, 1) NOT NULL ,
[headline] [nchar] (255) NULL ,
[publishDate] [datetime] NULL ,
[article] [nvarchar] (4000) NULL ,
[hit] [int] NULL
) ON [PRIMARY]
GO
|
|
Comments:no comments submitted
Only members can write comments.Please,
login /
register to write comment.
Latest Posts