database

Passing an array of ID's to a stored procedure

I have stored procedure, i want to send it an array of values. When i send more than one i'm getting an error Error converting data type varchar to numeric. Here is the code. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_getTransfer] @TRANSFER_ID int = null, @COMPANY VARCHAR(5),@FORMTYPE VARCHAR(30), @TRANSF...

Junction Table with Subtable in SQL

I have two sql tables Players and Teams joined by a PlayerTeam junction table. A player can be on a team for various years. What's the best way to handle this relationship? I started with a PlayerTeamYear table, but the foreign key reference to both columns in PlayerTeam seems unwieldy, especially as I want to convert this to Entity Fram...

Storing Composite Product Numbers

I am designing a laboratory database. Several products, samples, etc are identified by a composite number with multiple parts which indicate different values such as: origin, date, type, id today, etc. Examples of composite numbers might include a driver's license number (X44-555-3434), lot number (XBR-A26-500-2). How should composite...

Is there a better way to get old data?

Say you've got a database like this: books ----- id name And you wanted to get the total number of books in the database, easiest possible sql: "select count(id) from books" But now you want to get the total number of books last month... Edit: but some of the books have been deleted from the table since last month Well obv...

Use Different Password for entity manager in auto-generated Netbeans code

I am using the NetBeans IDE along with Java. I do want to distribute a database password/login in persistence.xml, but allow it to be set by the user/installing person in a config. The NetBeans IDE created a persistence.xml file for my connection that contains all of the database connection information and auto generates the code below:...

What type of database table structure is this called?

Hi, A long time ago I took over maintenance of a web based content management system that had a pretty clever database table in it. The table structure was like: TABLE: tPage (PK on PageID, Version, Status) PageID, PageTitle, Version, Status 1, Homepage, 1, Archived 1, Homepage, 2, Live 1, New Home, 3, ...

How to generate 2TB+ size of data for Oracle, Informix & Sybase

I am a new to Informix and as part of my testing activity I am in need of creating 2TB+ size data for Oracle, Informix & Sybase. Is there a database-neutral way of doing this? I am looking for any freeware or open source tools as well; I can find a few for Oracle but hardly any for Informix & Sybase. ...

Connecting to SQL Server at ISP over the Internet using Sql Server Management Studio

How do I do this? The ISP says it's possible, but there's no place in the connection dialog for an IP address. Will it not work with the Express version; do I need the full version of SSMS? ...

Truncate_only deprecated in SQL2008

The following statement BACKUP LOG [AMS_Prod_log] WITH TRUNCATE_ONLY works fine in SQL Server 2005 but it doesn't with 2008. It seems truncate_only is deprecated in 2008. Could you please let me know how to achieve this in 2008? What care needs to be taken like backup... etc? ...

MySQL server has gone away Error while Selecting rows from a table

Using a C program with Mysql C API connected to a database and the initiation was successful but tried to do SELECT ,INSERT operations it throws an Error " MySQL server has gone away" on my VPS Server but the same works fine locally. The VPS Server Mysql Server version is : 5.0.81-community MySQL Community Edition (GPL) . wait...

Using sqlite3 with a small commercial site

I am looking for recommendations for a db to use for a small commercial web store (about 10000 products, about 200 entries a day) written in RoR. Is sqlite3 sufficient for this or should I go for MySQL? How complicated is migration between these two at a later stage if required? ...

Where should I save database files?

So far in development, my application has been storing its databases in the app base directory. When it is deployed this will be in program files so I cant keep them there! The obvoius places are: Environment.SpecialFolder.LocalApplicationData Environment.SpecialFolder.ApplicationData One problem is that data downloads can be run fro...

How should I determine a database column type in an agnostic way using DbConnection.GetSchema?

I want to allow the user to define a query which will be used to fetch some information. The database the user connects to is also user definable. Basically the steps that the user needs to perform are: 1/ Select the data provider (this is one of the providers returned by DbProviderFactories.GetFactoryClasses ()) 2/ Configure the sel...

LFL sales query in SQL

This might seem a bit like a do-my-homework-for-me question (and it is), but I think that the sales results I’m trying to get are fairly generic and will be useful for anyone doing sales reporting. I have a basic Sales table (fields: Branch, DateOfSale, SalesAmount) in SQL Server 2005 and I need to build a report with the data in that t...

Is it better to have 1 page or many for a website listing a small number of products?

I have a small website for a company that have 40-50 product. The site will be in french and English. Each product will have 2-3 different price (based on shipping) So the standard approach, will be to do 50 (100 in both language) different web page done with an template engine, maybe pure HTML and css coding The other solution, make 1...

How can I get the last ten rows in a Mysql database table ?

hi I use this $query = "SELECT * FROM info ORDER BY id DESC limit 10"; $result = @mysql_query( $query ); $row = mysql_fetch_array($result); print_r($row); but it gets just the last row ...

How to represent a 2-D data matrix in a database

I have a data set which consists of an ID and a matrix (n x n) of data related to that ID. Both the column names (A,B,C,D) and the Row names (1,2,3) are also important and need to be held for each individual ID, as well as the data (a1,b1,c1,d1,...) for example: ID | A | B | C | D | 1 | a1 | b1 | c1 | d1 | 2 |...

what does one to one table mapping mean?

I heard this phrase when I was listening to dot net rocks this morning. apparently linq to sql only supports one to one table mapping. ...

Data Module in Dll with delphi?

Hello all friends.. I am Tobassum Munir from Pakistan. I created a database program which has a problem. I used Borland Delphi 7.x My Question is "How to create a data module in Dll (Dynamic Link Library) With Delphi? ...

What are the ramifications of granting a DB User with limited access Execute permission?

If I have a user that only has limited permissions - just db_datareader and db_datawriter, which should only permit the user to query data and insert/edit/delete data, without allowing the user to add/modify/delete tables in the database. There may be a need for the user to be able to execute stored procedures. If the user is given exe...