E语言怎么写SQL这个查询与修改！急求！

hack444

USE [123]
GO
/****** 对象:  Table [dbo].[tConsole]    脚本日期: 04/09/2011 19:02:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tConsole](
        [sConsole0] [nvarchar](32) NOT NULL,
        [sComName0] [nvarchar](16) NULL,
        [iComIP0] [int] NULL,
        [sComIP0] [nvarchar](16) NULL,
        [sComMac0] [nvarchar](16) NULL,
        [iBindType0] [tinyint] NULL,
        [sVersion0] [nvarchar](16) NULL,
        [sBuild0] [nvarchar](16) NULL,
        [sViewClients0] [nvarchar](max) NULL,
        [nRights0] [varbinary](max) NULL,
        [sTeamGUID0] [nvarchar](64) NULL,
        [sGUID0] [nvarchar](64) NULL,
        [sRemark0] [nvarchar](128) NULL,
        [nHandOver0] [varbinary](max) NULL,
CONSTRAINT [PK_tConsole] PRIMARY KEY CLUSTERED
(
        [sConsole] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

谁知道？这么写！会的可以留给交流联系方式！ 教会 有红包回报！急急急！！！