the semi colon...("the one way run")
Posted: 08 Jan 2010, 11:16
How does one enclose semi colons on the SQL coding like this.
set option escape_character='on'
go
load table blablaba(
[Car_id] '|',
[Money] '|',
[IDTitle_IA] '\x0d\x0a')
from '/shared/data.txt'
escapes off
quotes off
on file error rollback
skip 1
go
set option escape_character='off'
go
(just to let u know that I do create a table before I do this...)
I have a list of SQL statement with semi colons (i.e. ;) and so I just want to run all the scripts in go...
set option escape_character='on'
go
load table blablaba(
[Car_id] '|',
[Money] '|',
[IDTitle_IA] '\x0d\x0a')
from '/shared/data.txt'
escapes off
quotes off
on file error rollback
skip 1
go
set option escape_character='off'
go
(just to let u know that I do create a table before I do this...)
I have a list of SQL statement with semi colons (i.e. ;) and so I just want to run all the scripts in go...