Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. zhonghandle

    Loading CSV File

    Hi, I am trying to load the following csv file: C1,C2,C3 1 ,M ,5 2 ,W ,1 3 ,M ,8C Where C1, C2 and C3 are column names. When I load the file using Microsoft.Jet.OLEDB.4.0, the table in SQL server looks like the following: C1,C2,C3 1 ,M ,5 2 ,W ,1 3 ,M , Which 8C missing. Can anyone tell...
  2. zhonghandle

    Materialized view appending two tables

    Hi, I have two tables (t1 and t2) of same structure. The contents of two tables are different. Now I have to create a materilized views that append t1 and t2 together. Since materilized views do not allow 'Union', do anyone has a way to handle this or know any work-arounds? Thanks alot in advance!
  3. zhonghandle

    A DTS running 'Transac-SQL' Question

    Hi, I am using a DTS package-ActiveX task to call a SQL server database through a MS provided ODBC Driver, and my SQL statement has included a long Transac-SQl statement. In which a cursor is used. I can only use up to 69 records in the cursor, and the last 5 records loaded to the cursor were...
  4. zhonghandle

    making connections using Active X (VBScript task)

    Hi, Suppose I am currently connected to a database "data1" (not the local server), and I want to make a connection to one of the tables (say, the table name is "table1") using VBScript code in a DTS package. How exactly should I do that? I have tried to create a ADO object...
  5. zhonghandle

    change owner of table

    Hi How can I change the owner of tables from "owner" to "dbo" using a script or stored procedure? If I have 60 tables, it is inpractical to change them manually, so is there a way to change it all together? Thanks in advance.
  6. zhonghandle

    Update Table Using DTS

    Hi, How to update a table using DTS? Say if I want to change all records of column c1 of table t to be 1, what should I do? Thanks~!
  7. zhonghandle

    MINUS in SQL Server

    Hi, Is it possible to do a MINUS option between tables in SQL Server? Like, (Select * from tableA) MINUS (Select * from tableB) assuming that both tableA and tableB have same number of columnes? Thanks alot in advance.
  8. zhonghandle

    Column accessing through a column variable

    hi, I am running into a problem that, suppose table A has 10 columns and I want to access one column each time, at the same time keep track of what column that is. For example, I will get all the data from column "c1" and put the summary of the data, say "15" into table B...

Part and Inventory Search

Back
Top