rezaei manesh
پنج شنبه 10 اسفند 1385, 13:30 عصر
من چطوربین دستورات اس کیو ال اینتر قرار بدم مثلا کد زیر را نگاه کنید (با اجرا این در روی 2 تا go خطا می ده)
sql = "if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Fridays]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) " _
& " drop table [dbo].[Fridays] " _
& " GO " _
& " CREATE TABLE [dbo].[Fridays] ( " _
& " [FDate] [char] (5) COLLATE Arabic_CI_AS NOT NULL , " _
& " [DayPartInt] [smallint] NULL " _
& " ) ON [PRIMARY] " _
& "GO "
sql = "if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Fridays]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) " _
& " drop table [dbo].[Fridays] " _
& " GO " _
& " CREATE TABLE [dbo].[Fridays] ( " _
& " [FDate] [char] (5) COLLATE Arabic_CI_AS NOT NULL , " _
& " [DayPartInt] [smallint] NULL " _
& " ) ON [PRIMARY] " _
& "GO "