parameterized query

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 1

In SQL

DECLARE @sql NVARCHAR(1000)

SELECT @sql = 'SELECT * FROM dbo.Tally WHERE N < @N'

EXECUTE sys.sp_executesql @sql, N'@N INT', @N = 4

EXECUTE sys.sp_executesql @sql, N'@N INT', @N = 3

On client side queries like this

SELECT * FROM dbo.Tally WHERE N < ?

Or

SELECT * FROM dbo.Tally WHERE N code block :pinch:[/i]

nabajyoti.b SSCrazy Points: 2177 More actions · Answer 2

SSCrazy

Points: 2177

May 1, 2009 at 4:39 am

and what is a parameterized view?

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 3

SSC-Dedicated

Points: 37301

May 1, 2009 at 4:43 am

A table valued function

nabajyoti.b SSCrazy Points: 2177 More actions · Answer 4

SSCrazy

Points: 2177

May 1, 2009 at 4:47 am

Thanks....

can you give an example?

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 5

BOL topic "CREATE FUNCTION" shows many different examples for "inline table-valued functions" and "multi-statement table-valued functions"