stored procedures

[Lynn]

Hi
Can anyone give me an example of how to create a stored procedure using data view from scratch? Are there any debuggers for stored procedures? I keep getting error messages for my procedures.
Lynn

[Lothar Haensler]

sample:

Create Procedure Helloworld
as
print "Hello,world"




VB 6 comes with a TSQL Debugger - that I have never used... AFAIK it's an Add-In.
You need to have a syntactically correct SP before you can debug it, though.