Skip to content

Commit 14f98f9

Browse files
author
Schneider
committed
create-procedure-transact-sql: fix typo
1 parent fcab2d0 commit 14f98f9

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

docs/t-sql/statements/create-procedure-transact-sql.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -350,7 +350,7 @@ See [Examples](#Examples) towards the end of this topic for many more examples.
350350
## Best Practices
351351
Although this is not an exhaustive list of best practices, these suggestions may improve procedure performance.
352352

353-
- Use the SET NOCOUNT ON statement as the first statement in the body of the procedure. That is, place it just after the AS keyword. This turns off messages that [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] sends back to the client after any SELECT, INSERT, UPDATE, MERGE, and DELETE statements are executed. This keeps the output generated to a minumum for clarity. There is no measurable performance benefit however on todays hardware. For information, see [SET NOCOUNT (Transact-SQL)](../../t-sql/statements/set-nocount-transact-sql.md).
353+
- Use the SET NOCOUNT ON statement as the first statement in the body of the procedure. That is, place it just after the AS keyword. This turns off messages that [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] sends back to the client after any SELECT, INSERT, UPDATE, MERGE, and DELETE statements are executed. This keeps the output generated to a minimum for clarity. There is no measurable performance benefit however on today's hardware. For information, see [SET NOCOUNT (Transact-SQL)](../../t-sql/statements/set-nocount-transact-sql.md).
354354

355355
- Use schema names when creating or referencing database objects in the procedure. It takes less processing time for the [!INCLUDE[ssDE](../../includes/ssde-md.md)] to resolve object names if it does not have to search multiple schemas. It also prevents permission and access problems caused by a user's default schema being assigned when objects are created without specifying the schema.
356356

0 commit comments

Comments
 (0)