Showing posts with label gtyes. Show all posts
Showing posts with label gtyes. Show all posts

Monday, March 19, 2012

Index on bit type column

Can we create an index in SQL Server 7.0 on Bit data type
column.

>--Original Message--
>Hi,
>Yes, You can create index on a bit data type column.
>Thanks
>Hari
>MCDBA
>"Lalit" <anonymous@.discussions.microsoft.com> wrote in
message
>news:4ada01c42c3f$8acb0820$a401280a@.phx.gbl...
>
>.
>Hi Lalit,
As Tiber mentioned earlier. No, we cant create an index on bit data type
column in SQL 7 or earlier versions.
Only from sql 2000 we can create index on bit column.
Thanks
Hari
MCDBA
"Lalit" <anonymous@.discussions.microsoft.com> wrote in message
news:4d4e01c42c46$95e0b140$a101280a@.phx.gbl...[vbcol=seagreen]
> Can we create an index in SQL Server 7.0 on Bit data type
> column.
>
> message

Index on bit type column

Can we create an index in SQL Server 7.0 on Bit data type
column.

>--Original Message--
>Hi,
>Yes, You can create index on a bit data type column.
>Thanks
>Hari
>MCDBA
>"Lalit" <anonymous@.discussions.microsoft.com> wrote in
message
>news:4ada01c42c3f$8acb0820$a401280a@.phx.gbl...
>
>.
>
Hi Lalit,
As Tiber mentioned earlier. No, we cant create an index on bit data type
column in SQL 7 or earlier versions.
Only from sql 2000 we can create index on bit column.
Thanks
Hari
MCDBA
"Lalit" <anonymous@.discussions.microsoft.com> wrote in message
news:4d4e01c42c46$95e0b140$a101280a@.phx.gbl...[vbcol=seagreen]
> Can we create an index in SQL Server 7.0 on Bit data type
> column.
> message