Discard uncommitted changes: `git restore .` Reset last commit: `git reset --soft HEAD~`. Delete local branch: `git branch -d branch_name`. Force delete remote branch: `git push origin --delete branch_name`.

Cursors are a mechanism for explicit row enumeration, but typically should be avoided in SQL Server stored procedures as they limit optimizer flexibility. Use queries instead for better performance.

Inner join: A intersect B (common rows). Outer join: A union B (all rows from both tables). Inner join gives intersection, outer join gives union.

Enable Dark Mode in SQL Server Management Studio (SSMS) using SQL Shades: download & install tool, restart SSMS for a beautiful dark theme with improved readability.

Update your VSCode settings to enable auto-commit messages. Click the '...' icon to activate.

Set up Neon database: clone repo, install deps, run setup script. Run tests with `DEFAULT_PG_VERSION=16 ...` Clean up with `make clean`. View docs in browser with `cargo doc --no-deps --open`.

Discover top UI libraries for Angular! PrimeNG offers 90+ customizable components, NgRx simplifies state management, Chart.js creates interactive charts, and more!

When dropping a SQL table with foreign key constraints, first identify & remove those constraints using `ALTER TABLE` commands. Then safely drop the table with `DROP TABLE`.

To show query window at SSMS startup: Open SSMS > Tools > Options > Environment > Startup > At startup > Open new query window > OK. Now, a new query window opens each time you launch SSMS.

Customize SSMS status bar color by database to avoid accidental mistakes between DEV, UAT, PROD & more, improving workflow efficiency with visual differentiation.

Copy data to new table with SQL: `SELECT a.* INTO newTable FROM oldTable a;` Use CAST for type conversion & count sum of multiple tables: `SELECT SUM(K) AS Total_Row_Count FROM (SELECT COUNT(*) FROM TABLE1 UNION SELECT COUNT(*) FROM TABLE2) A;

Discover the ultimate Angular development toolkit! Explore 12 essential extensions for VS Code, including Angular Language Service, ESLint, Prettier, and more. Boost your productivity with these must-have tools!

sp_helptext displays complete text of a stored procedure, view or trigger in a database, showing its definition (SQL code) allowing you to inspect or modify it. Use `SP_HELPTEXT 'sp_name'` to retrieve the code.