ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Doran <cdo...@pts.com>
Subject Using <sql> task to create SQLServer stored procs
Date Wed, 02 Jul 2003 16:15:26 GMT
Hi All

I've written a build.xml that retrieves several sqlserver scripts from a 
VisualSourceSafe repository. Each of these creates a stored procedure that 
contains microsoft specific wrapper code to drop the stored proc if it 
already exists before recreating it. In essence each script contains 
batches that are separated by the text 'GO'.

Setting the src task delimiter attribute to 'GO' ensures each script runs 
correctly.

However, when I view my stored procs via sqlserver's enterprise manager, 
each stored proc appears as a single line, making it difficult to read.

Any way I can maintain the cr/lf's in the original script files ?

Thanx


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


Mime
View raw message