No announcements
Found 3974623 threads
-
0 Votes
how to extract column names and table names to listbox or combobox in vba?
Coming up with Excel 2003 cells could be formatted as Table, means a sheet can contain one (or more) tables.Answered | 8 Replies | 4309 Views | Created by MicoVBATech - Saturday, August 23, 2014 2:19 PM | Last reply by MicoVBATech - Sunday, August 24, 2014 1:24 PM -
3 Votes
Bind ListBox Control to Dataset column names
I thought there might have been a way to bind to a table in a DataSet, then somehow link to the columnNames property for each column in that table.Answered | 4 Replies | 4197 Views | Created by siansun - Wednesday, December 22, 2010 4:15 AM | Last reply by siansun - Wednesday, December 22, 2010 3:51 PM -
3 Votes
get Table names for a particular Database
Hello, Try this SELECT Name AS TableName FROM DataBaseName.Sys.Tables Hope helpful...Answered | 6 Replies | 4173 Views | Created by daktmacfan - Tuesday, June 9, 2009 4:47 PM | Last reply by Brad_Schulz - Tuesday, June 9, 2009 5:13 PM -
2 Votes
How to use select * but rename selected column names
" to solve your problem you can insert Present Table to another table that column names is your favorite names.Answered | 8 Replies | 3793 Views | Created by Isolda - Friday, September 14, 2012 7:54 PM | Last reply by Isolda - Monday, September 17, 2012 3:13 PM -
1 Votes
How to seperate names in a listBox
Modify your query so that it also returns the last name and first name as independent columns.Answered | 3 Replies | 2646 Views | Created by Mitja Bonca - Thursday, May 28, 2009 2:54 PM | Last reply by Alan M_ - Thursday, May 28, 2009 3:26 PM -
1 Votes
dynamic table using column name as a slicer selection
>>I am wondering if it is possible to do so, is it possible to create dynamic table using column name as a slicer ?Answered | 3 Replies | 1002 Views | Created by Bob_Tang - Monday, August 6, 2018 9:29 PM | Last reply by Bob_Tang - Tuesday, August 7, 2018 10:02 PM -
1 Votes
how to get the column names of the table excel in vb.net
now , when i select the name of the column : -this column will be copie in a new sheet of the same ...Answered | 10 Replies | 6241 Views | Created by tamaratheo - Wednesday, March 18, 2015 10:21 AM | Last reply by Armin Zingler - Wednesday, March 18, 2015 12:29 PM -
2 Votes
How to find table name based on field name?
You can use a script: SELECT TABLE_CATALOG,TABLE_SCHEMA, COLUMN_NAME, TABLE_NAME FROM ...Answered | 2 Replies | 714 Views | Created by suusja - Saturday, September 17, 2016 1:40 PM | Last reply by SvetNas - Saturday, September 17, 2016 3:57 PM -
0 Votes
get columns unique constraint name
Try this, SELECT tc.constraint_name, tc.constraint_type, tc.table_name, kcu.column_name FROM ...Answered | 2 Replies | 1317 Views | Created by sivakl_2001 - Friday, April 11, 2014 8:33 AM | Last reply by Ch. Rajen Singh - Friday, April 11, 2014 10:03 AM -
0 Votes
get column name of selected cell
'column ...Answered | 2 Replies | 18882 Views | Created by cliftonmenig - Wednesday, November 17, 2010 11:55 PM | Last reply by .paul. _ - Thursday, November 18, 2010 12:46 AM -
2 Votes
How to Find "Table Name" in particular "Data File"
Below is the error I am getting.Answered | 4 Replies | 8857 Views | Created by Rahul Bobal - Monday, April 30, 2012 1:26 AM | Last reply by Rahul Bobal - Monday, April 30, 2012 8:27 AM -
0 Votes
Get column names based on specific search string from a single table
0 Begin Select @sql ='insert into #ColumnsValues Select '+@IdentityColumnName+','''+@columns+''','+@columns+' from '+@TableName+' where ...Answered | 7 Replies | 698 Views | Created by sql9 - Tuesday, May 29, 2018 2:20 PM | Last reply by Mohammad Waheed - Wednesday, May 30, 2018 5:37 PM -
0 Votes
Wildcard to Select Column Name using a parameter
Actually, I am doing exactly that by using several parameters and a combination of labels and values, and I'm able to successfully do the exact thing I want ...Answered | 3 Replies | 3176 Views | Created by daponc - Thursday, August 8, 2013 6:44 PM | Last reply by ironryan77 - Friday, August 9, 2013 3:18 PM -
1 Votes
Custom/named indexes for a Listbox?
I'm using a custom database class to access data in a MySQL database (using the MySQL connector).Answered | 2 Replies | 3043 Views | Created by Rean O - Saturday, July 11, 2009 3:10 AM | Last reply by Rean O - Saturday, July 11, 2009 8:43 AM -
0 Votes
Select column names and their values from a given table
Check this Query --Create Table #Test --( --ID Int, ...Answered | 4 Replies | 2580 Views | Created by AustralPenguin - Wednesday, November 21, 2012 8:37 PM | Last reply by Santhosh H - Thursday, November 22, 2012 7:40 AM -
0 Votes
how to select data AND column name?
(And when the result has more records, you want the names of columns repeated in everyone?)Answered | 13 Replies | 5329 Views | Created by perner123 - Monday, January 28, 2013 9:06 AM | Last reply by Alessandro Piccione - Monday, January 28, 2013 11:21 AM -
2 Votes
Change all column name in a table to uniqe name
and i don't know how many columns are present in this table t1.Answered | 13 Replies | 2609 Views | Created by sagar jena - Tuesday, January 3, 2012 11:08 AM | Last reply by Asim Bagwan - Tuesday, January 3, 2012 2:06 PM -
1 Votes
How use "Description" as a column name
Max limit for identifier/column name is 128 character.Answered | 2 Replies | 2427 Views | Created by khadem1386 - Saturday, March 15, 2014 10:11 PM | Last reply by Ch. Rajen Singh - Sunday, March 16, 2014 5:23 AM -
0 Votes
How to get Column Group Name
This is an attribute of the UI you're using and not of a data table.Answered | 4 Replies | 862 Views | Created by wpf_xam1 - Thursday, September 1, 2016 1:44 PM | Last reply by Zhanglong Wu - Friday, September 2, 2016 1:21 AM -
0 Votes
Need to use dynamic column names in select statement of any tables
The columns in a table are located by name and there is no concept of sequential ordering.Answered | 7 Replies | 8811 Views | Created by AshishSingh_DWH - Tuesday, January 19, 2016 5:55 AM | Last reply by Naomi N - Tuesday, January 19, 2016 5:27 PM - Items 1 to 20 of 3974623 Next ›
No announcements