external keyword

  • what is external keyword when and where we use it?

    please give example?

  • It's used when creating a CLR function, the reserved word EXTERNAL is part of the reserved phrase "EXTERNAL NAME"

    See books online example from http://msdn.microsoft.com/en-AU/library/ms186755.aspx:

    DECLARE @SamplesPath nvarchar(1024);

    -- You may have to modify the value of this variable if you have

    -- installed the sample in a location other than the default location.

    SELECT @SamplesPath = REPLACE(physical_name, 'Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\master.mdf', 'Microsoft SQL Server\100\Samples\Engine\Programmability\CLR\')

    FROM master.sys.database_files

    WHERE name = 'master';

    CREATE ASSEMBLY [SurrogateStringFunction]

    FROM @SamplesPath + 'StringManipulate\CS\StringManipulate\bin\debug\SurrogateStringFunction.dll'

    WITH PERMISSION_SET = EXTERNAL_ACCESS;

    GO

    CREATE FUNCTION [dbo].[len_s] (@str nvarchar(4000))

    RETURNS bigint

    AS EXTERNAL NAME [SurrogateStringFunction].[Microsoft.Samples.SqlServer.SurrogateStringFunction].[LenS];

    GO

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply