"Agoston Bejo" <gusz1@freemail.hu> wrote in message
news:OppBdMHtEHA.4040@TK2MSFTNGP09.phx.gbl...
> Sorry about posting twice, but I had some trouble with setting the date on
> this machine... :)
>
> I would like to write a stored procedure that takes a table (i.e. table
> variable) as its parameter.
>
> E.g.:
> DECLARE @mytable = TABLE(ID INT, NAME VARCHAR(50))
> SP_MYPROC @mytable
>
> What should SP_MYPROC's signature look like? I can't seem to be able to
find
> anything about this in the documenation.
> I guess it would look something like this:
>
> ALTER PROCEDURE SP_MYPROC
> (@t TABLE)
>
> or
>
> ALTER PROCEDURE SP_MYPROC
> (@t TABLE(ID INT, NAME VARCHAR(50)))
>
> Actually, how big is the freedom when taking such a parameter? Is it
enough
> to use the first version and treat the table whatever way I would like to?
> E.g. not assuming that the 'NAME' column is a VARCHAR(50), but taking
> any tables the second column of which is of type VARCHAR of any size.
>
>
>
>

"Agoston Bejo" <gusz1@freemail.hu> wrote in message
news:OppBdMHtEHA.4040@TK2MSFTNGP09.phx.gbl...
> Sorry about posting twice, but I had some trouble with setting the date on
> this machine... :)
>
> I would like to write a stored procedure that takes a table (i.e. table
> variable) as its parameter.
>
> E.g.:
> DECLARE @mytable = TABLE(ID INT, NAME VARCHAR(50))
> SP_MYPROC @mytable
>
> What should SP_MYPROC's signature look like? I can't seem to be able to
find
> anything about this in the documenation.
> I guess it would look something like this:
>
> ALTER PROCEDURE SP_MYPROC
> (@t TABLE)
>
> or
>
> ALTER PROCEDURE SP_MYPROC
> (@t TABLE(ID INT, NAME VARCHAR(50)))
>
> Actually, how big is the freedom when taking such a parameter? Is it
enough
> to use the first version and treat the table whatever way I would like to?
> E.g. not assuming that the 'NAME' column is a VARCHAR(50), but taking
> any tables the second column of which is of type VARCHAR of any size.
>
>
>
>

"Agoston Bejo" <gusz1@freemail.hu> wrote in message
news:OppBdMHtEHA.4040@TK2MSFTNGP09.phx.gbl...
> Sorry about posting twice, but I had some trouble with setting the date on
> this machine... :)
>
> I would like to write a stored procedure that takes a table (i.e. table
> variable) as its parameter.
>
> E.g.:
> DECLARE @mytable = TABLE(ID INT, NAME VARCHAR(50))
> SP_MYPROC @mytable
>
> What should SP_MYPROC's signature look like? I can't seem to be able to
> find
> anything about this in the documenation.
> I guess it would look something like this:
>
> ALTER PROCEDURE SP_MYPROC
> (@t TABLE)
>
> or
>
> ALTER PROCEDURE SP_MYPROC
> (@t TABLE(ID INT, NAME VARCHAR(50)))
>
> Actually, how big is the freedom when taking such a parameter? Is it
> enough
> to use the first version and treat the table whatever way I would like to?
> E.g. not assuming that the 'NAME' column is a VARCHAR(50), but taking
> any tables the second column of which is of type VARCHAR of any size.
>
>
>
>