How can I set number of TOP like parameter in procedure e.g.
ALTER PROCEDURE delAuth
@topNr int
AS
DELETE authors
FROM (SELECT TOP @topNr * FROM authors) AS t1
WHERE authors.au_id = t1.au_id
Results 1 to 4 of 4
Thread: Simple Delete SQLHybrid View
|
|
|