Execute SQL Server scripts - Revision history

Zippy1981: Discussed SQL Server 2005 and later

2012-03-23T15:16:46Z

Discussed SQL Server 2005 and later

â† Older revision		Revision as of 15:16, 23 March 2012
Line 33:		Line 33:
	ClearErrors		ClearErrors
	</highlight-nsis>		</highlight-nsis>

			== SQL Server 2005 and later ==

			SQL Server 2005 replaced isql and osql with sqlcmd. I discuss a solution for these versions of SQL Server on [http://stackoverflow.com/a/9841682/95195 this stackoverflow answer].

	[[Category:Database Functions]]		[[Category:Database Functions]]

2010-05-06T09:52:35Z

Description

â† Older revision		Revision as of 09:52, 6 May 2010
Line 3:		Line 3:
	== Description ==		== Description ==
	With SQL Server 2000...a little bit untidy at present. This executes the script and dumps the output in the detail window. Todo: only dump the output if there's errors (and thats why I use '-b')		With SQL Server 2000...a little bit untidy at present. This executes the script and dumps the output in the detail window. Todo: only dump the output if there's errors (and thats why I use '-b')
	~~xcvbxcbxcb~~
	~~nbvnmn~~
	~~cvmnbmc~~
	~~ncvmn.,b~~
	~~ccvmn.c,vmn~~
	~~.vcmnc.v,n~~
	~~cncv,mn.cvn~~
	~~cncv.,mn~~

	== The Script ==		== The Script ==

2010-05-06T09:51:41Z

Description

â† Older revision		Revision as of 09:51, 6 May 2010
Line 3:		Line 3:
	== Description ==		== Description ==
	With SQL Server 2000...a little bit untidy at present. This executes the script and dumps the output in the detail window. Todo: only dump the output if there's errors (and thats why I use '-b')		With SQL Server 2000...a little bit untidy at present. This executes the script and dumps the output in the detail window. Todo: only dump the output if there's errors (and thats why I use '-b')
			xcvbxcbxcb
			nbvnmn
			cvmnbmc
			ncvmn.,b
			ccvmn.c,vmn
			.vcmnc.v,n
			cncv,mn.cvn
			cncv.,mn

	== The Script ==		== The Script ==

2010-01-28T09:46:26Z

Reverted edits by 94.27.104.213 to last version by 80.84.114.148

â† Older revision		Revision as of 09:46, 28 January 2010
Line 4:		Line 4:
	With SQL Server 2000...a little bit untidy at present. This executes the script and dumps the output in the detail window. Todo: only dump the output if there's errors (and thats why I use '-b')		With SQL Server 2000...a little bit untidy at present. This executes the script and dumps the output in the detail window. Todo: only dump the output if there's errors (and thats why I use '-b')

	~~;Jora podimi jakor~~
	== The Script ==		== The Script ==
	<highlight-nsis>		<highlight-nsis>

2010-01-27T11:21:16Z

The Script

â† Older revision		Revision as of 11:21, 27 January 2010
Line 4:		Line 4:
	With SQL Server 2000...a little bit untidy at present. This executes the script and dumps the output in the detail window. Todo: only dump the output if there's errors (and thats why I use '-b')		With SQL Server 2000...a little bit untidy at present. This executes the script and dumps the output in the detail window. Todo: only dump the output if there's errors (and thats why I use '-b')

			;Jora podimi jakor
	== The Script ==		== The Script ==
	<highlight-nsis>		<highlight-nsis>

2008-10-06T15:16:41Z

The Script

â† Older revision		Revision as of 15:16, 6 October 2008
Line 13:		Line 13:
	"ComputerName"		"ComputerName"
	GetTempFileName $R0		GetTempFileName $R0
	ExecWait '"$R1\Binn\isql.exe" -U "some-username" -P "some-password" -s "$R2" -d master		ExecWait '"$R1\Binn\isql.exe" -U "some-username" -P "some-password" -S "$R2" -d master
	-i "some-file.sql" -o "$R0" -b'		-i "some-file.sql" -o "$R0" -b'

2007-11-21T18:20:21Z

â† Older revision		Revision as of 18:20, 21 November 2007
Line 7:		Line 7:
	<highlight-nsis>		<highlight-nsis>
	; path to the sql command line tools		; path to the sql command line tools
	ReadRegStr $R1 HKLM "SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup" "SQLPath"		ReadRegStr $R1 HKLM "SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup"
			"SQLPath"
	; the computer name. obviously you can prompt for a host		; the computer name. obviously you can prompt for a host
	ReadRegStr $R2 HKLM "SYSTEM\CurrentControlSet\Control\ComputerName\ComputerName" "ComputerName"		ReadRegStr $R2 HKLM "SYSTEM\CurrentControlSet\Control\ComputerName\ComputerName"
			"ComputerName"
	GetTempFileName $R0		GetTempFileName $R0
	ExecWait '"$R1\Binn\isql.exe" -U "some-username" -P "some-password" -s "$R2" -d master		ExecWait '"$R1\Binn\isql.exe" -U "some-username" -P "some-password" -s "$R2" -d master
	-i "some-file.sql" -o "$R0" -b'		-i "some-file.sql" -o "$R0" -b'

	ClearErrors		ClearErrors

2007-11-21T18:18:11Z

â† Older revision		Revision as of 18:18, 21 November 2007
Line 11:		Line 11:
	ReadRegStr $R2 HKLM "SYSTEM\CurrentControlSet\Control\ComputerName\ComputerName" "ComputerName"		ReadRegStr $R2 HKLM "SYSTEM\CurrentControlSet\Control\ComputerName\ComputerName" "ComputerName"
	GetTempFileName $R0		GetTempFileName $R0
	ExecWait '"$R1\Binn\isql.exe" -U "some-username" -P "some-password" -s "$R2" -d master -i "some-file.sql" -o "$R0" -b'		ExecWait '"$R1\Binn\isql.exe" -U "some-username" -P "some-password" -s "$R2" -d master
			-i "some-file.sql" -o "$R0" -b'

	ClearErrors		ClearErrors

2005-06-24T12:10:25Z

Adding new author and category links.

â† Older revision		Revision as of 12:10, 24 June 2005
Line 1:		Line 1:
	{~~\|align=right~~		{{PageAuthor\|bazzargh}}
	~~\|<small>Author: [[~~{~~{ns:2}}:bazzargh~~\|bazzargh~~]] ([[{{ns:3}}:bazzargh\|talk]], [[{{ns:-1}~~}~~:Contributions/bazzargh\|contrib]])</small>~~
	\|}
	~~<br style="clear:both;">~~
	== Description ==		== Description ==
	With SQL Server 2000...a little bit untidy at present. This executes the script and dumps the output in the detail window. Todo: only dump the output if there's errors (and thats why I use '-b')		With SQL Server 2000...a little bit untidy at present. This executes the script and dumps the output in the detail window. Todo: only dump the output if there's errors (and thats why I use '-b')
Line 33:		Line 31:
	</highlight-nsis>		</highlight-nsis>

	[[~~{{ns:14}}~~:Database Functions]]		[[Category:Database Functions]]

2005-04-30T22:00:50Z

Added category links.