Querystring Issue on C# with special characters

 If you're building a URL string dynamically in C#, you can use Uri.EscapeDataString to ensure proper encoding:

string searchTerm = "rock&roll";

string query = $"https://example.com/search?query={Uri.EscapeDataString(searchTerm)}";

This approach will automatically encode any special characters, including &, resulting in a safe and valid query string.

SQL Script to Terminate All Active Connections to a Specific Database || Kill Database connections

 -- Declare a cursor to iterate through the sessions

DECLARE @sessionId INT;

DECLARE kill_cursor CURSOR FOR

    SELECT session_id

    FROM sys.dm_exec_sessions

    WHERE database_id = DB_ID('DBName');

-- Open the cursor and loop through the sessions

OPEN kill_cursor;

FETCH NEXT FROM kill_cursor INTO @sessionId;

WHILE @@FETCH_STATUS = 0

BEGIN

    -- Print the session ID to be killed (for verification purposes)

    PRINT 'Killing session: ' + CAST(@sessionId AS VARCHAR(10));

    -- Kill the session

    EXEC('KILL ' + @sessionId);

    FETCH NEXT FROM kill_cursor INTO @sessionId;

END

-- Close and deallocate the cursor

CLOSE kill_cursor;

DEALLOCATE kill_cursor;

How do I create a unique constraint on a column in SQL Server?

 You can create a unique constraint using the ALTER TABLE command:

ALTER TABLE YourTableName ADD CONSTRAINT Unique_Constraint_Name UNIQUE (ColumnName);

This enforces a unique constraint on ColumnName.

This returns the names of all databases on the server.

 To remove a column from a table, use the ALTER TABLE command:

ALTER TABLE YourTableName DROP COLUMN ColumnName;

This will permanently delete the column from the table.

How do I list all available databases on a SQL Server instance?

 You can list all databases on a SQL Server instance using:

SELECT name FROM sys.databases;

This returns the names of all databases on the server.

How do I check the SQL Server version and edition?

 Use the following query to get the SQL Server version and edition:

SELECT SERVERPROPERTY('ProductVersion') AS Version, 

 SERVERPROPERTY('ProductLevel') AS ProductLevel,

 SERVERPROPERTY('Edition') AS Edition;

This returns the version, product level (e.g., RTM, SP1), and edition of the SQL Server instance.

How do I rename a column in SQL Server?

 You can rename a column using the sp_rename system stored procedure:

EXEC sp_rename 'YourTableName.OldColumnName', 'NewColumnName', 'COLUMN';

This renames OldColumnName to NewColumnName in the specified table.

How do I grant a user access to a specific database in SQL Server?

 To grant access to a user for a specific database, use the following commands:

Create a login (if it doesn't already exist):

CREATE LOGIN YourLoginName WITH PASSWORD = 'YourPassword';

Grant access to the database:

USE YourDatabaseName; CREATE USER YourLoginName FOR LOGIN YourLoginName;

Grant a role or specific permissions:

EXEC sp_addrolemember 'db_datareader', 'YourLoginName';  -- Grants read access

How do I execute a stored procedure in SQL Server?

 To execute a stored procedure, use the EXEC command followed by the procedure name and any necessary parameters:

EXEC YourStoredProcedureName @Param1 = 'Value1', @Param2 = 'Value2';

Replace YourStoredProcedureName with the name of the stored procedure and provide the required parameter values.

How do I find all stored procedures in a database?

 You can retrieve the list of all stored procedures using the following query:

SELECT 
    name AS ProcedureName,
    create_date,
    modify_date
FROM 
    sys.procedures
ORDER BY 
    name;
This returns all stored procedures along with their creation and modification dates.