sql.snippet.BuildExectionSummaryEnd

PHOTO EMBED

Sun Feb 06 2022 14:29:28 GMT+0000 (UTC)

Saved by @rick_m #sql

<?xml version="1.0" encoding="utf-8"?>
<CodeSnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">
  <CodeSnippet Format="1.0.0">
    <Header>
      <Title>bese - BuildExectionSummaryEnd</Title>
      <Description>execution plan end</Description>
      <Author>Rick M</Author>
      <Shortcut />
      <SnippetTypes>
        <SnippetType>Expansion</SnippetType>
      </SnippetTypes>
    </Header>
    <Snippet>
      <Code Language="SQL"><![CDATA[
endofscript:

PRINT '--------------------------------------------------';
PRINT ' ';
PRINT 'elapsed time '+CONVERT(VARCHAR, GETDATE() - @started, 108);
PRINT ' ';
PRINT 'completed '+CONVERT(VARCHAR, GETDATE(), 108);
PRINT ' ';
PRINT '--------------------------------------------------';
PRINT '--------------------------------------------------';
PRINT '--------------------------------------------------';
]]></Code>
    </Snippet>
  </CodeSnippet>
</CodeSnippets>
content_copyCOPY