Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2024 01:11 AM
Hi @reachrishav, In Databricks SQL, you can replicate SQL Server's conditional logic using `CASE` statements and `MERGE` operations. Since Databricks SQL doesn't support `IF EXISTS` directly, you can create a temporary view to check your condition and then use `MERGE` to perform the desired operations. Afterward, you can count the affected rows with a `SELECT` statement. This approach allows for conditional execution and tracking of affected rows without relying on SQL Server-specific syntax.
Does this help with your use case? If you have any more specific requirements or questions, feel free to ask!