Question : I have a bunch of LU tables that have values added and deleted all the time. Therefore, I […]
Tag: parameter
varray size can be a variable?
Question : I need to create a varray, and its size must be a parameter of the procedure, for example […]
Select roads that are between FROM and TO
Question : I have a road table: create table road (road_id int, name_ nvarchar2(15), from_ nvarchar2(15), to_ nvarchar2(15), sort int […]
SQL SERVER dynamic Query with Like Statement for null values
Question : I’m trying to execute a SQL dynamic query with nullable parameters using LIKE. If the parameter has a […]
reading input parameter values in stored procedures
Question : I’m using the current version of MariaDB 10.0.12 . I created a stored procedure as specified in the […]
Parameter Sniffing: Why Does This Become An Issue?
Question : Today, I had an issue with a stored procedure timing out (took longer than 30 seconds) when it […]
SQL Linked Server Passing Date Parameters
Question : I’m using SQL Server 2008 R2 and have a linked SQL 2012 Express database. On the 2008 box […]
Forced Parameterization and CASE statements
Question : We have an application which uses an ORM which does not (easily) support parameterized queries. To combat this, […]
Is there a symbol I can use to have a where clause match all columns?
Question : I’m using sql parameter’s and I have a query that I’d like to use for two similar queries. […]
How to get the function name of a regprocedure in PostgreSQL?
Question : I’m trying to write a function to get the name of the function associated with a given regprocedure […]