varbinary(max) field in sql server 2005 problems
in [Programming SQL]
|
From: kunalk on 12 Mar 2010 07:17 CREATE TABLE Upload ( uploadid INT IDENTITY(1,1) PRIMARY KEY, cssid INT NOT NULL FOREIGN KEY REFERENCES CourseSemSub(cssid), teacherid VARCHAR(10) NOT NULL FOREIGN KEY REFERENCES Teacher(teacherid), description VARCHAR(40), video VARBINARY(MAX) NOT NULL ) Unable to create above table , i want to make video field varbinary(max) for holding video files. Other two referenced table exists. From http://www.developmentnow.com/g/113_0_0_0_0_0/sql-server-programming.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/
From: Simon Whale on 12 Mar 2010 07:28 What error message do you get? "kunalk" <kunal2u(a)gmail.com> wrote in message news:c06a7c38-9349-4b02-bf50-2a33e00b3800(a)developmentnow.com... > CREATE TABLE Upload > ( > uploadid INT IDENTITY(1,1) PRIMARY KEY, > cssid INT NOT NULL FOREIGN KEY REFERENCES CourseSemSub(cssid), > teacherid VARCHAR(10) NOT NULL FOREIGN KEY REFERENCES Teacher(teacherid), > description VARCHAR(40), > video VARBINARY(MAX) NOT NULL > ) > > Unable to create above table , i want to make video field varbinary(max) > for holding video files. Other two referenced table exists. > > From > http://www.developmentnow.com/g/113_0_0_0_0_0/sql-server-programming.htm > > Posted via DevelopmentNow.com Groups > http://www.developmentnow.com/g/
From: Andrew J. Kelly on 12 Mar 2010 11:00 Is the database in 80 compatibility mode? -- Andrew J. Kelly SQL MVP Solid Quality Mentors "kunalk" <kunal2u(a)gmail.com> wrote in message news:c06a7c38-9349-4b02-bf50-2a33e00b3800(a)developmentnow.com... > CREATE TABLE Upload > ( > uploadid INT IDENTITY(1,1) PRIMARY KEY, > cssid INT NOT NULL FOREIGN KEY REFERENCES CourseSemSub(cssid), > teacherid VARCHAR(10) NOT NULL FOREIGN KEY REFERENCES Teacher(teacherid), > description VARCHAR(40), > video VARBINARY(MAX) NOT NULL > ) > > Unable to create above table , i want to make video field varbinary(max) > for holding video files. Other two referenced table exists. > > From > http://www.developmentnow.com/g/113_0_0_0_0_0/sql-server-programming.htm > > Posted via DevelopmentNow.com Groups > http://www.developmentnow.com/g/
From: Michael Coles on 14 Mar 2010 00:22 Error message? -- Thanks Michael Coles SQL Server MVP Author, "Expert SQL Server 2008 Encryption" (http://www.apress.com/book/view/1430224649) ---------------- "kunalk" <kunal2u(a)gmail.com> wrote in message news:c06a7c38-9349-4b02-bf50-2a33e00b3800(a)developmentnow.com... > CREATE TABLE Upload > ( > uploadid INT IDENTITY(1,1) PRIMARY KEY, > cssid INT NOT NULL FOREIGN KEY REFERENCES CourseSemSub(cssid), > teacherid VARCHAR(10) NOT NULL FOREIGN KEY REFERENCES Teacher(teacherid), > description VARCHAR(40), > video VARBINARY(MAX) NOT NULL > ) > > Unable to create above table , i want to make video field varbinary(max) > for holding video files. Other two referenced table exists. > > From > http://www.developmentnow.com/g/113_0_0_0_0_0/sql-server-programming.htm > > Posted via DevelopmentNow.com Groups > http://www.developmentnow.com/g/
|
Pages: 1 Prev: Update Trigger Next: Transformation of data into columns |