基于值的动态列数 [英] Dynamic number of columns based on value

问题描述

大家好



我正在编写一个存储过程。我想要的是，基于某些列值列必须更改。让我们假设如果值为1 i想要从第1,2,5,6列获取数据，如果它不是1，那么我想从列1,3,4,6获取数据类似于..我可以这样做..

请帮帮我



提前致谢

Hi all

I am writing one stored procedure.what i want is, based on some column value columns have to change.Lets suppose if value is 1 i want to get data from columns 1,2,5,6 and if it is other than 1 then i want to get data from columns 1,3,4,6 something like that..how can i do this..
please help me out

Thanks in advance

推荐答案

试试这个：

Try this:

CREATE PROCEDURE GetMyData
    @option INT
AS
BEGIN
    DECLARE @sql NVARCHAR(MAX)
    
    IF (@option=1)
        SET @sql = 'SELECT Col1, Col2, Col5, Col6 FROM [dbo].[Table]'
    ELSE
        SET @sql = 'SELECT Col1, Col3, Col4, Col6 FROM [dbo].[Table]'
    
    EXEC(@sql)

END

这篇关于基于值的动态列数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！