sql.snippet.BuildExecutionSummary

PHOTO EMBED

Sun Feb 06 2022 14:27:07 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>bess - BuildExecutionSummary</Title>
      <Description>execution plan start</Description>
      <Author>Rick M</Author>
      <Shortcut />
      <SnippetTypes>
        <SnippetType>Expansion</SnippetType>
      </SnippetTypes>
    </Header>
    <Snippet>
      <Code Language="SQL"><![CDATA[
PRINT '--------------------------------------------';
PRINT '--Execution Summary-------------------------';
PRINT '--------------------------------------------';
PRINT '
-  
';
PRINT '--------------------------------------------';
PRINT '--END Execution Summary---------------------';
PRINT '--------------------------------------------';
PRINT '--------------------------------------------------';
PRINT '--------------------------------------------------';
PRINT '--------------------------------------------------';
DECLARE
       @started          DATETIME
     , @step             INT
     , @stepdescription  VARCHAR(500)
	 , @executionsummary VARCHAR(max);

SET @started = GETDATE();
SET @step = 1;
SET @stepdescription='';
SET @executionsummary='';
PRINT 'started '+CONVERT(VARCHAR, @started, 108);

PRINT ' ';
PRINT '--------------------------------------------------';


]]></Code>
    </Snippet>
  </CodeSnippet>
</CodeSnippets>
content_copyCOPY