Sql Comparing two tables: computation

computation for computed columns in sysservers

What is the computation for the sysservers table for the dataaccess and
isremote columns ? How can i find out the computation ?
Was trying to update the column and received a message that the column
cannot be modified since its a computed columnHassan,
Why are you trying to update system tables directly? This is not supported
and not advisable. Use sp_serveroption system SP instead.
--
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:%23D$4kKKzFHA.1264@.tk2msftngp13.phx.gbl...
> What is the computation for the sysservers table for the dataaccess and
> isremote columns ? How can i find out the computation ?
> Was trying to update the column and received a message that the column
> cannot be modified since its a computed column
>
>|||sp_addserver and sp_dropserver are the interfaces to that table.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:e8KWFVKzFHA.1132@.TK2MSFTNGP10.phx.gbl...
> Hassan,
> Why are you trying to update system tables directly? This is not supported
> and not advisable. Use sp_serveroption system SP instead.
> --
> Dejan Sarka, SQL Server MVP
> Mentor
> www.SolidQualityLearning.com
>
> "Hassan" <hassanboy@.hotmail.com> wrote in message
> news:%23D$4kKKzFHA.1264@.tk2msftngp13.phx.gbl...
>> What is the computation for the sysservers table for the dataaccess and
>> isremote columns ? How can i find out the computation ?
>> Was trying to update the column and received a message that the column
>> cannot be modified since its a computed column
>>
>|||just in general, if i have a computed column, how does one view the
computations tied to those columns ?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OQOlBeLzFHA.3660@.TK2MSFTNGP15.phx.gbl...
> sp_addserver and sp_dropserver are the interfaces to that table.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:e8KWFVKzFHA.1132@.TK2MSFTNGP10.phx.gbl...
>> Hassan,
>> Why are you trying to update system tables directly? This is not
>> supported and not advisable. Use sp_serveroption system SP instead.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor
>> www.SolidQualityLearning.com
>>
>> "Hassan" <hassanboy@.hotmail.com> wrote in message
>> news:%23D$4kKKzFHA.1264@.tk2msftngp13.phx.gbl...
>> What is the computation for the sysservers table for the dataaccess and
>> isremote columns ? How can i find out the computation ?
>> Was trying to update the column and received a message that the column
>> cannot be modified since its a computed column
>>
>>
>|||Seems to be in syscomments.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Hassan" <hassanboy@.hotmail.com> wrote in message news:%23nsmjDVzFHA.3408@.TK2MSFTNGP09.phx.gbl...
> just in general, if i have a computed column, how does one view the
> computations tied to those columns ?
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:OQOlBeLzFHA.3660@.TK2MSFTNGP15.phx.gbl...
>> sp_addserver and sp_dropserver are the interfaces to that table.
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
>> message news:e8KWFVKzFHA.1132@.TK2MSFTNGP10.phx.gbl...
>> Hassan,
>> Why are you trying to update system tables directly? This is not
>> supported and not advisable. Use sp_serveroption system SP instead.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor
>> www.SolidQualityLearning.com
>>
>> "Hassan" <hassanboy@.hotmail.com> wrote in message
>> news:%23D$4kKKzFHA.1264@.tk2msftngp13.phx.gbl...
>> What is the computation for the sysservers table for the dataaccess and
>> isremote columns ? How can i find out the computation ?
>> Was trying to update the column and received a message that the column
>> cannot be modified since its a computed column
>>
>>
>>
>|||In Query Analyzer, press F8 to open the Object Browser, right-click the
table, click Script to new window as > Create.
Don't ever alter or update system tables directly.
--
David Portas
SQL Server MVP
--|||Sure they are, but not the only ones; actually, they are very basic ones.
You add linked servers with sp_addlinkedserver; you change the server
options, like data access, with sp_serveroption, as I correctly mentioned.
All these procedures are described in BOL.
--
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OQOlBeLzFHA.3660@.TK2MSFTNGP15.phx.gbl...
> sp_addserver and sp_dropserver are the interfaces to that table.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:e8KWFVKzFHA.1132@.TK2MSFTNGP10.phx.gbl...
>> Hassan,
>> Why are you trying to update system tables directly? This is not
>> supported and not advisable. Use sp_serveroption system SP instead.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor
>> www.SolidQualityLearning.com
>>
>> "Hassan" <hassanboy@.hotmail.com> wrote in message
>> news:%23D$4kKKzFHA.1264@.tk2msftngp13.phx.gbl...
>> What is the computation for the sysservers table for the dataaccess and
>> isremote columns ? How can i find out the computation ?
>> Was trying to update the column and received a message that the column
>> cannot be modified since its a computed column
>>
>>
>

computation and promutation

i am trying to set up a quick and dirty, but efficient way to calculate permutation and combination. anyone out there dealt with this?any takers?|||The method depends on what kind of permutations you want to do.

Given N objects in X different positions, do you want to allow repetitions? Do you want to include permutations with less than X values?

There are formulas available that will calculate these. Excel actually has some good statistical functions that not only do the calculations, but the help file does a good job of explaining the formula used. You might run a couple test on a spreadsheet until you are sure what kind of permutation you want, and then port the formula from Excel's help file into a TSQL statement.|||ok, it's been awhile, and i barely passed it, but knowing the total number (9999), what is the n in this combination formula:

9999 = n! / (4!(n-4)!)|||never mind, it doesn't jive, back to the drawing board|||N is the number of items, and I believe 4 is the number of locations.

N! is N Factorial, which SQL Server does not have as a standard function, but is simply 1*2*3*4*5...*N, so you could write the function easily enough.|||...and 9999 factorial would be HUGE! We're way beyond "grains of sand" and into "atoms in the universe" here...

Thursday, March 22, 2012

computation for computed columns in sysservers

computation for computed columns in sysservers

computation for computed columns in sysservers

computation and promutation

Sql Comparing two tables

Blog Archive

About Me