Posts

DATABASE CASE | TRANSACTION | HAVING

 SELECT City, SUM(Salary) as TotalSalary FROM Employee GROUP BY City HAVING City = 'MUMBAI' ======================================================================================= CREATE TABLE Product ( ProductID INT PRIMARY KEY, Name VARCHAR(40), Price INT, Quantity INT ) INSERT INTO Product VALUES(101, 'Product-1', 100, 10) INSERT INTO Product VALUES(102, 'Product-2', 200, 15) INSERT INTO Product VALUES(103, 'Product-3', 300, 20) INSERT INTO Product VALUES(104, 'Product-4', 400, 25) Transaction Statement BEGIN TRANSACTION INSERT INTO Product VALUES(105,'Product-5',500, 30) UPDATE Product SET Price =350 WHERE ProductID = 103 DELETE FROM Product WHERE ProductID = 103 COMMIT TRANSACTION rollback  ========================================================================================= SELECT Name, Age,  CASE  WHEN Age < 18 THEN 'Minor'  WHEN Age >= 18 AND Age < 60 THEN 'Adult'  ELSE 'Senior'  END AS AgeGrou...
Post a Comment
Read more

Numpy

 No file chosenNo file chosenNo file chosen Chat with ChatGPT Ask anything ChatGPT is AI and can make mistakes. Log in You said: Numpy python example with results ChatGPT said: Here are a few common NumPy examples with their outputs. 1. Create a NumPy array import numpy as np arr = np.array([10, 20, 30, 40, 50]) print(arr) Output: [10 20 30 40 50] 2. Basic arithmetic import numpy as np arr = np.array([1, 2, 3, 4]) print("Original:", arr) print("Add 5:", arr + 5) print("Multiply by 2:", arr * 2) Output: Original: [1 2 3 4] Add 5: [6 7 8 9] Multiply by 2: [2 4 6 8] 3. Array statistics import numpy as np arr = np.array([10, 20, 30, 40, 50]) print("Sum:", np.sum(arr)) print("Mean:", np.mean(arr)) print("Maximum:", np.max(arr)) print("Minimum:", np.min(arr)) Output: Sum: 150 Mean: 30.0 Maximum: 50 Minimum: 10 4. 2D array (matrix) import numpy as np matrix = np.array([[1, 2, 3],                    [4, 5, 6]]) print(matrix)...
Post a Comment
Read more

DATABASE TRIGGER

Image
                                                                             DATABASE   TRIGGER Summary A Trigger executes automatically when data changes. It can respond to INSERT , UPDATE , and DELETE events. The inserted pseudo-table contains new values. The deleted pseudo-table contains old values. Triggers are commonly used for auditing , validation , logging , and enforcing business rules . CREATE TABLE Employee (     EmpID INT PRIMARY KEY ,     EmpName VARCHAR ( 50 ),     Salary DECIMAL ( 10 , 2 ) );     INSERT INTO Employee VALUES ( 101 , 'Amit' , 30000 ), ( 102 , 'Rahul' , 35000 ), ( 103 , 'Priya' , 40000 );     SELECT * FROM   EMPLOYEE   CREATE...
Post a Comment
Read more

STORE PROCEDURE ADVANCE CONCEPT - PART 2

  List All Stored Procedures SELECT name FROM sys.procedures; ================================================================================ Stored Procedure Calling Another Stored Procedure with Parameters in SQL Server You cannot create a stored procedure inside another stored procedure, but you can call one stored procedure from another and pass parameters . Step 1: Create Table CREATE TABLE Employee ( EmpID INT IDENTITY ( 1 , 1 ) PRIMARY KEY , EmpName VARCHAR ( 100 ), Salary DECIMAL ( 10 , 2 ) ); Step 2: Insert Sample Data INSERT INTO Employee(EmpName, Salary) VALUES ( 'Nilesh Gupta' , 50000 ), ( 'Rahul Sharma' , 45000 ), ( 'Priya Patel' , 55000 ); ====================================================================================== Procedure 1: Get Employee by ID CREATE PROCEDURE sp_GetEmployeeByID ( @EmpID INT ) AS BEGIN SELECT * FROM Employee WHERE EmpID = @EmpID; END ; GO Execute EXEC sp_GetEmployeeByI...
Post a Comment
Read more

STORE PROCEDURE BASIC PROGRAMMING - PART 1

  1. Create a Stored Procedure CREATE PROCEDURE sp_GreetUser AS BEGIN PRINT 'Welcome to SQL Server Stored Procedure Programming' ; END ; ================================================================================ Stored Procedure with Parameters Create Procedure CREATE PROCEDURE sp_AddNumbers @Num1 INT , @Num2 INT AS BEGIN DECLARE @ Result INT ; SET @ Result = @Num1 + @Num2; PRINT 'Addition Result = ' + CAST (@ Result AS VARCHAR ( 10 )); END ; Execute Procedure EXEC sp_AddNumbers 10 , 20 ; ========================================================================== Stored Procedure with Parameters Create Procedure CREATE PROCEDURE sp_AddNumbers @Num1 INT , @Num2 INT AS BEGIN DECLARE @ Result INT ; SET @ Result = @Num1 + @Num2; PRINT 'Addition Result = ' + CAST (@ Result AS VARCHAR ( 10 )); END ; Execute Procedure EXEC sp_AddNumbers 10 , 20 ; ======================...
Post a Comment
Read more