Databases Forum

Hi, We have an SQL Server 2000 with one 138GB database currently used. I am worry of the performance because as time goes it becomes slower and slower. So I tried googling out the solution and I found out the DBCC Reindex command. As what I read, first you have …

Is it possible to reuse an identity field value after deleting rows in SQL Server 2005? Here is an example. Suppose I have a table with an Id field as a primary key (identity). If I add five rows, I will have these 5 Ids: 1, 2, 3, 4, 5. …

Please help me in the following question: Given the following three tables Table 1: specialization (name,department) Table 2: area (a_name,phone,address) Table 3: dep_loc (area_name,department) where the "area_name" attibute in dep_loc references "a_name" in area. Write a query to give a count of the number of people that work in each …

Hello, I want to change the datatype of a field from Varchar to integer in T-SQL. I tried something like Modify like you use in Oracle. ALTER TABLE tablename MODIFY COLUMNNAME Datatype. But its not working in SQL server.. Any thoughts.

Dear all experts im now creating a rating system with php using mysql databse, im facing the problem about how to calculate rating!, ex. i have totalscore and numofvotes table, which function that we can use to calculate rating like, 7.4, 4.5 something like that thanks in advance

if i have roughly 25 identical tables is it possible to do the following SELECT tm_name, `tablename` as Activity from t1, t2 ,t3 where date = curdate or would it be better to add another column to the table thats hidden from the users and automatically populate with the tablename.

I created an instance and did some fault while moving the files from one location to other and now the server doesnt start and i need to execute a query in SQL SERVER Management studio in order to open a new query feature it again ask to start the server..the …

Hi, can any one explain me about d2k. what it exactly mean, and its use. I got an opportunity to work with d2k. i have knowledge in Oracle. How can I learn d2k? Thanq in advance.

Guys, Using this query, i got an error. any idea guys. what method should i used for this report. Im using text queries instead of SP. thanks. The variable name '@FromDate' has already been declared. Variable names must be unique within a query batch or stored procedure. Fromdate:'2012/06/01' FromTime:12:00AM Todate:'2012/06/29' …

Hi I have managed to set up a players database log-in with name number e-mail and am trying to get a buton on the players home page that when clicked adds one to thier total, Do I have to set up a new database for this or a new table …

Hi, I am in urgent need for converting sql procedure to postgre sql procedure.Please help me ASAP. CREATE FUNCTION sp_get_id_des (IN cellid INT, IN mcc VARCHAR(3), IN mnc VARCHAR(3), IN nwtype INT, IN mlac INT , IN mrac INT ) returns SETOF record AS' declare pscnt int ; declare cscnt …

Hello, sirs! I have got a SQL Database on one computer and there is another computer in a local network. I want the other computer have access to SQL-Database by real time, but not able to modify it. And one more thing, is there any possibility to convert SQL-Database to …

I am developing an sql query to use to grab information from a postgres db. The scenario is as follows: the database I am grabbing information is the backend postgres database of an application (Tableau). My objective is to pull all of the workbooks, views, and datasources (considered objects) that …

We store a list of keywords in the database as a comma-delimited string. I want to use Sphinx to query against the field, but I'm worried that the keywords would all be treated as a single word since there are no spaces. I went ahead and edited the MySQL query …

Hi, If i want to create a user in MySQL only to allow the Php program file to access the database and show results in my website what priviliges should i give to the user. So that access to my database is never compromised if someone can get the password …

Subject: System Analysis problem... We have our project in Systems Analysis ang Design this semester, and our preliminary step is to conduct and interview to study the existing system of our prospect organization. I know we are about to focus the interview on the system, but, I REALLY DONT KNOW …

Hi, I have email which contains some data and i want to update that into a database using MS access 2007 need help on creating a form and a database in MS access 2007 would appricate if some one can help me from scratch as i am noivice when it …

