script sql prblem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

script sql prblem

Author

Topic

somsahi
Starting Member

23 Posts

Posted - 2006-09-13 : 16:59:11

Hi I have this sql file
problems
1)what is this par here

2)it is giving syntax error (probabaly due to semi colon at the end)
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fcharset0 Arial;}}
{\*\generator Msftedit
5.41.15.1507;}\viewkind4\uc1\pard\f0\fs20 CREATE OR ALTER
TABLE user \par
\tab regi_hu_g_code char(11) NOT NULL,\par
\tab tot_expe number(9) DEFAULT 0,\par
\tab tong number(9) DEFAULT 0,\par
\tab tol_expected number(9) DEFAULT 0,\par
\tab perc_acccy number(9,2) DEFAULT 0,\par
\tab created_by varchar2(8) NOT NULL\par
\tab created_time timestamp NOT NULL\par
\tab upf varchar2(8) NOT NULL\par
\tab up timestamp NOT NULL\par
)
\par
\par
\par
};

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-09-13 : 17:03:59

This doesn't look like SQL Server to me. What dbms is this?

Tara Kizer

somsahi
Starting Member

23 Posts

Posted - 2006-09-13 : 17:06:41

this is the file which is going tobe run on telnet

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-09-13 : 17:10:02

So your question isn't SQL Server related? If not, then I'd suggest posting your question on a site that deals with whatever database this is as you've reached a SQL Server site.

Tara Kizer

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2006-09-14 : 16:02:20

Tara,

The posted "code" is actually rich-text formatted (RTF).

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources