sql - How to return table name with columns in select query -

-

My database has a stored procedure. In that archived process, I am retrieving data from ten different tables. The result I am getting 10 tables. My question is, is there any way, so I can return the name of the table. Because this SP is executing with my vb.net project and storing this result in a dataset. And I have this stored procedure, which tables up to tables in my data set from this stored function. So I'm merging this table as Dataset 1 WTL ("Table 1"). (Merge (dataset2.tables (0))

Now I want to do this, I have to give the name of the table to get results from the stored process, so that I have a table name with table table (0)

Then I should retrieve the results like this stored procedure.

I'm storing the process like 

    > proc sp_QM_INVOICE_MATBATCHWISE_DETAILS @PLANT_CODE NUMERIC (5,0), @COMPANY_CODE NUMERIC (5,0), @ FEER NUMERIC (5,0), @STRAN SIA Start as QC VARCHAR (15), @SMOE VARCHAR (5), @DOC_OVARCHAR (20), @INVOICE_NOVARCHAR (20), @CUSTOMER_NO VARCHAR (20) * QM_INVOICEMATWISE_DETAILS WHERE COMPANY_CODE = @ COMPANY_CODE and PLANT_CODE = @ PLANT_CODE And select FYEAR = @ FYEAR and DOC_NO = @ DOC_NO and INVOICE_NO = @ INVOICE_NO and CUSTOMER_NO = @Customer Select * QM_INVOICEMATBATCHWISE_DETAILS WHERE COMPANY_CODE = COMPANY_CODE and PLANT_CODE = @ PLANT_CODE and FYEAR = @ FYEAR and DOC_NO = @ DOC_NO and INVOICE_NO = @ INVOICE_NO And CUSTOMER_NO = @Customer Select * from QM_TESTCERTIFICATEFORMATCUST_T WHERE COMPANY_CODE = @ COMPANY_CODE and PLANT_CODE = @ PLANT_CODE and FYEAR = @ FYEAR and DOC_NO = @ DOC_NO and INVOICE_NO = @ INVOICE_NO and CUSTOMER_NO = @Customer and

So how can I get this result with the table name in the result when I execute this archived process through my code, then I am retrieving this result in a data set. In the data set, tables are similar to Table 1, Table 2, Table 3. So how can I get the result, but with the table name stored through the stored procedure 

 < P>

proc sp_QM_INVOICE_MATBATCHWISE_DETAILS @PLANT_CODE NUMERIC (5,0), @companyv_coreode NUMERIC (5,0), @fire NUMERIC (5 , 0), @STRANSID VARCHAR (15), @SMODE VARCHAR (5), @DOC_NO VARCHAR 20), @INVOICE_NO VARCHAR (20), @CUSTOMER_NO start as VARCHAR (20) *, by the name 'QM_INVOICEMATWISE_DETAILS' QM_INVOICEMATWISE_DETAILS WHERE COMPANY_CODE = @ CO MPANY_CODE and PLANT_CODE = @ PLANT_CODE and FYEAR = @ FYEAR and DOC_NO = @ DOC_NO and INVOICE_NO = @INVOICE_NO and CUSTOMER_NO = @ Customer Selection *, 'QM_INVOICEMATBATCHWISE_DETAILS WHERE COMPANY_CODE = @ COMPANY_CODE and PLANT_CODE = @ PLANT_ code by the table name and FYEAR = @ FYEAR and DOC_NO = @ DOC_NO and INVOICE_NO = @ INVOICE_NO and CUSTOMER_NO = @ Customer *, select 'QM_TESTCERTIFICATEFORMATCUST_T' from TableName QM_TESTCERTIFICATEFORMATCUST_T Where COMPANY_CODE = @ COMPANY_CODE and PLANT_CODE = @ PLANT_CODE and FYEAR = @ FYEAR and DOC_NO = @ DOC_NO and INVOICE_NO = @ INVOICE_NO and CUSTOMER_NO = @Customer

UPDATE

As you would like to refer to bunch o tables by name Not, you need to set up each table (field TableName ) to read the first line and the properties of each dataset TableName .

After calling the process, you should run: 

  Tables for each TBL in Dataset 1. Ro.kount & gt; 0 tbl.TableName = tbl.Rows (0) ("TableName") End if next

You can reference them as dataset1.tables ("QM_TESTCERTIFICATEFORMATCUST_T") Will be , for example.

As you know that you are referring them into the processed process, you can hardly write the names of tables in vb.net and avoid empty posts which are empty table Will be in the case of


Comments

Post a Comment

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

-
I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
Read more

java - Gradle dependencies: compile project by relative path -

-
Is it possible to specify a dependency on another gradeal project in the granular (in android studios) outside the current project limits? For example, with a relative path like this: dependence {collection project ('../../ stdlib / dagger'}} MyApp (path / user / foo / workspace / mypad) The app (Path / User / Foo / Workspace / MyPass / App) And I have an Android Library Project with 3 subdomules: stdlib (path is / user / foo / Utilities (Path / User / Foo / Workspace / Stadlib / Utilis) http (Path / User / Foo / Workspace / Stadlib / HT) / Li> What I have to do is compile the Dagger, Util, http module in the MyApp project. The Stidelib Library module under heavy development And MyApp will grow in the form of Growth, so I do not want to push them into a Mewen repository. I am a little change. is likely to add another Gredle projects in some way? I will push the study library into the Maven repository after the source is in search of a temp...
Read more

ruby on rails - Object doesn't support #inspect when used with .include -

-
So I have participated in a glitch error that I do not even know how to debug. I am very new to the railing, so it has kicked my ass well when I use the .includes (school) seen by the student, it gives a blue box error, But when I look at any other model and .includes (school) , the school works just fine. class student & lt; ActiveRecord :: Base has has_many: relationships, foreign_key: "liker_id", dependent :: has_many: matches, foreign_key: "student_1_id", dependent :: deleted belong_to: school belong_to: conference belong_to: would_you_rather belong_to: home city belong_to: year is_to: Major and class school & lt; on the console activatecord :: Affiliate for the base: conference includes: respondent, class: "school", foreign_key: "rival_id" (e.g. For: School) Select SQL generated Select "School". * "School" from "school" "ID" IN (1) error message back NoMethodError: u...
Read more