Pages

Tuesday, June 10, 2025

MS-SQL Server - Baseedi, Peer-to-Peer Replication & Fix in case of Conjunction

Baseedi, Peer-to-Peer Replication & Fix in case of Conjunction.....


Well Baseedi in regards to SQL Server is nothing but Base of Editions...


"The "baseline" or starting point for SQL Server editions is typically the Standard Edition, as it provides core database management and business intelligence capabilities for smaller organizations and departments. Other editions, like Enterprise and EXPRESS, offer more advanced features or are free for specific use cases, but Standard is the basic business edition."


Peer-to-Peer Replication

https://learn.microsoft.com/en-us/sql/relational-databases/replication/transactional/peer-to-peer-transactional-replication?view=sql-server-ver17


FIX: Incorrect result when you run a query that contains a conjunction and a disjunction in SQL Server Compact 3.5

https://support.microsoft.com/en-us/topic/fix-incorrect-result-when-you-run-a-query-that-contains-a-conjunction-and-a-disjunction-in-sql-server-compact-3-5-c076b7c8-40c1-c074-1105-6d27bdddb21e


Additionally, 


CASE Statement

USE AdventureWorks2022;

GO


SELECT ProductNumber,

    Category = CASE ProductLine

        WHEN 'R' THEN 'Road'

        WHEN 'M' THEN 'Mountain'

        WHEN 'T' THEN 'Touring'

        WHEN 'S' THEN 'Other sale items'

        ELSE 'Not for sale'

        END,

    Name

FROM Production.Product

ORDER BY ProductNumber;


T. Amit Vaid S.

No comments:

Post a Comment