2,935 Topics
 | |
| | Hello guys. I'm trying to make a database about football games (results, managers, players etc.). For my Players table i want to include these stats: - first and last names, nationality, date of birth (constants through time) - games played the current season, goals scored, cards received, minutes played in … |
| | Hi, I am a beginner in Microsoft SQL. I want to create a fulltext index from a UNIQUE key. For that purpose I have the following code: [code=sql]CREATE FULLTEXT INDEX ON sample_table (data) KEY INDEX UQ__sample_table__59FA5E80 ON Catalog_data WITH CHANGE_TRACKING OFF, NO POPULATION[/code] This works fine. The problem is that … |
| | Hi, I am trying to copy som data from an excel document that I have on the server into a table in my ms sql server. I think the problem now is that I am having trouble connecting to the sql server. I'm using sql server 2005. You can see … |
| | how to select last record from a huge amount of database?can anyone help me with this? |
 | hey there lovely people, i am trying to make an application that makes database backups, now obviously i need to add the file / filegroup backup option too , which is not a problem except for this one little problem... How can i get the application to display a list …  |
| | I am transferring This Thread from java forum [URL="http://www.daniweb.com/forums/thread161727.html"]http://www.daniweb.com/forums/thread161727.html[/URL] i am edit table.....add column change_id And i want to write data...means update table..... [COLOR="Green"]original table[/COLOR] id user_id rating date_created 123 1 4 2008-12-09 211 1 3 2008-12-08 33 1 4 2008-11-30 45 1 3 2008-10-31 57 1 2 2008-10-31 666 …  |
| | Hey hey I have two tables with a lot of data, i need to insert certain column values from table one into table two - eg Table one column = First_Name Table two column = Name I need to get all the values in table one (First_Name) into table two … |
| | hi, i have one table called EMP with 3 fields SSN,ENAME,MGRSSN. query to retrieve all employees name and their respective manager names(only using this table no other table and ssn primary key. i know till here.. [code=sql]SELECT ENAME,??? FROM EMP WHERE SSN=MGRSSN ;[/code] here im only getting manager's name..so how … |
| | Hey there, i really want to break my pc by now can anyone tell me how to get around this ?? I just want to update the new database here [code] USE NGCOLLECT GO INSERT INTO dbo.Cases ( CustId , Consultant , Bank , OldAccountNo , LastAmountReceived , DateReceived , … |
| | Hey, I'm dealing with a problem I cannot solve because I have no idea why it doesn't work. I'm trying to store some XML into an MSSQL database, using TEXT as fieldtype. I pass the XML as one large string. I don't get any errors but the xml field in … |
| | I've mssql 2000 database is it possible to change it to 2005? |
| | Hi, For my assignment work I have to make 3 queries, and one of my queries includes a part that needs me to work out with orders have a total price above £70. Here's the code I have so far: [code=sql]SELECT SUM(Quantity*Price) As Total_Order_Cost FROM Orders JOIN [Product_orders] ON [Orders].Order_ID … |
| | hi, i need some advise regarding storage of data is it good to store data in files rather than storing into database? (eg data like comments or additional features of products that users advertise on our website.) will it help for speed optimization. |
| | Hi i need help on how to create a query so that the result will be like in my attach screenshot |
| | Hey guys, I'm currently testing my application with some scripts I have written. I'm using the following query to list known errors within my application, and the status of the tests that are are affected by each error: [code=sql]SELECT ERROR.BG_ERROR_ID, ERROR.BG_USER_03 as HardwareID, count (RUN.CY_RUN_ID) as NumAffected, sum (CASE RUN.RESULT … |
| | I downloaded SQL Server 2005 standard edition from MSDN. I tried to install it but the splash.hta and setup.exe don't work. When I click on splash.hta, northing happens. When I click on setup.exe I get the message "setup failed". When I uninstalled the standard edition and instead downloaded the developer … |
| | Hey can anyone give me the query to retrieve a list of databases on a server rather than this query [code]SELECT NAME FROM sysobjects[/code] which gives me a list of tables ???? Thank you |
| | was directed here by another member...great site! (am a newbie and I recently posted this on MSDN with 0 replies, am hoping someone can help here - you do not need to know VFP, just need help formatted a correct string that ASP will honor), Current Setup: Using: Visual Web … |
| | [code=sql]res = PQexec(conn,"BEGIN"); PQClear(res); res = PQexec(conn,"DECLARE myportal cursor for select * from test"); PQClear(res); res= PQexec(conn,"FETCH ALL IN myportak"); ---- ---USE THE RESULT SET ------- PQClear(res); res = PQexec(conn,"END"); PQClear(res);[/code] |
| | i have a project of Call Management System with database SQL SERVER,now i want to limit the connected users in my database in 55 connected users only,where in this 55users can only use the system and if there is 1 user trying to connect on my database the system will … |
| | G'Day all, I've got a plugin for an application. When it's installed it runs the following:[CODE]Alter table DocketItem ADD Optimised BIT DEFAULT 0 NOT NULL[/CODE] However, when the plugin is uninstalled it tries to run the following: [CODE]Alter table DocketItem DROP COLUMN Optimised[/CODE] When the plugin is uninstalled, I get … |
| | Hi We are going to be starting a new ASP.NET website that will use an MSSQL database and the database is likely to eventually fill up as each database has limited size. Is there a way to have a database overflow into a new database when it is full but … |
| | The following stored procedure is supposed to add a new record to the database OR update Mdescript if it already exists. However I keep getting errors such as primary key violations. Please take a look, many thanks :) [CODE=SQL] USE [COSHH2008] GO /****** Object: StoredProcedure [dbo].[CHSP_OR_ACTIVITYAREA_001] Script Date: 12/02/2008 13:59:33 … |
| | Dear Friends, I have created a dll in VB 6.0 and i am calling this dll using a trigger which is for INSERT record. But when my application inserts a record to the table, Trigger runs succefully but record is not inserted and gives this Error: Description: Receipt. Database error … |
| | topic continued from here: [url]http://www.daniweb.com/forums/post748453.htm[/url] |
| | I'm trying to display data in cold fusion but when I add my history table I get duplicate listings. I've tried select distinct different joins. How do i join my history table and not get duplicate listings My store procedure in MS SQL is [CODE]USE [Website] GO /****** Object: StoredProcedure … |
| | I have 2 related tables, master and a child, the master table have a primary which is an autonumber and I reference that autonumber to my child table as a foreign key so my problem is to get the value of the autonumber from a master table and write it … |
| | I have converted around 395 Excel survey forms to MS SQl database with that many tables. Well, I run a script to assign a primary key on all the tables on my database.First I set the column property to NOT NULL and then i assign the primary key to it. … |
| | I would like to create a variable in my trigger - @DBNAME. When the trigger executes, this value should be set to the name of the database it was executed in. E.g. for the master database the value of @DBNAME would be master. How would I go about figuring out … |
| | Hello, im a rookie i would like to connect to a MSSQL2000 server Retreive information post it on the website then detele it on a condition please help i have compiled this so far. [code=asp]<% '* database server parameters Dim serverIP '* ip adress Dim serverPORT '* ip port Dim …  |
The End.