SQL Server database programming

I have a simple, left-join view that returns about 10000 records. If I open the view directly in Access 2000 through the Database window, I can quickly scroll through all of the records in a couple of seconds. However, in a simple form based on the view without filters or sort, and set ...

Hello, I am using SQL Server 2000 as a back end. I receive Excel files with some information and i import that information into SQL Server. Now I have a problem with one of the fields in the file.One user sends it in format 'MAY ...

Hi Everyone, I have 3 tables: Telbook(Id:int,Name:char,address:char,comment:ntext,owneruserid:int), PK:id TelNumbers(telbookid:int,telno:char,telNotype:int,syscode:int),PK:syscode,FK:telNumbers.telbookid=telbook.id Teltypes(teltypes:char,fk:int),FK:telnumbers.telnotype=teltypes.fk ...

Hi, I have a multithreaded application where each thread executes a SQL Query which has same Cursor defined in it. Suppose if my declared cursor is as below: e.g. I want to access all the database names. So, I'll create following ...