當前位置:首頁 » 編程語言 » sql合並兩列

sql合並兩列

發布時間: 2025-05-10 07:07:01

1. sql 將兩列的數據合並在一列

selectxxaszzfrom表unionallselectyyfrom表;

2. SQL語句拆分表中內容,並變成兩列

if exists (select 1 from sysobjects where name = 'uf_get_value' and xtype = 'FN')
drop function uf_get_value
go
create function uf_get_value(@value VARCHAR(100))
--獲取列默認值
returns VARCHAR(100) as
begin
declare @rtn VARCHAR(100), @tmp VARCHAR(100), @status CHAR(1)

SET @rtn = ''
SET @tmp = ''
WHILE len(@value) > 0
BEGIN
IF ascii(substring(@value, 1, 1)) = ascii(',')
BEGIN
SET @value = RIGHT(@value, len(@value) - 1)
CONTINUE
END
IF ascii(substring(@value, 1, 1)) BETWEEN ascii('0') AND ascii('9')
BEGIN
SET @tmp = @tmp + substring(@value, 1, 1)
SET @status = 'N'
END
ELSE
BEGIN
SET @rtn = @rtn + substring(@value, 1, 1)
SET @status = 'S'
END
SET @value = RIGHT(@value, len(@value) - 1)
IF @value <> ''
BEGIN
IF @status = 'S' AND ascii(substring(@value, 1, 1)) BETWEEN ascii('0') AND ascii('9') SET @rtn = @rtn + ','
IF @status = 'N' AND NOT ascii(substring(@value, 1, 1)) BETWEEN ascii('0') AND ascii('9') SET @tmp = @tmp + ','
END
END
IF RIGHT(@rtn, 1) = ',' SET @rtn = LEFT(@rtn, len(@rtn) - 1)
SET @rtn = @rtn + '|' + @tmp
RETURN @rtn
END
go

--測試
--SELECT dbo.uf_get_value('A123,B23,BD21')

3. SQL怎樣合並表中兩列的值為一列來顯示

select concat(name,id) as nameid,age

from example

具體可以參考:網頁鏈接

4. sql select語句,查詢出兩列結果拼接在一起

1、Oracle創建表,含兩列,name和job;create table test_job(name varchar2(30), job varchar2(30));

熱點內容
安卓的手機來電閃光燈在哪裡 發布:2025-07-10 16:49:02 瀏覽:836
androidstudio導入as項目 發布:2025-07-10 16:43:37 瀏覽:538
c語言中編譯和編輯的差別 發布:2025-07-10 16:43:35 瀏覽:486
iphone清除緩存軟體 發布:2025-07-10 16:20:03 瀏覽:680
以下所列的c語言常量中錯誤的是 發布:2025-07-10 16:19:00 瀏覽:852
怎麼給安卓應用重命名 發布:2025-07-10 16:18:01 瀏覽:1001
php調用棧 發布:2025-07-10 15:58:33 瀏覽:870
android頁面返回 發布:2025-07-10 15:58:22 瀏覽:464
php解析多層json 發布:2025-07-10 15:51:36 瀏覽:874
谷歌x86版安卓系統哪個最流暢 發布:2025-07-10 15:51:33 瀏覽:446