Search results for query: *

I expect, however, that @Zippy might contain as many as 5000 Zip codes. Still recommend @Zippy nvarchar(some integer). Can you explain the SET quoted_identifer off is that really the meat of what I needed.

I am trying to set up a stored procedure that accepts a comma-delimited string and displays all of the records that their zip code located within that string. I have CREATE PROCEDURE dbo_GetContractors @WorkType varchar(1), @Zippy nText AS SELECT Zip, Search_Id, State, City...

I have two servers 1 NT4 trying to access a Win2000 SQL 2000 server. They are in the same Workgroup not domain. when I attempt to connect I get the following [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. The test DSN connection works...

I have a select statement that works fine with ACCESS from ASP but I'm trying to migrate to SQL Server 2000 and I'm getting an error with the folowing statement SELECT Zip, Search_Id, State, City, Company_Name, WorkType1, banner, bold FROM ContractorsOnly WHERE (WorkType1 = 'C' or WorkType1 =...

Code below. Okay forget the image map the really important thing is to stop the animation going on on the page. I need one function that evaluates whether the animation is active if it is then stop it by using clearTimeout(junk); if it's not animate the image using the IF portion of the...

Code below I need to change the imagemap name that is used after a person clicks on the image. I want to swap between image map1 and image map2 I am already swaping the image in the animate function. But how...I don't have a clue. So a little help please. Paul <SCRIPT> var img0 =...