Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Multilevel Formulae Store in DB and Use in Programming

Home
Forums

Multilevel Formulae Store in DB and Use in Programming

Prakash Shrivastav

8yAsked Oct 23, 2018, 12:11 PM749

Multilevel Formulae Store in DB and Use in Programming

two evalute the value as per formulae which is actual store in DB or to form the structure, i am unable to form the structure of database.

Formula : ((a+b)*2.5)/c)

like this type of formulae, how to store and manupulate in Database and Programming to.

Help me Out,

Thanks in advance

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Jayesh Vaghasiya8y ago
try
this

declare @tab1 table (Formula varchar(64))
insert into @tab1 values ('(((a+b)*2.5)/c)')
declare @Formula varchar(64)
select top 1 @Formula = Formula from @tab1
declare @qrex varchar(8000)=''
set @qrex = 'declare @tab table (a int, b int,c int)
insert into @tab values(10,20,10)
insert into @tab values(110,210,20)
insert into @tab values(120,220,30)
insert into @tab values(130,230,40)'
set @qrex = @qrex + ' select '+ @Formula + ' from @tab'
exec(@qrex)

0
Nilesh Patel8y ago
Hello,

Set Formula Like (@A + @B) * 2.5 and Save same formula in Database.

After time of Caluculation first take same formula in Temp Table
Update Value of Variable
Caluculate Formula
Set Result in one variable
0