You must Sign In to post a response.
  • Category: SQL Server

    Select statement in sql

    hello

    i have to show all columns of table that user select at runtime ..and i want to skip a particular column that is present in every table..i dont want to show that column to user..how to skip a particular column in 'select statement '
    and show rest all columns data to user

    as it is not known at design time tht which table user will click..

    kindly help
  • #430946
    In this case you need to mentioned the field name while executing a select statement.

    Eg: Select column1,Column2,Column5 from table name.

    Where the column3 and column4 are missed from the table while selecting.

    Regards,
    Manick

  • #430956
    Developer should be select required columns--No functionlaity is there like to skip perticular columns.

  • #430967
    hi,

    simply use the column name to select in place of *


    Select column1,Column2,Column5 from table

    Thanks & Regards
    Anil Kumar Pandey
    Microsoft MVP, DNS MVM

  • #430969
    try
    select c1,c2, from table.


    don't forget rating...

  • #430980
    hi,

    select <columnname1>,<columnname2>,<column4>,<column5> from <tablename>

    here hiding column 3

    enjoy coding.....
    with regards
    krishnavenikaladi

  • #464423
    hi
    Specify columnnames

    Select id,name,address from table1


  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.