Incercati urmatorul cod si link-urile de mai jos (codul va arata cum iar link-urile cum si de ce):

USE AdventureWorks;
GO
DECLARE @template_text NVARCHAR(MAX)
DECLARE @parameters NVARCHAR(MAX)
EXEC sp_get_query_template
    N'SELECT * FROM Person.Contact WHERE ContactID = 1;',
@template_text OUTPUT,
@parameters OUTPUT;
SELECT @template_text AS [template text];
SELECT @parameters AS [parameters];

-- Ouput:

template text
---------------------------------------------------
select * from Person . Contact where ContactID = @0

(1 row(s) affected)

parameters
----------------------------------------------------
@0 int

(1 row(s) affected)

Link-uri:

1. sp_get_query_template 
2. Forcing Query Plans

 

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro