sqlserver 2005 支持用户定义表类型吗?
sqlserver 2005 支持用户定义表类型吗?如果没有的话就郁闷了。。。 sqlserver
[解决办法]
搞那么复杂干嘛？用表变量就行拉
[解决办法]

CREATE TYPE dbo.SubCardTable as table
(
    [SC_ID] [varchar](50),
    [ZhuKaInfo_ID] [varchar](50),
    [Project_KeyName] [varchar](50),
    [SC_CardNumber] [varchar](50),
    [Statues] [int] DEFAULT 0,
    [SC_AddTime] [datetime],
    [SC_AddPerson] [varchar](50),
    [SC_Money] [int],
    [MainCardReceiveIntegral] [int] DEFAULT 0,
    [SC_RelationCustom] [varchar](50),
    [SC_UseTime] [datetime]
)