Stack Overflow
Stack Overflow

Questions tagged [database-table]

In a relational database management system (RDBMS) a table organizes the information in rows and columns. Each table has a defined number of columns, each of which is identified by its name, but the number of rows is variable, consisting of one for each line of data.

In a relational database management system (RDBMS) a table organizes the information in rows and columns. Each table has a defined number of columns, each of which is identified by its name, but the number of rows is variable, consisting of one for each line of data.

More Information:

  1. The wiki entry on database tables is a good source of information.
  2. Microsoft provides an intuitive definition of a table
313 questions
0
votes
1 answer

Fetch values from the selected rows and calculate its average

I am working with SQL I have a table named as review like this with following rows and columns rating | status -------|---------- 5 | 1 5 | 1 4 | 1 2 | 0 5 |-1 I want to calculate the average of rating values when status is…
Nawaz Ghori
  • 591
  • 6
  • 20
0
votes
1 answer

Search all varchar columns in table and output the row

I need an assistance with regard to building a PL/SQL block related to the following query: SELECT , FROM TABLENAME WHERE REGEXP_LIKE(VARCHAR_COLUMN, UNISTR('[\D800-\DFFF]')); The above query will give an output…
arsm4
  • 101
  • 2
  • 10
0
votes
2 answers

display custom data from database to post type in wordpress

Suppposed to be, I had custom database table in wordpress: Let us say: wp_messages table with fields: from, title, subject, body something like this: _____________________________________________ | from | title | subject | body …
Codeblooded Saiyan
  • 1,457
  • 4
  • 28
  • 54
0
votes
1 answer

What is the best database schema to store Data of multiple categories for optimized storage and retrieval?

I have a table to save file. Table looks like this: ---File Table--- FileId FileName File (File path or Binary Data) FileTypeId ----------------------------- --- FileType Table--- FileTypeId FileTypeName Eg: pdf,…
Prabesh
  • 353
  • 1
  • 6
  • 20
0
votes
1 answer

What is the best way to design a database to store record with a lot of values?

I want to design a database for events and track a lot of statistic about the it. Option 1 Create one table for Events and put all my statistic column in it. Like number of male, number of female, number of unidentified gender, temperature that…
binary_assemble
  • 394
  • 3
  • 17
0
votes
0 answers

adding a DELETE link to my table with the js array push()

I would like to incorporate a link in my table for a delete button. This will then - onclick - delete from my db depending on the ID. I have searched through stack overflow with no prevail. A point in the right direction would be great (links, code…
lewiswilsonn
  • 1
  • 3
0
votes
3 answers

Design Implementation SQL tables

I am new to SQL and been given a task. Following are the details: What I have: A C# desktop application for User login and view user status (only two options: user logs in and check status of all users that are dummy created) A table named USER…
Afnan Bashir
  • 7,319
  • 20
  • 76
  • 138
0
votes
2 answers

Calculating days difference in a calculated field

I have tried every variation I can think of. I have a table that displays [Appt Date] in a field. I want to subtract that date from today to give me the [Days to Appt]. I have tried several variations in the expression builder of the calculated…
Wolfie84367
  • 102
  • 1
  • 10
0
votes
0 answers

How duplicate values prevented from multiple Excel sheets while storing data into SQL Server table

private void InsertExcelRecords(string filepath) { ExcelConn(filepath); OleDbCommand Ecom = new OleDbCommand(Query, Econ); Econ.Open(); DataTable dtSheet = Econ.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); …
kumar
  • 1
0
votes
1 answer

Want to auto create a table in Microsoft Access dependent on a field in another table

I have a list of landowners in an area with initial information. There is a field that can be checked in the table if the landowner has been contacted. For all those that have been contacted I would like them to appear in a new table. This table…
user4326843
0
votes
1 answer

Database Table Content Comparison

We Use SAP HANA as database. How can I compare if two tables have the same content? I already did a comparison of the primary key using SQL: select COUNT (*) from Schema.table1; select COUNT (*) from Schema.table2; select COUNT (*) from…
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
0
votes
1 answer

Populate ComboBox with Title Case Query Result

with TdmBCElections.Create(Self) do begin with dmBCElections, qryParties do begin SQL.Clear; if rgpParty.ItemIndex = 0 then SQL.Text := 'SELECT StrConv(P_Surname, 3), StrConv(P_Names, 3) ' + 'FROM Parties WHERE P_Type =…
Reginald Greyling
  • 363
  • 3
  • 19
0
votes
1 answer

how to retrieve rows from sql database containing same value of some particular column

I am working with grails. I have a class: class Checkin_checkout { Date checkin_date Date checkout_date String time_duration int employee_id } I want to retrieve all the rows from database having same value of employee_id. please…
hariom singh
  • 1
0
votes
2 answers

How do I create a table in SQL Server that stores multiple values for one cell?

Suppose I have a table for purchase orders. One customer might buy many products. I need to store all these products and their relevant prices in a single record, such as an invoice format.
Kiran
  • 3
  • 3
0
votes
1 answer

Database connection and save_click

I have a sql database called Facturen (dutch for invoice) in the database there is a databasetable called Facturen (dutch for invoices). Also I have a C# form (winforms) with a datagridwiew some textboxes and some labels. Also I have a Button and…
Mario Viveey
  • 1
  • 2
1 2 3
…
20 21