2,935 Topics
 | |
| | 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)) … |
| | I'm a bit of a beginning to PHP, so I hope that this question isn't too terribly simple. I'm trying to write a flexible query that will use data from an HTML form to create a SELECT statement for a MSSQL database. I've tried writing a sample query, but I … |
 | Hello, First I apologise if this isn't the right forum... I have a vbscript that is non-asp. It is run in a program called EFI-Logic that is an ERP. EFI-Logic caonnects to our MSSQL database for normal operation. The problem is that on some computers I get the following error: … |
| | 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 … |
| | I am new user I have a system which has Apache2.2.4, PHP 5.2.3 in windows xP proffessional service pack 2. My MSSQL server is in remote place . I have access to the server by using the windows authentication only. when I use script $host='mass.com '; $user='gs\amk123'; $pass='Almn!2345';( windows password …  |
| | 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 ? |
| | Hi guys! I've never used SQL Server before and I don't want to fall at the first hurdle. SQL Server is installed and connected to the server but how do I go about actually creating the database? I am developing a web based database using dreamweaver and asp.net. Do I … |
| | I have a table on an offline database having let say 2000 rows and same table on an online database with let say 3000 rows. Now I want to copy just those records (1000) from online database that are not in the offline database table. Also, both tables have same … |
The End.