faramarz_s
جمعه 26 دی 1382, 22:01 عصر
برای اینکه داده ای را در دیتابیسی به صورت زیر اینزرت کنیم چه تغییراتی باید در کوئری بدهم؟
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[image]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[image]
GO
CREATE TABLE [dbo].[image] (
[img_pk] [int] NOT NULL ,
[img_name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[img_data] [image] NULL ,
[img_contenttype] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
INSERT INTO Image (img_pk,img_name,img_data,img_contenttype)" +
" VALUES (@img_pk, @img_name, @img_data,@img_contenttype )"+
" WHERE img_pk =3"
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[image]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[image]
GO
CREATE TABLE [dbo].[image] (
[img_pk] [int] NOT NULL ,
[img_name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[img_data] [image] NULL ,
[img_contenttype] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
INSERT INTO Image (img_pk,img_name,img_data,img_contenttype)" +
" VALUES (@img_pk, @img_name, @img_data,@img_contenttype )"+
" WHERE img_pk =3"