Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query Analyzer message

Status
Not open for further replies.

ddeegan

Programmer
Jun 17, 2002
193
0
0
US
Hello

Is there a way to attach a string to the results message in Query Analyzer?

Example: If I run the statement...

update table set field='Y' where field='N'

Query Analyzer returns...

"(5 row(s) affected)"

How can I get Query Analyzer to return

"(5 row(s) affected) - Update statement for field=Y"

Thanks in advance
Dave


 
Code:
update table set field='Y' where field='N'
print '- Update statement for field=Y"'

[bandito] [blue]DBomrrsm[/blue] [bandito]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top