To understand which features in an existing interpreted T-SQL stored procedure are supported in natively compiled stored procedures, we recommend using the Native Compilation Advisor, which is part of ...

Many times during sql server development we need to search for a stored procedure containing a specific text. this helps in checking for dependencies for objects in stored procedures or sometimes we ...

In this blog we illustrate how to get the pagination data from SQL server stored procedure. To create a such type of a stored procedure, we need to send a minimum three parameters (startRowIndex, ...

Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do.

[!INCLUDE SQL Server Azure SQL Database PDW] This article describes how to recompile a stored procedure in [!INCLUDE ssnoversion] by using [!INCLUDE tsql]. There are three ways to do this: WITH ...

-- because it allows the entire procedure definition to be passed to the server as a single statement. -- The delimiter is temporarily changed so that semicolons can be used within the stored ...

The extended stored procedure xp_ndo_enumusersids in the library file xp_ndo.dll, is not available on the LOHNDORF1 server. Until this procedure and library have been added, it will not be possible to ...