Launch your Graphy
There are no items in your cart
Add More
Add More
| Item Details | Price | ||
|---|---|---|---|
UPDATE AND DELETE USING JOINS in SQL: Advanced JOIN Operations
access_time 1712134980000 face Vijay Kashyap
UPDATE AND DELETE USING JOINS in SQL: Advanced JOIN Operations CREATE TABLE Sales.Targets ( Target_Id INT PRIMARY KEY, Percentage DECIMAL(4, 2) NOT NULL DEFAULT 0.00 ); CREATE TABLE Sales.Commissions ( Staff_Id INT PRIMARY KEY, Target_Id INT, Base_Amount DECIMAL(10, 2) NOT NULL DEFAULT 0, Commissio...
Temporary Functions in SQL Server- ( Part-2 )
access_time 1712064300000 face Vijay Kashyap
Temporary Functions in SQL Server- ( Part-2 ) Introduction: Temporary functions are a type of functions in SQL Server that are created and used within a specific session or connection. These functions are temporary and are only available for use during the duration of the connection in which they a...
Creating a Temporary Table from a Stored Procedure in SQL Server
access_time 1712063640000 face Vijay Kashyap
Creating a Temporary Table from a Stored Procedure in SQL Server Problem Statement: In SQL Server, it's a common requirement to create a temporary table from the result set of a stored procedure. However, doing this is not as straightforward as it might seem. This blog will address the problem of c...
SQL Server Concatenate text from multiple rows into single text string: Using XML PATH and STRING_AGG
access_time 1712061660000 face Vijay Kashyap
SQL Server Concatenate text from multiple rows into single text string: Using XML PATH and STRING_AGG SQL Combining text from various rows into a single string: In SQL Server, situations may arise where combining text from various rows into a single string is necessary. This process is valuable for...
Mastering Algo Trading with Powerful Strategies for Options and Intraday Trading
access_time 1711213800000 face Vijay Kashyap
Mastering Algo Trading with Powerful Strategies for Options and Intraday Trading Introduction Welcome to the world of algorithmic trading, where precision and strategy meet financial markets. In this comprehensive blog post, we will delve into the most powerful strategies for options and intraday t...