<?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>