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…