To instruct the [!INCLUDE ssDE] to discard query plans for individual queries inside a procedure, use the RECOMPILE query hint in the definition of the query. For more information, see Query Hints ...

The key SQL and technical learnings behind this challenge were being able to understand well the requirements under pressure, finding the transactions flow, correctly joining the right tables, using ...

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, ...

In REST procedures, an SQL deadlock takes place when an SQL query is provided and two similar REST calls are made to the same query. The second call would have to wait for the first one to complete.

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

The ANSI SQL function COALESCE is supported. summary-function is described in summary-function . query-expression is described in query-expression . USER is a literal that references the userid of the ...

Web applications are becoming an important part of our daily life. So attacks against them also increases rapidly. Of these attacks, a major role is held by SQL injection attacks (SQLIA). This paper ...