I have two tables. One with orders and one with lines items for the orders. The line items have a unique code that relates to the line item number. When sorting on this unique code, you are able to see the order in which the item was added to the …

Ohayo I Hav a Doubt regarding the storage of database.. Suppose i have a college database...among Master Model Tempdb MSdb were do i store this college database??in master?? even if i create a new database how to add the new data into the existing database??

Hey guys so for a class of mine we have to build a program for a client that is going to require a Database. The database is going to be purely for demo purposes so an actual server is not necessary. Now I have never done this before and I …

Question: Does anyone have any recommendations that are likely to keep a large database healthy/speedy? I'm designing a database that is going to retrieve around thirty million data points a year, up to around three hundred million to a billion in a few years time when all of the sensors …

I want to know, is it possible to use a mySQL database simultaneously from a PHP website and a Java Website both making continous read and write operations. Are there any tradeoffs? Does connection pooling affect this?

in this code- CREATE TABLE `tablename` ( `id` int(10) unsigned NOT NULL auto_increment, `a` varchar(10) NOT NULL, `b` varchar(45) default NULL, `c` varchar(45) NOT NULL, `d` varchar(45) default NULL, PRIMARY KEY (`id`), KEY `Index_a` (`a`), KEY `Index_bcd` (`b`,`c`,`d`), KEY `Index_cd` (`c`,`d`) ) ....; what do the lines that start with …

# Hello every bodyI'm new to database modeling, my teacher asked me to choose a government institution and design/model a database for it using ERD modeling. I need help on creating the business rule and identifying the entities, I can add attributes once I create the business rule. I choosed …

Hi, Guys i need a simple help from you guys. There's a scenerio that i m sure is very common in mysql and i know most of you can answer that but i m new to mysql so need some basic polish. so my scenerio is that for example i …

I need query tool, which has one simple function - to be able to execute different queries not commending out another queries. This is so annoying, how those another software can not have this simple feature, like pgadmn does not have (I guess), dreamcoder does not have, have just tried …

It's my first time to use oracle and i'm kinda lost :S I'm using netbeans v6.8 and i want to make a connection between Oracle 10g DB and java to make my program insert and retrieve data from the db - i tried searching for oracle's libraries to include it …

hi have a nice time, guys can you provide me a complete list of orcle queries (SQL / PLSQL)

Sorry, I don't know where to post this one. I would like to try executing an SQL Injection on a site (offline) i created with wamp. Just like to test the security of my site and try sql injection at the same time. If this kind of post isn't allowed, …

Hi guys... I am developing an windows application in c# with sql server as back end with windows authentication i want username and password for sequrity purpose can i set username and password without changing it to server authentication. Thanks in advance.

HI there, I am doing my internship with accenture and i got my first assignment. Basically i first thing with this task is i need to find way to modify the query so that it will pull only the data that has existed/activated more than one hour. This is the …

Hello, I have two tables one for the customer_records and one for the jobs. Both tables are linked together(both contains customerID and foreign key is set) I am trying to insert data into the job table by obtaining the customer ID that is given in the textbox. I have: INSERT …

guy plz help me out with this. If i have a table, in the table is a column called veh_status, the row data will be varchar storing one or many comma seperated numbers so veh_status could be 1,2,3 each number represents an id to the relevant vehicle statuts name and …

Please help me create views and generat report using only MySQL manager thank you

Hey, I am having a really annoying problem when trying to set up a foreign key in my database... I have two tables - Sell and Category I want the 'c_id' from the Category table to be the foreign key for 'p_id' in the Sell table. Both tables are InnoDB …

Hi all I'm struggling with a MSSQL database that, ultimately, I want to get into MySQL, but for now I just want to import to a local server. I know nothing about MSSQL, but I am pretty familiar with MySQL. I have a .bak file exported from my current hosting …

Hello: I'm trying to get a record from mysql based on the query of another the queries separately: set @row_num = 0; SELECT @row_num := @row_num + 1 as row_number,queue_num,clientID,customerid, todays_date, request, details,status FROM queue_sys ORDER BY todays_date; outputs row_number queue_num clientID customerid todays_date request details status 1 14 44DWS …

