Stack Overflow
Stack Overflow

Questions tagged [tablename]

143 questions
0
votes
2 answers

Using SELECT within SELECT statement in ORACLE

I have a table name SAMPLETABLE this has the tablenames of the tables I require in column TABLENAMES. Lets say the tablenames are TABLEA, TABLEB and TABLEC. On query SELECT TABLENAMES FROM SAMPLETABLE WHERE ROWNUM = 1 I get the output the output of…
iMan
  • 456
  • 1
  • 7
  • 18
0
votes
0 answers

how to access profile after login?

im having trouble accessing profile page after login and I also have another problem I have login data such as email and password in a different database and table name profile information is in another database and table name how can they be…
tazmania
  • 19
  • 2
  • 9
0
votes
2 answers

Using question mark instead of table name in PDO prepared statements

I need to know can I use question marks (?) in PDO prepared statements as table name or not. $table = $_POST['table']; $id = $_POST['id']; $sql = "UPDATE ? SET priority = priority + 1 WHERE id = ?"; $q =…
Mohammad Saberi
  • 12,864
  • 27
  • 75
  • 127
0
votes
3 answers

Select all Table/View Names with each table Row Count in Teredata

I have been stuck into a question. The question is I want to get all Table name with their Row Count from Teradata. I have this query which gives me all View Name from a specific Schema. I ] SELECT TableName FROM dbc.tables WHERE tablekind='V'…
vrivrivri
  • 189
  • 1
  • 3
  • 13
0
votes
2 answers

DataSet stored procedure table names

I am calling a stored procedure to return two tables. I am getting it as a dataset in my console application. The table names in the dataset are something like TABLE,TABLE1. Is there anyway to change this to a meaningful names from stored…
Mahesh
  • 1,651
  • 5
  • 26
  • 47
0
votes
2 answers

Tablename as Numeric in SQL Server using Asp.net

I have the following code: SqlConnection connection = new SqlConnection(@"Data Source=MY-PC;Initial Catalog=master;Integrated Security=True"); connection.Open(); using (SqlCommand command = new SqlCommand("CREATE TABLE Table1 (Weight INT, Name…
Dimo
  • 3,238
  • 6
  • 29
  • 46
0
votes
1 answer

Using variable for tablename in php/mysql

I'm pretty new to php and mysql. I have created an html form on one page. The action goes to another page which creates a table in a mysql database and enters all the info entered into the form. Then on the original page I call the table that was…
karlh
  • 9
  • 3
0
votes
0 answers

MySQL Connector/NET Stored procedure table names

When I use the MySQL Connector/NET in my C# application and I call a stored procedure with it using the ExecuteReader method and an Extention on a DataTable to fill it. Here is the code: using (IDataReader reader =…
Michiel van Vaardegem
  • 2,260
  • 20
  • 35
0
votes
3 answers

Use variable in JPA Annotation for a tablename

I have a database with tables created dynamically (These tables have the same structure but their name is suffixed with the year followed by the number of the current month: data201201, data201202, data201203 ...) I created a entity-class called…
Elom ETSE
  • 33
  • 3
  • 11
0
votes
2 answers

rails n:m how to have rails associations when the db table names are different

I have a project which does not follow the rails nameing conventions, because it is not possible for a special case. Scenario: I have a model called Foo, and the database table for this model called example_foos. I have a model called Bar, and the…
Matthias
  • 4,355
  • 2
  • 25
  • 34
-1
votes
1 answer

Correct syntax for table name under Inner Join?

I am a complete beginner to BigQuery, and I am trying to create an inner join between two table names, where the column 'title' is the joining column. I believe my syntax is correct, but I do not know what I am doing wrong when I input the ON…
Nicholas Rios
  • 5
  • 2
-1
votes
1 answer

How to extract table name into string variable

Would you help me to extract table name into string variable in SQL Server 2017? Problem: In many procedures I have dynamic queries like this: declare @tbl_name nvarchar(255) = 'm4_results' if @columns_to_ins is not null exec ('ALTER TABLE ' +…
Alex Ivanov
  • 657
  • 1
  • 8
  • 17
-1
votes
1 answer

SQL: Replacing part of query by subquery in FROM clause

I have a database including a table called [Table] which lists all tables in that database. Now I want to write a SQL query using some JOINS, which gets a specific tablename from [Table] in a subquery to select from that table... I hope this is not…
Gardinero
  • 331
  • 2
  • 13
-1
votes
1 answer

PDO variable is part of a table name

i am trying to bind a variable which is part of a table name when using PDO binding to prevent SQL injection. my query is similar to this: select * from user_:id_user.kb_:id_kbase "."_frequencies" which must result into select * from…
Farouk
  • 1
  • 4
-1
votes
2 answers

Select a variable table name

I am trying to write some SQL statements for queries for a Microsoft Dynamics Nav database. I am trying to write scripts that i can easily use in different Nav databases. The table names for each database are unique in that they always have the…
axelcore
  • 1
  • 1
1 2 3
…
9
10