sql语句

[程序小海]

视图 View_user

我想 获取 它第二列的列名。

可以实现吗？？

[程序小海]

[Quote=引用 1 楼 ssp2009 的回复:]

难。。
[/Quote]

也就是说 是可以的咯？

[Shawn]

CREATE TABLE temp
(
	col1 INT, 
	col2 INT,
	col3 INT
)
go
CREATE VIEW view_test AS
	SELECT colv1 = col2, colv2 = col3, colv3 = col1, colv4 = '' FROM temp
go

SELECT [name] FROM sys.columns
WHERE [object_id] = object_id('view_test', 'v')
	AND column_id = 2
/*
colv2
*/

[gw6328]

[Quote=引用 3 楼 wwwwgou 的回复:]
SQL code
CREATE TABLE temp
(
col1 INT,
col2 INT,
col3 INT
)
go
CREATE VIEW view_test AS
SELECT colv1 = col2, colv2 = col3, colv3 = col1, colv4 = '' FROM temp
go

SELECT [n……
[/Quote]
+