none
Interview question on SQL Server

    Question

    1. How you will you load csv file with address field which is having multiple values in SQL.

    2.What is dynamic sql and if you want to print it before executing then how will you print it with formatting for readability.

    3.How will you separate the customer name from below file once it has be loaded into your staging tables

    Input

    @@#$$%ami$$%5689t78jh6789a

    @@#$$%so$$%5689t78han89a

    @@#vipin$$%5689t78jha6789

    @@#aru$$%5689t78jha6789a

    Output

    Amitjha

    Sohan

    Vipinjha

    Arunjha

    Thanks in advance

    regards,

    Vipin jha


    Thankx & regards, Vipin jha MCP



    Thursday, August 28, 2014 3:43 AM

Answers

All replies