I have a database. Inside the database, I created more than 7000 tables and SQL objects. I need to drop the selected unwanted SQL objects and tables. However, a lot of tables have constraints to stop the dropping objects. So now I need to drop the constraints first. Like check the objects have constraints or not. if has dropped the constraints, then drop the selected unwanted objects. The query should be one query in the SQL server.
Please help me above problem.

Problem: Need help to club events running on same weeks into a single row.

Does someone know how to replace null in last row of the column to text in lead function for example

Does someone know how to replace null in last row of the column to text in lead function for example

i want my my sql run on any host and i make a checkbox, if a select this checkbox i watch all list like table, procedure, function just like a drop down in sql how can i do this , I want to organize data and table procedure, function with this checkbox please give my idea

Fiscal Week Quantity Current_quantity 2024011 1000 0 2024012 2000 1000 2024013 0 2000 2024014 3000 0 2024015 0 3000 Offset = 1 I need help on How to achieve the above scenario example if offset = 1 then the Current_quantity column should move by 1 based upon the Quantity column . For Fiscalweek 2024011 Quantity […]

Fiscal Week Quantity Current_quantity
2024011 1000 0
2024012 2000 1000
2024013 0 2000
2024014 3000 0
2024015 0 3000
Offset = 1

I want to know how we do this formula on SQL

For example,
Table A:
| FromDate | ToDate |
| ———-| ———–|
| 2024-04-01| 2024-04-03 |