Ask - how to handle this error

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Ask

Ask questions, discuss or help others by answering


	Ask a question


	Subscribe..

how to handle this error

Aug 15 2012 12:00AM by niya

While executing this code

USE [master]

/****** Object: Table [dbo].[ipaddr] Script Date: 08/12/2012 22:29:54 ******/

SET ANSI_NULLS OFF

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[ipaddr](

[sip] [char(100)] NOT NULL,

[l1ip] [char(100)] NOT NULL,

[l2ip] [char(100)] NOT NULL

) ON [PRIMARY]

CREATE TABLE [dbo].[login](

[username] [char(100)] NOT NULL,

[pwd] [char(100)] NOT NULL,

) ON [PRIMARY]

CREATE TABLE [dbo].[register](

[username] [char(100)] NOT NULL,

[pwd] [char(100)] NOT NULL,

[addr] [char(100)] NOT NULL,

[phone] [char(100)] NOT NULL,

[email] [char(100)] NOT NULL

) ON [PRIMARY]

CREATE TABLE [dbo].[up](

[did] [char(100)] NOT NULL,

[loc] [char(100)] NOT NULL

) ON [PRIMARY]

following error encountered

Msg 2715, Level 16, State 7, Line 1

Column, parameter, or variable #1: Cannot find data type var(100).

Msg 2715, Level 16, State 7, Line 1

Column, parameter, or variable #1: Cannot find data type var(100).

Msg 2715, Level 16, State 7, Line 1

Column, parameter, or variable #1: Cannot find data type var(100).

Msg 2715, Level 16, State 7, Line 1

Column, parameter, or variable #1: Cannot find data type var(100).

plz give the solution to get out of this

Submitted under: Microsoft SQL Server · TSQL · · ·

Previous: Extract Attribute In XML result
Next: what is the role of ssl layer in cloud computing

niya

514 · 0% · 71

2 Replies

The error is caused by the square brackets you placed around the data type. Change your code from:

CREATE TABLE [dbo].[ipaddr](
	[sip] [char(100)] NOT NULL,
	[l1ip] [char(100)] NOT NULL,
	[l2ip] [char(100)] NOT NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[ipaddr](
	[sip] char(100) NOT NULL,
	[l1ip] char(100) NOT NULL,
	[l2ip] char(100) NOT NULL
) ON [PRIMARY]

and it will work. It is also correct to write as follows.

CREATE TABLE [dbo].[ipaddr](
	[sip] [char](100) NOT NULL,
	[l1ip] [char](100) NOT NULL,
	[l2ip] [char](100) NOT NULL
) ON [PRIMARY]

commented on Aug 16 2012 6:14AM

Jacob Sebastian

1 · 100% · 32002

thanks sir...

commented on Aug 18 2012 1:09AM

niya

514 · 0% · 71

Your Reply

Sign Up or Login to post a comment.