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

How to Export data from Listview and Save in DataBase

i am working on inventory software in which I've saved data in list view and now i want to save data in list view in MY SQL where I've table with same fields as in list view, i want whenever i click on my Finish button the data just go and save into…
Ahsan Hussain
  • 952
  • 4
  • 21
  • 42
0
votes
1 answer

drop tables in multischema database

I have one database called TEST. in this database I have two different schemas, one called DEV (old) and second called RC (newly added). before multipule schemas, there was no problem for dropping tables by using folloing script. DECLARE CURSOR…
abidkhan303
  • 1,761
  • 3
  • 18
  • 31
0
votes
1 answer

Cant save or update my SQL Server tables using vb.net

I am a complete beginner to .net and am confused at some basic things. Please help. First of all the table I create and populate (by right clicking tables in server explorer) disappear once I restart the computer. how do I keep them. Is there any…
coolamigo
  • 1
0
votes
2 answers

Ideal way to manage DB's table.users for future development?

Need to mention first that i'am a newbie in PHP/MySQL. I would like to hear from you, from your experience, what's the best way or approach to deal with a table rows such as tbl.users for future development and compatibility with other features on…
aspirinemaga
  • 3,753
  • 10
  • 52
  • 95
0
votes
2 answers

SQL Count On dates

Im working on reports using SSRS 2008 I Have code that brings back 2 columns DateAppRcvd and Advisor Here is my code below: SELECT COUNT(pm.DateAppRcvd) AS [DateAppRcvd], u.FullName AS [Advisor] FROM tbl_Profile_Mortgage AS pm …
RustyHamster
  • 359
  • 1
  • 5
  • 19
0
votes
2 answers

PHP insert error 1064

I keep getting an error on my php page. When I submit my form it says I don't have authorisation to see the php page and when I put it into sql query test it says it's error #1064. I keep getting this error message and I have no idea why. In the…
user3086696
  • 13
  • 1
0
votes
2 answers

How can I interpret a relationship of two entities into a table?

I have these two tables called the "article" and the "head editor". So the relationship is represented as "the article is passed to the editor" and the relationship has an attribute called "datesubmitted". I was wondering how I can make the…
user2953186
  • 19
  • 5
0
votes
1 answer

How to display multiple row values into single row

Here my table is like this Leave_Type Leave_Balance CL 12 PL 10 Now i want to display my data like below Leave_Type_CL Leave_Type_PL Leave_Balance_CL Leave_Balance_PL CL PL 12 10
user3086802
  • 1
  • 1
0
votes
3 answers

In SQL can I use a CASE WHEN statement to set the default of one column if one or more other columns meet a certain condition?

For example, if I want this table to automatically recognise that people that own both cats and dogs are cool. Something like: CREATE TABLE my_new_table ( name VARCHAR(13),

DateOBirth DATE NOT NULL,

…

user3077347
  • 1
0
votes
2 answers

SQL function create error - "Must declare the scalar variable"

I'm trying to create this function which returns a table and has a table name as a parameter: CREATE FUNCTION GetCostData(@CostTable VARCHAR(30)) RETURNS @H2 TABLE ( Repairdate datetime NOT NULL, ReceivedDate datetime NOT NULL ) …
milo2011
  • 339
  • 1
  • 9
  • 25
0
votes
2 answers

Why does this SQL code return the maximum value?

I just found this piece of SQL code that returns the row that contains the oldest person: Assume that you have a SQL table persons with two columns, name and age: SELECT p1.name, p1.age FROM persons p1 LEFT JOIN persons p2 ON p1.age < p2.age WHERE…
user2426316
  • 7,131
  • 20
  • 52
  • 83
0
votes
2 answers

Pivot or Cross Tab

I have the two tables which need to be linked and present the data in human friendly way. Could you experts point me in right direction, I am bit stuck here. Both table 1 and table2 are received through ftp and loaded to SQL table in SQL 2008 R2.…
Anbu Dhan
  • 73
  • 2
  • 10
0
votes
1 answer

Combine data from multiple tables with specific data statements

Need some help using Tereadata I need to pull a report that joins many tables... Here is the basic concept: Select Table1.ID, Table2.Arrival_date, Table2.Name From Table1 Inner Join Table1.ID on Table2.ID Where table2.arrival_date between…
user3046783
  • 1
0
votes
1 answer

MySQL return values count

I have a fairly boggling problem. What I'm after is a list of all the industries whether they have been linked to a job or not. So.. Web Design [0] Accounts[3] Sales[1] Marketing[0] So that the jobs in the database have a industry id that's saved…
bobcoder
  • 19
  • 4
0
votes
1 answer

Missing database table - CakePHP

I have a CakePHP project having 3 plugins: plugin1, plugin2, plugin3. These are simple plugins, I've just tried to split up my project into 3 smaller & easier parts. Plugin1 has to use a model "Model1", where there is no db table for this table. And…
user2973545
  • 1
  • 2
1 2 3
…
20 21