Results 1 to 5 of 5

Thread: SQL Question Statement "With"

Threaded View

  1. #1

    Thread Starter
    Fanatic Member vuyiswamb's Avatar
    Join Date
    Jan 2007
    Location
    South Africa
    Posts
    830

    SQL Question Statement "With"

    Good Afternoon Guys

    i have the Following Query

    Code:
    SELECT * 
    INTO #Rows
    FROM OPENXML ( @doc , '/Timetable/Rows' , 2) 
    WITH ( 	ID int,
    	Descr varchar(64),
    	StartTime smalldatetime,
    	Duration int,
    	Offs varchar(64)
    )


    I understand the First Part

    Code:
    SELECT * INTO #Rows FROM OPENXML ( @doc , '/Timetable/Rows' , 2)
    but i dont understand Why With ? can someone Explain what is With Doig with Columns

    Thank you
    Last edited by vuyiswamb; Dec 12th, 2008 at 06:42 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width