how to check whether there is formula defined for the field

Question

Post reply

how to check whether there is formula defined for the field

tramp168.my265

Valued Member

Points: 73
More actions
December 17, 2008 at 7:19 pm

#125102

as above

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

RBarryYoung SSC Guru Points: 143329 More actions · Answer 1

"formula" is not a SQL Server term.

Do you possibly mean a user-defined Function?

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Jack Corbett SSC Guru Points: 184393 More actions · Answer 2

The answer is "Yes"

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Jack Corbett (12/18/2008)
The answer is "Yes"

I thought it was 42.

Tramp, can you state your question a little more clearly please? The question title gets cut off.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

Not cool to make fun of a new poster who doesn't speak good english >>>

USE tempdb

GO

CREATE TABLE dbo.Demo

(

id int NOT NULL IDENTITY(1,1)

, x AS id * 2

)

GO

INSERT INTO dbo.Demo DEFAULT VALUES

GO

SELECT * FROM dbo.Demo

GO

EXEC sp_help 'dbo.Demo'

/*

idintno410 0 no(n/a)(n/a)NULL

xintyes410 0 yes(n/a)(n/a)NULL

The yes means it's a computed column (formula)

*/

GO

DROP TABLE dbo.Demo

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 5

It's also not cool to post questions without enough meat or content to make them very meaningful. Your interpretation of what might be being asked her is very different than what I interpreted it to be. I was thinking along the lines of rbarryyoung and that it is referring to a function perhaps. If someone is going to ask a question and expect to get some kind of valid help, they should at least put the effort into writing a complete post of what they need to know.