|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
deleting commentsfrom a stored procedure? (see below) (3719 rows afffected) (5 rows afffected) (100 rows afffected) CustomerId Customer ---------------------------- 1 John 2 Fred 3 Mary .... .... .... -- Thank you. Rick use the NOCOUNT option.
Add the following line at the top of your stored procedures. SET NOCOUNT ON -- Show quoteArnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous "Rick" <R***@discussions.microsoft.com> wrote in message news:4BE0F4BA-51BC-41B8-B4DD-E8EAC4172267@microsoft.com... > How can I eliminates comments about the numers of rows affected > from a stored procedure? (see below) > > > (3719 rows afffected) > > (5 rows afffected) > > (100 rows afffected) > > CustomerId Customer > ---------------------------- > 1 John > 2 Fred > 3 Mary > ... > ... > ... > -- > > Thank you. > Rick Thank you Arnie!
-- Show quoteRick "Arnie Rowland" wrote: > use the NOCOUNT option. > > Add the following line at the top of your stored procedures. > > SET NOCOUNT ON > > > -- > Arnie Rowland, Ph.D. > Westwood Consulting, Inc > > Most good judgment comes from experience. > Most experience comes from bad judgment. > - Anonymous > > > "Rick" <R***@discussions.microsoft.com> wrote in message news:4BE0F4BA-51BC-41B8-B4DD-E8EAC4172267@microsoft.com... > > How can I eliminates comments about the numers of rows affected > > from a stored procedure? (see below) > > > > > > (3719 rows afffected) > > > > (5 rows afffected) > > > > (100 rows afffected) > > > > CustomerId Customer > > ---------------------------- > > 1 John > > 2 Fred > > 3 Mary > > ... > > ... > > ... > > -- > > > > Thank you |
|||||||||||||||||||||||