Questions tagged [parameter-spoofing]
3 questions
65
votes
8 answers
Parameter Sniffing (or Spoofing) in SQL Server
A while ago I had a query that I ran quite a lot for one of my users. It was still being evolved and tweaked but eventually it stablised and ran quite quickly, so we created a stored procedure from it.
So far, so normal.
The stored procedure,…

Unsliced
- 10,404
- 8
- 51
- 81
2
votes
1 answer
Are selectOne and selectMany choices bounded by SelectItems?
Do the JSF selectOne and selectMany controls only allow submission of values defined in the given selectItems? I'm concerned about parameter spoofing, and if this was built-in, I wouldn't require a validator to ensure the selected value was one of…

InverseFalcon
- 4,826
- 1
- 16
- 5
0
votes
0 answers
SQL Server 2014 - not getting value from scalar valued function with Custom Table type parameter sent to stored procedure
I have a table type like this:
CREATE TYPE [dbo].[TT_CustomType] AS TABLE
(
[Month] [int] NULL,
[Year] [int] NULL,
[CountryId] [int] NULL,
[BranchId] [int] NULL
)
From a stored procedure, I am creating a variable of this type and…

captainsac
- 2,484
- 3
- 27
- 48