2,935 Topics
 | |
| | 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 … |
| | hi I am new in SQL Scritpting and my question might sound stupid, but please help me out to understand. Can one explain the difference between the two and similarity? The need and and use of the two? As for Temporary table does one create them or it comes with … |
| | Hi Guys, I have some confusing part in the sql command the question is i have 2 different query : a)[code=sql] Select SUM(T1.Amount+T2.Amount) as Total From TABLE1 T1 INNER TABLE2 T2 ON T1.ID = T2.ID[/code] b) [code=sql]Select Sum(Amount) as Total FROM TABLE3 [/code] the result if a) query is 100 … |
| | I have questionnaire that has two radio buttons(one is "Register" and the another one is "Drop") in it and all answers are saved in an SQL database. For Example ,when the user checked "Register" and then by clicking "Sumbit Page" the values stored in the sql database.When the user returns … |
| | I have two tables as below table 1 ProductID---Int Descritption---Text table 2 Id FK_ProductID--Int Category but on the FK_ProductID I dont want my table not to display a number but the description from TBLA. |
| | HI! I've got a problem... Given the schema below I need to create an SQL query, but for some reason I think there is something wrong with it.... BRANCH(BRANCH-NAME, BRANCH-CITY, ASSETS) Query: in what cities are the branches where the maximal bank assets are less than £200,000? So I've come … |
| | I have a problem in my SQL 2005 Data Warehouse. I'm using a slowly changing dimension data flow transformation in SSIS which will not delete any records from my DB when they are deleted from the source data. I need to keep the dimension keys, but in this one case/one … |
| | Hi All, I have to do a rather simple query, but a previous design error that did not make one of the fields required (it allows nulls when it shouldn't have) makes it a bit harder. I have a table projects and a table clients [B]Projects_Tbl[/B] ProjId ProjName ClientId [B]Clients_Tbl[/B] … |
| | i am working in sql 2005, i have problem in Sql collations. our database modified in different people, some time we get collations error. how to solve this error? and how to avoid this problem in my future? |
| | I have to tables as parent & child tables as below Table 1 TID1 Name 1 Test1 2 Test2 3 Test3 Table2 [U]TID2 || TID1 || ID1 || ID2 || ID3 || Name[/U] 1 1 1 2 3 All 2 2 2 2 2 All2 3 1 1 1 12 … |
| | I have several questions: Here is the context: The ASP.NET application I'm building - a web service in essence - will be connecting to MSSQL to log requests to a table. These are basic INSERT commands. During high-volume hours, do I risk race conditions? How does MSSQL handle sequential INSERT … |
| | can't solve a homework problem for computer class. Any clues?: Given two tables, USERS and LOG, where USERID is a primary key in USERS and a foreign key in LOG, write a SQL statement that will return LOG records (all fields) with corresponding USERIDs in USERS. The report should include … |
| | Hello Guys, I was dumped in the middle of a project with not a lot of experience in MS SQL server. I have 3 little questions 1) If i receive a bak file(restore file) from another server, is it normal that if i restore the file i will no see … |
| | Hi, In my Insert SP, I have 5 local variables: @MemberID int, @VideoID int, @Total money, @DateRented datetime, @DateDue datetime insert into RentalRecord values (@MemberID,@VideoID,@Total,GETDATE(), DATEADD(dd,5,GETDATE())) When I try to execute the SP, I get this error: Procedure or function 'sp_AddRentalRecord' expects parameter '@DateRented', which was not supplied. Please advise. … |
| | is it possible to convert system made from php with a database of mysql to ms sql database..? how? thaks |
| | Hi Everyone! I have to make a forum with MS SQL, and, as I'm Hungarian, we use characters, like áéíőúű, etc. Now, if I insert a text with the letter ő or ű, I get back o and u. How can I solve this problem? The users write posts in … |
The End.