SQL Script for Stored Procuder Samples
Published on 11/4/2006 by Dotnetindex
|
Vote this tutorial:
|
More articles in ASP
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 |
no comments submitted
Latest Posts
- Create and retrieve cookies
- Easy Error Handling in C#
- Filtering results from database
- Filling Data into Select List
- Working with Array Remove An Item
- Custom Paging in ASP Fast And Easy
- Display Top N records from MS Access
- Using GetRows To Get All Records From Table
- VBScript Functions The Len Function
- Free User Registration Form
- Copying Folders using File System Object
- ArrayList object usage with example
- Using SUM Function in An SQL Statement
- Compacting an Access database from ASP code
- Database Driven Login Script
- Methods of Session Object
- Simple XMLRSS Parser Part-II
- Selecting random record from database
- Image downloading from remote servers in ASP
- How to Encrypt String Using MD5
