Search results for query: *

I have a flat file that I need to set up a DTS to extract the data and add to my SQL Server database table a few times a week. I'm running into a problem: insert error, column 1 ('id', DBTYPE_I4), status 10: Integrity violations; attempt to insert NULL data or data which violates contraints...

I have 3 tables that go like this (more or less): TABLE 1 ID NAME CITY ST 1 J. Doe Boise ID 2 W. Smith Tampa FL 3 B. Jones Atlanta GA TABLE 2 ID SPOUSE INCOME DATE 1 Mary 55000 1/1/2004 2 Bob 74000 1/14/2004 3 Tina...

I was told my someone recently that if there is no value to insert into a sql field, you should NOT let it be NULL, rather just insert a "" (blank) because SQL processes for NULL values last. Is this true, or am I not making any sense? :) [bugeyed] rexolio@yahoo.com "I'm not dumb. I just have...

I have a table with about 350,000 records. The Index/Primary Key field is called NameID. If I perform a query without specifying order, the results pop right in. If I do a query where I ask it to list the records in any order other than the NameID (i.e. RecordDate, LastName & FirstName, City...

Does know what the following pop up error message means from SQL Server 2000 Enterprise Manager: http://216.53.190.158/untitled-1copy.jpg I'm so lost. I'm importing a CSV database with 2 number fields separated by commas into one of my SQL database tables. There's 1,702,267 rows and it gets to...

I have an archaic table with the following format: tblCATEGORIES NameID, Category1, Category2, Category3, Category4, so on Each record contains an ID (NameID) from another table and specifies whether that user/record has selected any of those categories. Each category is represented by a...

Recently my site is running like a turtle with 3 legs. I'm not sure what's going on. I didn't make any major changes to it. The site runs slow, I get timeouts from time to time. Virtually every page talks to a SQL Server 2000 database. One of the errors I've recently gotten is: Microsoft OLE...

Hi everyone, Got a SQL Server 2000 database table that has been around for ages with thousands of records in them. There is a field that holds budget information. Most of the time all entries go in like this: 10000 is entered for $10,000 15000 is entered for $15,000 However, the field type is...

Hi guys, I'm trying to run the following script, which fills in values for a drop down menu: <% formid = request.querystring(&quot;formid&quot;) Set rs = conn.execute(&quot;SELECT * FROM table&quot;) do while not rs.eof if rs(&quot;formid&quot;) = formid then formselected = &quot...

I have a form where members of my web site can fill out information, including up to a 1600 character description, and post it to our site. The info is stored in a SQL Server 2000 db. Usually I don't have any problems with this form. But occassionally I run into a problem. Here's how it works...

Sorry if I'm not using the right terminology (i.e. subdomain.) With our web site, we're wanting to be able to create subdomain name sites for members. For example, if our web site address is: www.ourcompany.com, we want to be able to offer sites for our members/clients like...

Hi all! First, I am not a SQL Server 2000 expert. I'm just a web developer. However, much of the time I find myself having to look into problems with our database because our network administrator/web host is limited in his knowledge of SQL Server. Now, that being said, here's the problem...

Hi everyone, First, I am not a SQL Server expert. I'm just a web developer. However, much of the time I find myself having to look into problems with our database because our network administrator/web host is limited in his knowledge of SQL Server. Now, that being said, here's the problem...

Hi all, I have a form where sales people enter their new contracts include 3 different billing fields. At least one of these billing fields must contain an amount other than zero (our sales people are bad about entering contracts without the amounts.) All fields are default to &quot;0&quot...

We have a program that sends out emails to subscribed members. The emails are stored in a SQL Server 2000 database. The script we use is initated by a client via the web browser using ASP. We're beginning to find it harder and harder to keep our database clean of bad email addresses. I'm having...

I have some banner ads on my company's web site that animate. Have had banners on our site for a long time. Recently someone who purchased some banner spaces said that none of the banners move. When they refresh, new banners appear, but those too do not move/animate. I haven't heard of this...

Here are my tables: tblClients ---------- ClientID (Identity Integer field, Index and Primary Key) FName LName Blah blah blah tblClient_Markets ------------------ ClientID (Int field) MarketID (Int Field) BOTH ARE THAT TABLES PRIMARY KEY When I try to create a one to many relationship from...

Working on a project for my company and I'm very LIMITED in my knowledge of ASP. Usually I can find a way to get something done, but in this particular project I need to be proficient as possible so the page loads quickly. I need to be able to show in the web browser via ASP How many Markets...

Hi all, I've been doing the majority of the work for my company web site for the past 3 years. Our web site is very large, supported by a SQL Server 2000 backend and scripted predominately in ASP. We've grown to the point that running the site, doing database administration and adding new...

We have a web site that runs from a database backend (SQL Server 7.0). I do most of the frontend work, but don't know what I need to know about SQL Server. My company is wanting to hire someone to go through our database and make sure tables are set up appropriately, i.e. relations, id's, etc...