www.pudn.com > dblib_souce.rar > createDemo.sql

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[test_dblib]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) 
drop table [dbo].[test_dblib] 
GO 
 
CREATE TABLE [dbo].[test_dblib] ( 
	[ch] 	[char] 		(10) NULL , 
	[vch] 	[varchar] 	(50) NULL , 
	[nch] 	[nchar] 	(10) NULL , 
	[_int] 	[int] 		NULL , 
	[_bit] 	[bit] 		NULL , 
	[_dec] 	[decimal]	(18, 4) NULL , 
	[_num] 	[numeric]	(18, 2) NULL , 
	[_mon] 	[money] 	NULL , 
	[_flt] 	[float] 	NULL , 
	[_sint] [smallint] 	NULL , 
	[_smon] [smallmoney] 	NULL , 
	[_real] [real] 		NULL , 
	[_txt] 	[text] 		NULL , 
	[_tint] [tinyint] 	NULL , 
	[_date] [datetime] 	NULL , 
	[_nvch] [nvarchar] 	(50) NULL , 
	[_sdate] [smalldatetime] NULL  
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] 
GO