sql server (alternate): [scripts] prompting user -- sql server (alternate)

Re: prompting user

othellomy NO[at]SPAM yahoo.com
12/21/2006 9:14:26 PM

Sql is 4gl and asking it to do 3gl operations like prompts and loops
and if then else logic should be illegal although now allowed.

[quoted text, click to view]

Re: [scripts] prompting user

Erland Sommarskog
12/21/2006 11:00:22 PM

fireball (fireball@onet.kropka.eu) writes:
[quoted text, click to view]

The answer is you don't. SQL Server is a server application, and
server applications communicate with client applications, not with
end users.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at

Re: prompting user

Erland Sommarskog
12/28/2006 12:00:00 AM

fireball (fireball@onet.kropka.eu) writes:
[quoted text, click to view]

Depends on how run it. In SQLCMD or OSQL you can exit immediately
by using a RAISERROR with state 127:

RAISERROR('Got a good reson for taking the easy way out now', 16, 127)

This does not work from Query Analyzer or Mgmt Studio.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at

Re: prompting user

othellomy NO[at]SPAM yahoo.com
12/28/2006 2:27:34 AM

[quoted text, click to view]

Do you want a return code or not? If you don't want a return code
then you can wirite:
If <condition> Return
If you want a return code then you need to use a stored proc and inside
the procedure you can write:
If <condition> return 100
In your application you can check for status of the called procedure
and take action based on that.

Re: prompting user

fireball
12/28/2006 10:35:56 AM

well,
is that possible at least, to exit script on given condition?

Re: prompting user

fireball
12/29/2006 4:37:51 PM

Uzytkownik "Erland Sommarskog" <esquel@sommarskog.se> napisal w wiadomosci
[quoted text, click to view]

Uzytkownik <othellomy@yahoo.com> napisal w wiadomosci
[quoted text, click to view]

all this hepled.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server (alternate) group.