日期:2014-05-17 浏览次数:20900 次
Select Newid();
GO
Create function dbo.fn(@n int)returns int/*C51634A6-6FA3-45FF-BA76-EC82CEB6A498*/
as
Begin
return @n+1;
End
Select *
From sys.syscacheobjects
Where sql like '%C51634A6-6FA3-45FF-BA76-EC82CEB6A498%'
select dbo.fn(number) as vl
From master..spt_values
Where type = 'P'
And number < 11
---------------------------------------
11074 Compiled Plan Proc 539148966 12 12 1 2 3 2 4347 30 3 0 0 0 0 0 0 216 Create function fn(@n int)returns int/*C51634A6-6FA3-45FF-BA76-EC82CEB6A498*/ as Begin return @n+1; End
14500 Compiled Plan Adhoc 719910009 12 0 -2 2 4 45 4347 30 3 0 0 0 0 0 0 182 Select * From sys.syscacheobjects Where sql like '%C51634A6-6FA3-45FF-BA76-EC82CEB6A498%'