Stack Overflow
Stack Overflow

Questions tagged [fmtonly]

9 questions
3
votes
1 answer

SQL Server SET FMTONLY is deprecated. How do you get the structure of multiple resultsets?

I understand after SQL Server 2012 SET FMTONLY will be deprecated. I've developed a sophisticated code generation system that analyzes the results of a stored procedure and generates C# code for repository, data contracts, and business library. …
Tom Schreck
  • 5,177
  • 12
  • 68
  • 122
1
vote
0 answers

EF Reverse POCO generator not creating the automated return model when my SP has user defined table type as an input parameter

I am using EF reverse POCO generator. When I save the .tt file it automatically generates the return model of all the stored procedures. In couple of my SP's, I have a user defined table type as one of the input params. For those SP's, my POCO is…
Edin Arnold
  • 11
  • 2
0
votes
0 answers

What is the recommended way for adding a SQL Server stored procedure to an Entity Framework model

Summary In our application we use Entity Framework 6 and SQL Server 2016. When importing into the EF model a stored procedure with complex logic, in particular when using temp tables, we put on top: SET FMTONLY OFF Which causes the stored procedure…
PiotrS
  • 180
  • 3
  • 16
0
votes
1 answer

Getting the second dataset from an OLE DB Source in SSIS

I need to read data from a DB1 and write them to another DB2. I use a complex query with CTEs and temp tables and no, i can't put this query in a SProc. I use an OLE DB source and an OLE DB Destination. When i put the query as SQL Command in the…
Johannes Wentu
  • 931
  • 1
  • 14
  • 28
0
votes
0 answers

Fmtonly on Space in Column Name

I have a SP which returns some columns, each column name has space between them like branch Code Branch Name (We are assigning alias in our SP) Now while using fmtonly off I get the column name as returned by the SP, but when I set fmtonly to on it…
Muhammad Taqi
  • 305
  • 2
  • 6
  • 19
0
votes
3 answers

Internationalization using Spring ResourceBundleMessageSource and FMT

We are trying to implement internationalization using Spring ResourceBundleMessageSource and FMT. But when we use it in the JSP, pages are displaying value as ???message.key???. Can you please help us in resolving this behavior? Really appreciate…
Manjunath
  • 172
  • 1
  • 2
  • 18
0
votes
2 answers

How do you get JSTL fmt tag to formate negative numbers with ()

How can I get the JSTL fmt tag to format negative numbers with ()? For example, if I have -20, it would show (20). Positive numbers would be normal.
E Paiz
  • 661
  • 4
  • 9
  • 19
0
votes
1 answer

Infinity error on SQL, FMTONLY

Im using ASP Classic to connect to a database and when I try to execute a proc that doesnt exist, the error is never return and the SQL Profiler stay calling the: SET FMTONLY OFF SET FMTONLY OFF SET FMTONLY ON EXEC gpa_proctest_ SET FMTONLY…
Onaiggac
  • 551
  • 1
  • 6
  • 21
0
votes
1 answer

How can I get the stored procedure returned columns without knowing the input parameters?

I want to execute a stored procedure virtually and get the returned columns. I use fmtonly like below : set fmtonly on exec spName null set fmtonly off but using fmtonly caused to run all the lines of code and result of this work is ERROR. Is there…
masoud ramezani
  • 22,228
  • 29
  • 98
  • 151