Click here to Skip to main content
15,899,935 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
When I am trying too execute store-procedure it inserting values correctly in database. Trying from front end (MVC,entityFramework(db First ) approach) it sending the values back and first and second table records are inserting correctly with accurate values in database.
values inserting purpose am using temptable on db side. calculation all things done in backend only.

What I have tried:

if I am using <pre>SET FMTONLY OFF
inserting only single record in database.
single records values (decimal Values) are inserting correctly.

when am removing the SET FMTONLY OFF in store proc it is inserting all records. but decimal filed values are inserting 0 values in data table.
can you please any one help me on this pblm.
Posted
Updated 25-Sep-17 4:20am

1 solution

I don't know what version you are using but this link might help:

https://docs.microsoft.com/en-us/sql/t-sql/statements/set-fmtonly-transact-sql
 
Share this answer
 
Comments
Member 10257374 26-Sep-17 2:05am    
am using Azure sqlserver 2016

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900