如何使用SQL定义的函数的领域？ [英] How to use sql defined functions as fields?

问题描述

我在SQL Management Studio中2012使用SQL创建表。如何使这在SQL Server中USER_ID例如USER_NAME，已定义的字段或列与名称。我想用他们作为我的表中的字段。

I am creating tables in Sql Management Studio 2012 using SQL. How do I make fields or columns with names that are already defined in Sql Server e.g User_ID, User_Name. I want to use them as fields in my tables.

从的复制帖子：

create table Ticket(
  Ticket_Id varchar(10) not null,
  TicketType_Id varchar(3) not null,
  Ticket_PurchaseDate DateTime null,
  LottoDraw_Id int null,
  User_Id int null,
  Ticket_IsWinner bit null
  Primary Key(Ticket_Id,TicketType_Id)
)

推荐答案

经列名像括号[] ...如

Warp the column name like in brackets [ ] ... such as

create table Ticket(
  Ticket_Id varchar(10) not null,
  TicketType_Id varchar(3) not null,
  Ticket_PurchaseDate DateTime null,
  LottoDraw_Id int null,
  [User_Id] int null,
  Ticket_IsWinner bit null
  Primary Key(Ticket_Id,TicketType_Id)
)

这篇关于如何使用SQL定义的函数的领域？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！