Results for "NOT"
14 / 184 posts
Added columns in a table by dynamic ways
IF OBJECT_ID('AddedDynamicColumn','P') IS NOT NULL BEGIN DROP PROC AddedDynamicColumn END GO CREATE PROCEDURE AddedDynamicColumn AS BEGIN SELECT ED.empid,E…
How to get first date of given date or month.
Get First date of month: SELECT DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 1) AS FirstDayOfCurrentMonth Create function for that IF NOT EXISTS (SELEC…
Triggers in SQL server
A trigger in SQL is a special type of stored procedure that runs automatically when certain actions happen in a table or view . A trigger cannot be explici…
Markdown Cheat Sheet
Basic Syntax These are the elements outlined in John Gruber’s original design document. All Markdown applications support these elements. Element Markdown …
Databricks widgets
Input widgets allow you to add parameters to your notebooks and dashboards. You can add a widget from the Databricks UI or using the widget API. If y…
Spark SQL useful command
Spark SQL provides a variety of commands for managing databases, tables, and performing SQL operations. CREATE DATABASE IF NOT EXISTS demo; SHOW DATABASES;…
Store Error Logs In SQL
Create Table for Error log: CREATE TABLE [dbo].[ErrorLog]( [ErrorLogID] [int] IDENTITY(1,1) NOT NULL, [ErrorTime] [datetime] …
Database trigger to audit (Transaction logs) all of the DDL changes made to the Database
Create table DatabaseLog: CREATE TABLE [dbo].[DatabaseLog]( [DatabaseLogID] [int] IDENTITY(1,1) NOT NULL, [PostTime] [datetim…
What is the Replication in MS SQL server
Replication is a way to copy data from one database to another and keep them in sync. This is useful when you want the same data available in multiple plac…
SQL Logical Operators with Examples
SQL logical operators are used to filter data by combining multiple conditions in SQL queries. These operators help in refining queries to fetch specific r…
Working with JSON Data in Python (Using APIs and Built-in JSON Module)
इस टॉपिक में हम Python में JSON (JavaScript Object Notation) के साथ कैसे काम करते हैं, ये सीखते हैं। JSON एक डेटा फॉर्मेट है जो डेटा को store और transfer क…
Table Types Comparison: SQL Server vs PostgreSQL
Table Type SQL Server PostgreSQL Scope / Lifetime Usage Notes Permanent Table CREATE TABLE Employee (...) CREATE TABLE Employee (...) Permanent in DB until…
JSON Data – Complete Conceptual Guide (SQL Server Perspective)
🔹 JSON kya hota hai? (Quick recap) JSON (JavaScript Object Notation) ek lightweight text format hota hai data exchange ke liye. Example: { "empId…
SQL Server Agent Alerts, Operators, Database Mail & Job Activity Monitor
Production environment me sirf jobs schedule karna hi kaafi nahi hota. Hume monitoring aur notification system bhi chahiye hota hai taaki agar koi job fail…