从C#中的存储过程获取位值

CREATE PROCEDURE GetBitValue
    @number INT,
    @bitPosition INT
AS
BEGIN
    SELECT CAST((@number & POWER(2, @bitPosition - 1)) AS BIT) AS BitValue;
END

using System;
using System.Data;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "your_connection_string_here";
        int number = 10; // 示例整数
        int bitPosition = 2; // 示例位位置

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            SqlCommand command = new SqlCommand("GetBitValue", connection);
            command.CommandType = CommandType.StoredProcedure;

            command.Parameters.AddWithValue("@number", number);
            command.Parameters.AddWithValue("@bitPosition", bitPosition);

            SqlDataReader reader = command.ExecuteReader();

            if (reader.Read())
            {
                bool bitValue = (bool)reader["BitValue"];
                Console.WriteLine($"The value of bit at position {bitPosition} is: {bitValue}");
            }

            reader.Close();
        }
    }
}