java and mssql

[bdkakde]

How to run following mssql file using jdbc?

PRINT ''
PRINT '############## ############### ############### ############### #######'
PRINT 'Begin Script: DropTables ' + convert(varchar ,current_timest amp)
PRINT ' DB server: ' + @@servername
PRINT ''

BEGIN

DECLARE @user_table VARCHAR(80)


DECLARE
drop_tables CURSOR FOR
SELECT name
FROM sysobjects
WHERE xtype='U' and name not like 'cmi%' and name<>'ERR_CLK' and name<>'TMP_CLK'
ORDER BY name --user table

PRINT ' Checking for any views before dropping tables.'

SELECT s2.name
FROM sysobjects s2, syscomments s1
WHERE (s1.id=s2.id) AND (s2.xtype ='V')
AND (s2.name NOT LIKE 'sys%')
ORDER BY s2.name

IF (@@ROWCOUNT > 0) BEGIN
PRINT ''
PRINT ' ############### ############### ############### ############### ############### ###########'
PRINT ' ### WARNING -> You must drop all user defined views before dropping tables. ###'
PRINT ' ### Tables will not be dropped. ###'
PRINT ' ############### ############### ############### ############### ############### ###########'
PRINT ''

END
ELSE BEGIN

PRINT ''
PRINT 'No Views found, OK to drop tables.'
PRINT ''

OPEN drop_tables
FETCH NEXT FROM drop_tables INTO @user_table

WHILE(@@FETCH_S TATUS=0) BEGIN
PRINT (' ##<INFO>## DROP TABLE ' + @user_table)
EXEC ('DROP TABLE ' + @user_table)
FETCH NEXT FROM drop_tables INTO @user_table
END

CLOSE drop_tables
DEALLOCATE drop_tables
PRINT ''
END

END

PRINT ''
PRINT 'End Script: DropTables ' + convert(varchar ,current_timest amp)
PRINT '############## ############### ############### ############### #######'

GO

[r035198x]

How to run following mssql file using jdbc?

PRINT ''
PRINT '############## ############### ############### ############### #######'
PRINT 'Begin Script: DropTables ' + convert(varchar ,current_timest amp)
PRINT ' DB server: ' + @@servername
PRINT ''

BEGIN

DECLARE @user_table VARCHAR(80)


DECLARE
drop_tables CURSOR FOR
SELECT name
FROM sysobjects
WHERE xtype='U' and name not like 'cmi%' and name<>'ERR_CLK' and name<>'TMP_CLK'
ORDER BY name --user table

PRINT ' Checking for any views before dropping tables.'

SELECT s2.name
FROM sysobjects s2, syscomments s1
WHERE (s1.id=s2.id) AND (s2.xtype ='V')
AND (s2.name NOT LIKE 'sys%')
ORDER BY s2.name

IF (@@ROWCOUNT > 0) BEGIN
PRINT ''
PRINT ' ############### ############### ############### ############### ############### ###########'
PRINT ' ### WARNING -> You must drop all user defined views before dropping tables. ###'
PRINT ' ### Tables will not be dropped. ###'
PRINT ' ############### ############### ############### ############### ############### ###########'
PRINT ''

END
ELSE BEGIN

PRINT ''
PRINT 'No Views found, OK to drop tables.'
PRINT ''

OPEN drop_tables
FETCH NEXT FROM drop_tables INTO @user_table

WHILE(@@FETCH_S TATUS=0) BEGIN
PRINT (' ##<INFO>## DROP TABLE ' + @user_table)
EXEC ('DROP TABLE ' + @user_table)
FETCH NEXT FROM drop_tables INTO @user_table
END

CLOSE drop_tables
DEALLOCATE drop_tables
PRINT ''
END

END

PRINT ''
PRINT 'End Script: DropTables ' + convert(varchar ,current_timest amp)
PRINT '############## ############### ############### ############### #######'

GO

You'll want to read the JDBC totuoral.