hi, SELECT Sum(acpt_qty),mat_code1 FROM view_mrir_esd GROUP BY mat_code1 SELECT Sum(net_qty),mat_code1 FROM view_bom_total GROUP BY mat_code1 these 2 queries are giving the actual report, but when combining these queries like SELECT DISTINCT view_bom_total.mat_code1,Sum(net_qty),Sum(view_mrir_esd.acpt_qty) FROM view_bom_total inner join view_mrir_esd ON view_bom_total.mat_id=view_mrir_esd.mat_id GROUP BY view_bom_total.mat_code1 giving the wrong acpt_qty and net_qty. Please advise …

I'M just trying to work my way through the book "Head First SQL" but I can't seem to get it installed. I just need the simple DOS like pompt MySQL program to learn on. Here's what I'M getting when I try and install it. mysql-server-5.5-winx64:6 - Looking for valid template …

Hi Guys, My requirements: How do I get the overall average for the transaction given for every month. My Query: This is the last part of my CTE Query ) Select Partno ,SUM(Case When TransMOnth='January' Then Usage2 else 0 End) As Jan ,SUM(Case When TransMOnth='February' Then Usage2 else 0 End) …

Hi, I am building a database for an institution. However, I will love the database to intimate the operator of birthdays of those in the database using vb 2008 and sql server. My query for the sql server goes thus: select Surname, Other_Names, Mobile_Phone from Parishioner_Adults where WHERE day(Date_of_Birth) =day((GETDATE()+15)) …

Hello all, I'm hoping you can help me with my first search engine/join query. I have 3 tables with differing numbers of coulumns - clients, projects and tasks. Table "clients" with the columns "cid", "client" and "date" Table "projects" with the columns "pid", "cid", "projects" and "date" Table "tasks" with …

G'day folks, My sql server 2012 database is plodding along happily with its custom online store. Yesterday it's primary key incremental column jumped from 60681 to 61678 then resumed incrementing by 1. It is now up to 61686 and chugging along again. No apparent harm done but very strange behaviour. …

How would I go about importing several CSV files into a single table? Any advice is greatly appreciated!

I'm extending a website built in ASP.NET to display Spiceworks reports - basic SQL queries. The easist way (with my knowledge) is to connect to the Spiceworks db through both Management Studio and Visual Studio. I have therefore followed this '[how to](http://community.spiceworks.com/how_to/show/2271http://www.)' in this forum, plus a few others, to …

Hi, I have want to build a database with car parts. The problem is that the car part can fit the car but from year 2000-2004 and not only just one year like 2001. For example: Make Model Part Year Toyota Camry Mirror 2000-2004 The thing is that the mirror …

Hello, if you can help with a query about coursework here the condition Requirements: The base is WordPress. The aim is to survey. Each user registers and selects names of courses they want to attend. Explore the structure! A. For each course, how many people have written? 2. For each …

I know this is a simple quetsion but I am stuck. I need to create a view that displays the discount house price by 5%. CREATE VIEW v_hou_discount AS SELECT hou_price - (hou_price * '.05') as '5% Discount Price' from house; What am I doing wrong?

long blob size is way too small for me. how can i make it bigger??? i want thing when i making col image. i can set Attributes to or lenth/value? but i dont know what to type in help plz

Good evening I'm running a tipping competition, and am hoping to make the updating slightly less tedious. The code currently reads as follows: <?php $query = " SELECT SUM(comptipsterselections.profit) as Profit, comptipsterselections.stable, comptipsterboard.link FROM comptipsterselections INNER JOIN comptipsterboard ON comptipsterselections.stable=comptipsterboard.stable WHERE comptipsterselections.comp = 'aintree 2010' GROUP BY comptipsterselections.stable, comptipsterboard.link ORDER …