SQL Server – Page 3 – CodeRavo

Conditional Logic in SQL Server

SQL Server provides several ways to implement conditional logic within queries and stored procedures. This allows … Conditional Logic in SQL ServerRead more

CASE statement, conditional logic, else-statement, exists, if-statement, iif, performance optimization, SQL Server, T-SQL, variables

Deleting Rows Based on Conditions in Another Table: SQL DELETE with Subqueries and Joins

Deleting Rows Based on Conditions in Another Table In SQL, deleting rows from a table based … Deleting Rows Based on Conditions in Another Table: SQL DELETE with Subqueries and JoinsRead more

data manipulation, data-deletion, database, delete, exists, join(), MySQL, PostgreSQL, SQL, SQL Server, subquery

Handling NULL Values in T-SQL CASE Expressions

Understanding NULL Values in SQL In SQL Server (T-SQL), NULL represents a missing or unknown value. … Handling NULL Values in T-SQL CASE ExpressionsRead more

CASE expression, COALESCE, conditional logic, handling-null-values, isnull, null, SQL Server, String Concatenation, T-SQL

Tracking Changes: Examining Object Modification Dates in SQL Server

SQL Server provides mechanisms to determine the creation and modification dates of database objects like stored … Tracking Changes: Examining Object Modification Dates in SQL ServerRead more

auditing, create-date, database, function, information-schema, metadata, modify-date, object-tracking, SQL Server, stored-procedure, sys-objects

Converting Strings to Datetime in SQL Server

In SQL Server, converting strings to datetime values is a common task, especially when working with … Converting Strings to Datetime in SQL ServerRead more

convert, data-type-conversion, DateTime, formatting, SQL Server, varchar

Choosing Between DateTime and DateTime2 in SQL Server

In SQL Server, there are two commonly used data types for storing date and time values: … Choosing Between DateTime and DateTime2 in SQL ServerRead more

date-and-time-data-types, DateTime, datetime2, precision, Range, SQL Server, storage-requirements, temporal-data

Finding the Maximum of Two Values in SQL Server

SQL Server doesn’t directly offer a MAX function that accepts multiple values like Math.Max in .NET. … Finding the Maximum of Two Values in SQL ServerRead more

aggregate-function, case, conditional logic, derived-table, iif, max, null-handling, SQL Server, user-defined-function

Avoiding "There is Already an Open DataReader" Errors in Entity Framework

Understanding and Resolving "There is Already an Open DataReader" Errors This tutorial explains a common error … Avoiding "There is Already an Open DataReader" Errors in Entity FrameworkRead more

database-connection, datareader, eager-loading, entity-framework, error handling, include, lazy-loading, multipleactiveresultsets, performance optimization, SQL Server, tolist

Working with Dynamic SQL Queries

Dynamic SQL queries are a powerful tool in SQL Server that allow you to construct and … Working with Dynamic SQL QueriesRead more

best practices, dynamic-sql, exec-command, sp-executesql-stored-procedure, SQL Server, sql-injection-attacks, String Concatenation, variables

Efficiently Updating Multiple Tables Using Transactions in SQL Server

When working with relational databases, it’s common to have scenarios where data updates need to be … Efficiently Updating Multiple Tables Using Transactions in SQL ServerRead more

atomicity, data integrity, multiple-tables, output-into, SQL Server, transactions, update-statement