>ho una sp (stored procedure) che ha 2 parametri di input si tipo
>smalldatetime. Come faccio ad assegnargli, a detti parametri,
>dei valori predefiniti ?
>
>Ossia
>
>CREATE mySP
>@p1 smalldatetime = data1,
>@p2 smalldatetime = data2
>AS
>.... ecc ecc
Esatto, devi fare proprio così
USE tempdb;
GO
CREATE PROCEDURE dbo.mySP
@p1 smalldatetime = '20100201',
@p2 smalldatetime = '20100222'
AS
SELECT @p1 AS P1, @p2 AS P2;
GO
EXEC dbo.mySP;
/* Output:
P1 P2
----------------------- -----------------------
2010-02-01 00:00:00 2010-02-22 00:00:00
(1 row(s) affected)
*/
EXEC dbo.mySP '20100101', '20100102';
/* Output:
P1 P2
----------------------- -----------------------
2010-01-01 00:00:00 2010-01-02 00:00:00
(1 row(s) affected)
*/
DROP PROCEDURE dbo.mySP;
>Grazie
Prego.
Ciao!
--
Lorenzo Benaglia
Microsoft MVP - SQL Server
http://blogs.dotnethell.it/lorenzo/
http://italy.mvps.org