Select Random Column from Database Table

This function selects a random row from a specified database table and returns the data of the specified column. The function uses the pyodbc library to connect to the database and execute SQL queries.

Technology Stack : pyodbc, database connection, SQL query, random selection

Code Type : Database query function

Code Difficulty : Intermediate

                
                    
def select_random_column_from_table(table_name, column_name):
    import pyodbc
    import random

    # Connect to the database
    connection = pyodbc.connect('DRIVER={SQL Server};SERVER=your_server;DATABASE=your_database;UID=your_username;PWD=your_password')
    cursor = connection.cursor()

    # Select a random row from the table
    cursor.execute(f"SELECT TOP 1 {column_name} FROM {table_name}")

    # Fetch the result
    result = cursor.fetchone()

    # Close the connection
    cursor.close()
    connection.close()

    return result