Getting Started with Adobe After Effects - Part 6: Motion Blur
Ask
Ask questions, discuss or help others by answering
Related Posts · View All
SQL Server 142
TSQL 76
SSRS 70
SSIS 66
XML 54

Top Categories · View All
SQL Server 142
TSQL 76
SSRS 70
SSIS 66
XML 54

sql server

May 2 2012 12:00AM by asrinu123   

Hi friend i have small doubts in sql server plz give answers

suppose iload data from one table to another table .that time data load incorrectly.why data come incorrectly .table 1 columns like id,name,sal and table 2 also same id,name,sal. table1 data like

id,name,sal
12,dfg,1200
13,ueno,560
15,tend,9850

actually table 2 data is empty before loading data when ever i load table 1 data into table 2 that time . table 2 data like

id,name,sal
? ,?    ,?
? , ?    ,?
? ,  ?   , ?

why its occured .is there any reasion. what mistakes i done.plz tell me why its come likde this way.

Submitted under: Microsoft SQL Server · TSQL ·  ·  · 


asrinu123
412 · 0% · 96

4 Replies

  • There can be a lot of reasons I need more details. How are you loading the table. If ssis which transforms. Are there any triggers set?

    commented on May 2 2012 11:10PM
    Sudeep Raj
    12 · 13% · 4297
  • in sql server when ever i try to load from one table to another table that time its occured. which sistutaion its load incoorectely.plz give some sugestations.

    commented on May 3 2012 12:48AM
    asrinu123
    412 · 0% · 96
  • How are you loading the data from one table to other? Are you using some query? How do you enxpect an answer by the description you have provided.

    commented on May 3 2012 9:17AM
    Sudeep Raj
    12 · 13% · 4297
  • One reason I can think of is that the source table has UNICODE data in NVARCHAR columns and the target column is VARCHAR. This can cause the problem mentioned in this thread.

    commented on Aug 11 2012 1:25AM
    Jacob Sebastian
    1 · 100% · 32004

Your Reply


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]