2,736 Topics
| |
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 … | |
Hi all, Just a quick question: I have my website done and the database I used is MS Access. Problem is MS Access' return of results are really really really slow. Now I want to shift to SQL server, but the web hosting site we paid does not support this … | |
Guys I need to upload an image on SQL server 2000, I dont want a C# or VB code for that I just wana know if it is possible to just upload a picture straight to SQL server without the insert statemt coz I have loads of images I need … | |
Hello! I want to use the following code [code=sql]SELECT * INTO Persons_Backup IN 'Backup.mdb' FROM Persons[/code] But all I ever get is the error message: "Incorrect syntax near IN" How could I solve this? But when I miss the IN clause, it works perfectly. I think the problem is that … | |
I am using MS SQL server, and I'm trying to create a SQL query that adds data to a "Reminder" table if data in the "Occurrences" table meets certain criteria. This might be a little difficult to explain. Here's the problem... I have a table "Occurrences" which i updated every … | |
I need help with joining these two tables: Table1 idx idy --------- one 1 two 2 tree 3 Table2 idy u ------- 1 a 2 b 3 c 4 d 5 e 6 f I want to show rows from the Table1 that have idx=one joined with all the rows … | |
Hii Group, This is samuel Like to hav a small suggestion from you hope u ppl do. "[B]I would like to copy dat from one table to another of the same database in a give timestamp,I mean when system time equals to the feild time then the entire data should … | |
Hello, I have question about backup and restore procedure for MS SQL 2000. If I make a full backup on Saturday and Transactional backup on Sun - Friday. When restoring I know sequence matters but what if I make a mistake and select transaction log out of sequece to restore. … | |
Hello, I am trying to setup log shipping for SQL 2000 database. I don't see option to "specify the transaction log share". According to MS Log Shipping instruction, "specify the transaction log share" screen shows up if I have specified that the plan will install log shipping. Where do I … | |
Help I want to learn how to connect SQL to my java program? is there any free online tutorial? help my please.. | |
The following query: [code]CREATE PROCEDURE GetDistance AS SELECT a.ZIPCODE, a.CITY, a.STATE, ROUND( (ACOS( (SIN(c.LATITUDE) * SIN(a.LATITUDE)) + (COS(c.LATITUDE) * COS(a.LATITUDE) * COS(a.LONGITUDE - c.LONGITUDE)) ) ) * 3963,1 ) AS distance FROM Zipcodes a, Zipcodes c WHERE ( ACOS( (SIN(c.LATITUDE) * SIN(a.LATITUDE)) + (COS(c.LATITUDE) * COS(a.LATITUDE) * COS(a.LONGITUDE - c.LONGITUDE)) … | |
I am an amateur when it comes to Advanced SQL but here is the situation. I have a Test Table with data such as below: Name(char) Qty(number) Date (char) Location (char) Test1 1 11/14/08 10000 20050 Test1 1 11/14/08 10000 20100 Test1 1 11/14/08 10000 20000 Test1 1 11/15/08 10000 … | |
Hi all, I have a server in our network contains the database of the project (SQL Server 2005). Suddenly a developer computer couldnot connect to the database which in that server. and now another computer did the same. The strange is the designer computer which still connecting to the server. … | |
Hello, I have an application that uses BLOB for files in MSSQL 2000 database. I do a full backup once a week and transactional backup everyday. Does transaction backup includes BLOB? If I restore transaction backup is it going to restore BLOB as part of the table. Thanks, DC9 | |
Hi Fellows, Well. let me start by higlighting the problem i face.I have two columns namely PID which is the primary key and also a auto number.The second is Serial No. which is also a auto number. The problem i face is that when i submit my form spcifying a … |
The End.