Search:

Type: Posts; User: sundharmail; Keyword(s):

Search: Search took 0.01 seconds.

  1. Answers
    14
    Views
    36,947

    SQL Server - Re: How to view the structure of the table

    You see the table structure using SP_HELP..

    sp_help table_name
  2. Answers
    6
    Views
    2,922

    SQL Re: Dyamic SQL Queries

    Sorry Bhaski. I don't have idea in ORACLE
  3. Thread: Query

    by sundharmail
    Answers
    4
    Views
    2,380

    SQL Re: Query

    If it is SQL Server Then Use INTO functions

    SELECT TOP 0 * INTO new_table_name FROM old_table_name
  4. Answers
    6
    Views
    2,922

    SQL Re: Dyamic SQL Queries

    DECLARE @IntVariable int;
    DECLARE @SQLString nvarchar(500);
    DECLARE @ParmDefinition nvarchar(500);
    DECLARE @max_title varchar(30);

    SET @IntVariable = 197;
    SET @SQLString = N'SELECT...
  5. Answers
    3
    Views
    3,891

    SQL Server - Re: copy the Table Structure

    Using INTO we can copy..

    SELECT TOP 0 * INTO New_Table_Name From Old_Table_Name

    The Above query will come only the structure for the table..

    If U want to copy with the data then remove the...
  6. SQL Server - Re: how to take data in a one table from two different server ?

    Using LinkedServer concept we can connect & get the data's from the 2 different database or different servers..

    Using OPENDATASOURCE we can get it.

    Syntax:
    OPENDATASOURCE ( provider_name,...
  7. Answers
    14
    Views
    36,947

    SQL Server - Re: How to view the structure of the table

    using SP_HELP we can get it all the informations about the table..
Results 1 to 7 of 7
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact