如何在sql中创建子部分 [英] how to create subpart in sql
问题描述
我喜欢
adio =宝莱坞
=好莱坞-subpart
引用:我想为员工创建一个表,它包含3列
id < br $>
名称
地址
其中名称应包含3个子列,例如
firstname
middlename
lastname
然后你应该用6
创建一个表列{id,firstname,middlename,lastname,address}
并将{firstname,middlename,lastname}
汇总到'name'
在任何合适的地方(例如在返回name
和地址$的查询中c $ c>)。
它是这样的:
CREATE 跨度> 表人员
(
ID INT IDENTITY ( 1 , 1 ),
FirstName VARCHAR ( 30 ),
MiddleName VARCHAR (< span class =code-digit> 30 ),
LastName VARCHAR ( 30 ),
地址 VARCHAR ( 30 )
)
更多信息:创建表 [ ^ ] < br $>
获取FirstName
和MiddleName
和LastName
在一个列中,使用查询:
SELECT ID,FirstName + ' ' + MiddleName + ' ' + LastName AS PersonName,Address
FROM 人员
i have categery like
adio=bollywood
=hollywood-subpart
Quote:i want to create table for an employee and it contains 3 columns
id
name
address
where name should contain 3 sub columns like
firstname
middlename
lastname
Then you should create a table with the6
columns{id, firstname, middlename, lastname, address }
and aggregate{firstname, middlename, lastname }
into'name'
wherever it is appropriate (for instance in a query returningname
andaddress
).
It would be something like this:
CREATE TABLE Persons ( ID INT IDENTITY(1,1), FirstName VARCHAR(30), MiddleName VARCHAR(30), LastName VARCHAR(30), Address VARCHAR(30) )
For further information: CREATE TABLE[^]
To fetchFirstName
andMiddleName
andLastName
in a single column, use query:
SELECT ID, FirstName + ' ' + MiddleName + ' ' + LastName AS PersonName, Address FROM Persons
Note: you can use + operator[^] to concatenate strings, but i recommend tou use CONCAT()[^] function.
这篇关于如何在sql中创建子部分的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!