2,736 Topics
 | |
| | Hi, Simple query: [code]select * from MyTable where Id=123456;[/code] The first time I execute this query it takes 14 seconds. However, the second time I execute it takes 0 seconds. I wanted to clear the cache so the second execution takes 14 second just like the first execution. So i … |
| | |
| | I need help to write a stored procedure, or pseudo code, that looks into a table named numbers_ranges and retrieves the next unused value. The table currently has the following data: Columns are: id, start_range (22), end_range (22), status (1), date_created (datetime), date_updated (datetime) 1 8057777777450780000000 8057777777450780000010 N 2007-11-29 16:28:46.793 … |
| | Hi, A third party development company is creating a third party application for us in PHP and uses a MYSQL database. The app is an extension of our website which is developed in .NET and uses a MSSQL 2005 database. There are some cases where the two databases require connectivity … |
| | Hi all, I'm currently finally starting mysql and am have difficulty getting it up online. what i've done so far is correct but only for this error: Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to MySQL server on 'www.dteeducation.ie' (61) in /usr/www/users/adv123site/home/youruser/public_html//settings/database.php on line 10 Cannot connect to database, check if username, …  |
| | Hi , Hey I have a small problem.... For a certain field in database, tha values are sent from front end(JSP page) . Each individual value must be extracted and then inserted into the database..... Before inserting, we have called a procedure which will extract each value and insert.... Moreover … |
| | Hi guys! I was wondering if comeone could help me with transferring data from one table to another. I am storing information of all customers who make an enquiry (PotentialCustomers) then transfering their details into a Customers table if they decide to purchase something from the company. How would I …  |
 | I would like to know how to apply Constraints after creating a table. I was just practicing and creating a database HomeInventory by reading the free e-book from Microsoft. But I'm trying to implement the functions using T-SQL. So How can I do so? [code] CREATE DATABASE HomeInventory USE HomeInventory … |
| | We have a SQL server on a DL380 with 8GB of RAM and 2 processors. This should be enough to host a couple of databases. When I'm on the same LAN as the server (on the outside of the firewall) a select * from [tablename] returning 12000 records takes less … |
| | hi am raj! am a asp , sql server 2000 programmer i need a sql query to select unique rows based on noofcards,versionno,id here am giving the database ------------------------------------------- id email ccno vno nc ------------------------------------------- 41 [email]b@r.com[/email] f 2465 1 1 41 [email]b@r.com[/email] f 9898 1 3 41 [email]b@r.com[/email] a … |
| | Has anyone installed it? I've downloaded both express and full developer edition but I can't get past the user account stage. Can someone give me valid userID's and passowords for it? I don't have a password on my user account though.. |
| | hello there... i need help with cross tab query with sum(case actually iam using ms access 2007 and vb.net 2005 i have problems with the sintaxis ill paste the code below: TRANSFORM SUM(cantidad*(case tipo WHEN 'Entrada' else 1 then 1 end 0)-cantidad(case tipo WHEN 'Salida' else 1 then 0 end)) … |
| | Hi every one, I am Working On SSRS, In Reports I am Showing One Column As A Paragraph , Eg: ApplicationSIPNTCCBApproved, May 8 2007 7:05AM ApplicationICCBApproved, Feb 12 2007 1:42PM ApplicationAITApproved, Nov 6 2006 7:24AM ApplicationCRSubmitted, Oct 14 2006 8:42A I need To show It in new Break line ApplicationSIPNTCCBApproved, … |
| | HI all i want to use the apache torque tool to connect to the ms sql server 2000.As i am a beginner can any one advise me from where to start to understand the working.Any pointers in internet or any books will be appreciated. Thanks Umadas |
| | Hi, I work in a university library in the music area. I'm not really a tech person, but I've been working with a programmer to create a mysql database for the library's streaming audio service. We are streaming with Real Media files. We would like to generate SMIL files automatically … |
| | I'm having trouble with the following scenario: drivers may have any of the 16 types of certificates, tasks may require any of the 16 types as well. What I need to do is build a query that will selectd all the tasks a certain driver can perform. Example: driver has … |
| | Hello All.. I am a new Member in this forum, and Iam new user to SQL Server Express. I need to make instal to my project . my project C# with DB sql server express my Question is: How to make instal the sql server express with my project to … |
| | hi, i am using vs.net 2003 and mssql 2000. currently my db size is 2.5gb including DB transaction Log File. For (.BAK extension) is 1.55 gb. May i know how to expand or improve my DB because when it reach the size (2.5GB). i will always get error message : … |
| | We have an Access database that another department is taking over and considering switching over to FileMaker and using on our website (which we manage) with Sequel but - we have heard there are problems with using FileMaker with Sequel....does anyone know if this is true? and if so what … |
| | Is it somehow possible to retrieve a string and then convert it into a mathematical expression? for example i have this string '14200 * 5' and then i want to convert this into a mathematical formula so that i could get the result of it which is 71000.. .. i … |
| | Hello, I have a quick question. I'm currently using MS SQL 2005. I have a main table which has many fields. I created a view#1 which imports all the rows from the main table but I only select the "City" field, "PurchaseDescription" field and a "Cost" field. Only the city … |
| | Hi guys, I have two tables one for that holds Customers details and one that holds Potential Customers details. The Potential Customer table is needed so the company can see who has enquired about the products but not bought them. I need to be able to automatically transfer details from … |
| | Greetings, I've posted this question in other news groups (msdn and a few others) without any response.:sad: I hope I don't get into any trouble for posting this question here, but I reach out for your help.:confused: I have an excel file stored in a data base table as an … |
| | Hoping someone can shed some light on this one, using MSSQL 2000, I have a query like this; Select T.TransactionRecordClass, T.ClassDetail from [remoteserver].otherdb.dbo.Data T where T.TransactionRecordClass like '10000002%' which will return around 10000 records in under 1 second. My issue is that I need to make this part of a … |
| | Hi, I have a problem. I have questions, to a question there can be arbitrary groups and to every group there can be arbitrary conditions. To have permission to “see” an question you have to have at least one condition from every group which is in the question. I have …  |
| | my second thread of the day... hey guys, I was wondering if someone could help me. I am new to SQL Server therefore new to T-SQL, I have worked with SQL before. I am trying to reference foreign keys when creating tables. The code I have in SQL is :- …  |
| | OK.. I want to start trying to develop a web app using an SQL Server 2000 database. The only language I know comfortably (but not totally) is VB (although VB.NET is giving me lots of problems). What should I use to develop this program? Dreamweaver? Visual Studio.NET has web development … |
| | Hey guys! I am new to SQL Server and as I am still a student I have never created a database completely from scratch before. I believe that at the very start of development I have to create the database with the following code:- [I]CREATE DATABASE <database name> [ON [PRIMARY] … |
| | Hi , I use MSsql server 2005 with the compatability mode set to 2000.One of the tables, has an IDENTITY Column.I need to restore a earlier backed copy of the table.So, i did the following : set IDENTITY_INSERT MYTABLE ON insert into MYTABLE(ID,NAME) values(23,'XYZ') However, i get the following error … |
| | i wanna see all sql instance in local ? and wanna know their connection string ? |
The End.