Create Procedure Command

Good morning,
The Transact-SQL Reference documentation states:
"All data types, including text, ntext and image, can be used as a parameter
for a stored procedure."
I would like to pass a table variable... is this possible?
Thanks,
FOrch
>I would like to pass a table variable... is this possible?
NO
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"Forch" <Forch@.discussions.microsoft.com> wrote in message
news:1AAA1E85-4F2D-4110-A6D0-81DDE4255694@.microsoft.com...
> Good morning,
> The Transact-SQL Reference documentation states:
> "All data types, including text, ntext and image, can be used as a
> parameter
> for a stored procedure."
> I would like to pass a table variable... is this possible?
> Thanks,
> FOrch
>

Create Procedure Command

Good morning,
The Transact-SQL Reference documentation states:
"All data types, including text, ntext and image, can be used as a parameter
for a stored procedure."
I would like to pass a table variable... is this possible?
Thanks,
FOrch>I would like to pass a table variable... is this possible?
NO
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"Forch" <Forch@.discussions.microsoft.com> wrote in message
news:1AAA1E85-4F2D-4110-A6D0-81DDE4255694@.microsoft.com...
> Good morning,
> The Transact-SQL Reference documentation states:
> "All data types, including text, ntext and image, can be used as a
> parameter
> for a stored procedure."
> I would like to pass a table variable... is this possible?
> Thanks,
> FOrch
>

Create Procedure Command

Good morning,
The Transact-SQL Reference documentation states:
"All data types, including text, ntext and image, can be used as a parameter
for a stored procedure."
I would like to pass a table variable... is this possible?
Thanks,
FOrch>I would like to pass a table variable... is this possible?
NO
--
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"Forch" <Forch@.discussions.microsoft.com> wrote in message
news:1AAA1E85-4F2D-4110-A6D0-81DDE4255694@.microsoft.com...
> Good morning,
> The Transact-SQL Reference documentation states:
> "All data types, including text, ntext and image, can be used as a
> parameter
> for a stored procedure."
> I would like to pass a table variable... is this possible?
> Thanks,
> FOrch
>

Create Database's default ANSI settings are off?

When I create a new database in SQL Server 2005, most of the database
Options settings, including all of the ANSI settings are off (False).
I thought that most of the ANSI settings (except NUMERIC_ROUNDABORT)
were recommended to be ON(True) by Microsoft. If that is so, then why
aren't they ON by default? I had thought that they were in SQL Server
2000.
Is this the correct behavior or is there a problem with my
installation?
Thanks, R Barry YoungHow are you creating it? Are you running a script? If so what tool are you
using? If it is the query editor then check your options and set them the
way you want them to be.
Andrew J. Kelly SQL MVP
<RBarryYoung@.gmail.com> wrote in message
news:1144864748.605738.232910@.e56g2000cwe.googlegroups.com...
> When I create a new database in SQL Server 2005, most of the database
> Options settings, including all of the ANSI settings are off (False).
> I thought that most of the ANSI settings (except NUMERIC_ROUNDABORT)
> were recommended to be ON(True) by Microsoft. If that is so, then why
> aren't they ON by default? I had thought that they were in SQL Server
> 2000.
> Is this the correct behavior or is there a problem with my
> installation?
> Thanks, R Barry Young
>

Create Database's default ANSI settings are off?

When I create a new database in SQL Server 2005, most of the database
Options settings, including all of the ANSI settings are off (False).
I thought that most of the ANSI settings (except NUMERIC_ROUNDABORT)
were recommended to be ON(True) by Microsoft. If that is so, then why
aren't they ON by default? I had thought that they were in SQL Server
2000.
Is this the correct behavior or is there a problem with my
installation?
Thanks, R Barry YoungHow are you creating it? Are you running a script? If so what tool are you
using? If it is the query editor then check your options and set them the
way you want them to be.
--
Andrew J. Kelly SQL MVP
<RBarryYoung@.gmail.com> wrote in message
news:1144864748.605738.232910@.e56g2000cwe.googlegroups.com...
> When I create a new database in SQL Server 2005, most of the database
> Options settings, including all of the ANSI settings are off (False).
> I thought that most of the ANSI settings (except NUMERIC_ROUNDABORT)
> were recommended to be ON(True) by Microsoft. If that is so, then why
> aren't they ON by default? I had thought that they were in SQL Server
> 2000.
> Is this the correct behavior or is there a problem with my
> installation?
> Thanks, R Barry Young
>