Results 1 to 5 of 5

Thread: Data Storage Problem in SQL Server 2008

  1. #1
    Join Date
    Feb 2010
    Posts
    678

    Data Storage Problem in SQL Server 2008

    Hi all,

    I will build a project that in VB.net . I am using a Sql server 2008 as a backend. When I loading a large customer catalogue data from text files, it gets slow down. My data file is in CSV and tab delimited. Can anybody suggest me how to enter bulk data in SQL server 2008. Please suggest. Thanks.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,948

    Re: Data Storage Problem in SQL Server 2008

    Data files that hold identity values can be bulk imported into an occurrence of Microsoft SQL Server 2008. By default, the principles for the identity column in the data file that is bring in are ignored and SQL Server allocate unique values automatically. The unique values are based on the starting point and increment values that are particular during table creation.

  3. #3
    Join Date
    May 2008
    Posts
    2,012

    Data Storage Problem in SQL Server 2008

    After data is imported into a table, the bcp command and BULK INSERT statement watch any defaults that are distinct for the columns in the table. For instance, if there is a null field in a data file, the defaulting value for the column is loaded in its place. The bcp command and BULK INSERT statement equally permit you to specify that nulls values be reserved. In difference, a regular INSERT statement retains the null value in its place of inserting a default value. The INSERT ... SELECT * FROM OPENROWSET(abc) statement supply the same basic performance as regular INSERT but as well supports a table clue for inserting the default values. check it out and reply.

  4. #4
    Join Date
    Apr 2008
    Posts
    2,005

    Re: Data Storage Problem in SQL Server 2008

    I will give you the examples that require that a table named MyTestcol2 be created in the MyWorks sample database under the dbo schema. To make this table, in Microsoft SQL Server Management Studio Query Editor, carry out:
    Code:
    USE MyWorks;
    GO
    CREATE TABLE MyTestcol2 
    (Col1 smallint,
    Col2 nvarchar(50) DEFAULT 'Default value of Col2',
    Col3 nvarchar(50) 
    );
    GO

  5. #5
    Join Date
    May 2008
    Posts
    2,297

    Data Storage Problem in SQL Server 2008

    You can use optional terminating characters that let you to mark the finish of each field in a data file with a field terminator and the finish of each row with a row terminator. Terminating characters are single to indicate to programs that read the data file where one field or row ends and an additional field or row start. The bcp command, BULK INSERT statement, and the OPENROWSET bulk rowset supplier hold up a variety of characters as field or row terminators and forever seem for the first case of each terminator. Best of luck.

Similar Threads

  1. Replies: 3
    Last Post: 03-01-2014, 11:55 AM
  2. Data storage problem on 2gb kingston microsd
    By Aloke in forum Portable Devices
    Replies: 3
    Last Post: 14-11-2009, 06:03 PM
  3. Enable external usb storage in WIndows server 2003 & 2008
    By Aadimoolan in forum Window 2000 Help
    Replies: 2
    Last Post: 22-06-2009, 05:01 PM
  4. Storage Server 2008 - unable to log in
    By -x- in forum Windows Server Help
    Replies: 2
    Last Post: 14-05-2009, 09:14 PM
  5. Windows Server 2008 and RAID Storage Managers
    By Dominick in forum Windows Server Help
    Replies: 1
    Last Post: 16-05-2008, 08:32 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,708,063.62762 seconds with 17 queries