CODEWITHSUNDEEP
sql-server-2008calculated-columns
Pratik.S
Pratik.S

Reputation: 470

Can we write a stored procedure in a computed column in SQL Server 2008?

I have a situation where I want to place a stored procedure in a computed column. But it didn't work out so I used function instead. Can computed column have stored procedure??

Upvotes: 0

Views: 1863

Answers (1)

gbn
gbn

Reputation: 432210

No, they can't.

Stored procedures are not "inline", they don't return scalar values and can have all manner of side effects.

Upvotes: 3

Related Questions