run the output

I want to delete the index:
How to run the output of:
select 'alter table ' + b.name + ' drop constraint ' + a.name from
sysobjects a
inner join syscolumns on syscolumns.id = a.parent_obj
inner join sysobjects b on syscolumns.id = b.id
where syscolumns.name = 'rowguid'
and objectproperty(object_id(b.name),'IsMSShipped') = 0
and a.xtype = 'D'
ThanksM,
Copy the output from the result pane into the query pane and Ctrl+E (or F5
or Alt+X).
HTH
Jerry
"M" <mxchen@.hotvoice.com> wrote in message
news:encucR20FHA.460@.TK2MSFTNGP15.phx.gbl...
> I want to delete the index:
> How to run the output of:
>
> select 'alter table ' + b.name + ' drop constraint ' + a.name from
> sysobjects a
> inner join syscolumns on syscolumns.id = a.parent_obj
> inner join sysobjects b on syscolumns.id = b.id
> where syscolumns.name = 'rowguid'
> and objectproperty(object_id(b.name),'IsMSShipped') = 0
> and a.xtype = 'D'
> Thanks
>
>|||Thanks
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:u6FbrU20FHA.1264@.tk2msftngp13.phx.gbl...
> M,
> Copy the output from the result pane into the query pane and Ctrl+E (or F5
> or Alt+X).
> HTH
> Jerry
> "M" <mxchen@.hotvoice.com> wrote in message
> news:encucR20FHA.460@.TK2MSFTNGP15.phx.gbl...
>
>

Rules Vrs Check Constraints

Hello,
Could someone please explain the difference between them?,
I'm edging towards the CHECK CONSTRAINT as I believe it
offers better perfomance, but I just want to make sure I
have my facts right.
J
Rules is not in ANSI SQL. So you will only find it implemented as in SQL Server in MS and possibly
Sybase SQL Server.
Constraints are ANSI SQL.
Most focus today is on constraints. Many consider rules and "old technology". They have the
advantage of "define once, use many", though.
I prefer constraints.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:10f801c518fa$6b320ce0$a401280a@.phx.gbl...
> Hello,
> Could someone please explain the difference between them?,
> I'm edging towards the CHECK CONSTRAINT as I believe it
> offers better perfomance, but I just want to make sure I
> have my facts right.
> J
|||Thanks Tibor

>--Original Message--
>Rules is not in ANSI SQL. So you will only find it
implemented as in SQL Server in MS and possibly
>Sybase SQL Server.
>Constraints are ANSI SQL.
>Most focus today is on constraints. Many consider rules
and "old technology". They have the
>advantage of "define once, use many", though.
>I prefer constraints.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>http://www.sqlug.se/
>
>"Julie" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:10f801c518fa$6b320ce0$a401280a@.phx.gbl...
them?,
>
>.
>

Rules Vrs Check Constraints

Hello,
Could someone please explain the difference between them?,
I'm edging towards the CHECK CONSTRAINT as I believe it
offers better perfomance, but I just want to make sure I
have my facts right.
JRules is not in ANSI SQL. So you will only find it implemented as in SQL Ser
ver in MS and possibly
Sybase SQL Server.
Constraints are ANSI SQL.
Most focus today is on constraints. Many consider rules and "old technology"
. They have the
advantage of "define once, use many", though.
I prefer constraints.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:10f801c518fa$6b320ce0$a401280a@.phx.gbl...
> Hello,
> Could someone please explain the difference between them?,
> I'm edging towards the CHECK CONSTRAINT as I believe it
> offers better perfomance, but I just want to make sure I
> have my facts right.
> J|||Thanks Tibor

>--Original Message--
>Rules is not in ANSI SQL. So you will only find it
implemented as in SQL Server in MS and possibly
>Sybase SQL Server.
>Constraints are ANSI SQL.
>Most focus today is on constraints. Many consider rules
and "old technology". They have the
>advantage of "define once, use many", though.
>I prefer constraints.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>http://www.sqlug.se/
>
>"Julie" <anonymous@.discussions.microsoft.com> wrote in
message
>news:10f801c518fa$6b320ce0$a401280a@.phx.gbl...
them?,[vbcol=seagreen]
>
>.
>

Rules Vrs Check Constraints

Hello,
Could someone please explain the difference between them?,
I'm edging towards the CHECK CONSTRAINT as I believe it
offers better perfomance, but I just want to make sure I
have my facts right.
JRules is not in ANSI SQL. So you will only find it implemented as in SQL Server in MS and possibly
Sybase SQL Server.
Constraints are ANSI SQL.
Most focus today is on constraints. Many consider rules and "old technology". They have the
advantage of "define once, use many", though.
I prefer constraints.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:10f801c518fa$6b320ce0$a401280a@.phx.gbl...
> Hello,
> Could someone please explain the difference between them?,
> I'm edging towards the CHECK CONSTRAINT as I believe it
> offers better perfomance, but I just want to make sure I
> have my facts right.
> J|||Thanks Tibor
>--Original Message--
>Rules is not in ANSI SQL. So you will only find it
implemented as in SQL Server in MS and possibly
>Sybase SQL Server.
>Constraints are ANSI SQL.
>Most focus today is on constraints. Many consider rules
and "old technology". They have the
>advantage of "define once, use many", though.
>I prefer constraints.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>http://www.sqlug.se/
>
>"Julie" <anonymous@.discussions.microsoft.com> wrote in
message
>news:10f801c518fa$6b320ce0$a401280a@.phx.gbl...
>> Hello,
>> Could someone please explain the difference between
them?,
>> I'm edging towards the CHECK CONSTRAINT as I believe it
>> offers better perfomance, but I just want to make sure I
>> have my facts right.
>> J
>
>.
>