Skip to content
techfura

All about Tech and Data Engineering

  • Home
  • About Us
  • Courses
  • Blog
  • Contact
  • Services

Category: Programming

Part 5: Switch case in C++

April 7, 2021April 7, 2021 Kenneth_pro_

Switch case statements are a substitute for long if statements that compare a variable to several “integral” values (“integral” values are simply values that can be expressed as an integer, such as the value of a char). The basic format Read More …

ProgrammingLeave a comment

Part 4: Functions in C++

April 7, 2021 Kenneth_pro_

Now that you should have learned about variables, loops, and conditional statements it is time to learn about functions. You should have an idea of their uses as we have already used them and defined one in the guise of Read More …

C++, ProgrammingLeave a comment

Part 3: Loops in C++

April 7, 2021April 7, 2021 Kenneth_pro_

Loops are used to repeat a block of code. Being able to have your program repeatedly execute a block of code is one of the most basic but useful tasks in programming — many programs or websites that produce extremely Read More …

C++, ProgrammingLeave a comment

Part 2: If statements in C++

April 7, 2021April 7, 2021 Kenneth_pro_

The ability to control the flow of your program, letting it make decisions on what code to execute, is valuable to the programmer. The if statement allows you to control if a program enters a section of code or not Read More …

C++, ProgrammingLeave a comment

Part 1: Introduction to the C++ Language

April 7, 2021April 7, 2021 Kenneth_pro_

A C++ program is a collection of commands, which tell the computer to do “something”. This collection of commands is usually called C++ source code, source code or just code. Commands are either “functions” or “keywords”. Keywords are a basic building block of the Read More …

C++, ProgrammingLeave a comment

Dynamic Search Conditions in T‑SQL

March 3, 2021March 3, 2021 Kenneth_pro_

Introduction It is very common in information systems to have functions where the users are able to search the data by selecting freely among many possible search fields. When you implement such a function with SQL Server there are two Read More …

Mostly Asked Questions, TSQLLeave a comment

SQL MERGE statement

January 28, 2021January 29, 2021 Kenneth_pro_

With data processing, in performing ETL workloads to a data warehouse, some of the activities in ETL can be achieved using the MERGE statement in SQL. The MERGE statement in SQL is a special type of query in SQL Server Read More …

Merge Statement, TSQLLeave a comment

A Stored Procedure to generate a random token

December 30, 2020December 30, 2020 Kenneth_pro_

You may have encountered a scenario where you want to generate a random token for identity verification purposes. In this article I tried to include a stored procedure in which you can easily generate a random token to be sent Read More …

Stored Procedure and UDF, TSQLLeave a comment

SQL Server – Indexes

September 18, 2020September 18, 2020 Kenneth_pro_

Why do we need indexing a table? Because without an index the SQL server has to scan the entire table to return the requested data. It is like the index page in a book. You check within the index for the Read More …

Indexes, TSQLLeave a comment

SQL Server: STUFF() Function

September 18, 2020September 18, 2020 Kenneth_pro_

In SQL Server (Transact-SQL), the STUFF() function deletes a sequence of characters from a source string and then inserts another sequence of characters into the source string, starting at a specified position. Syntax The syntax for the STUFF function in Read More …

Built-in Functions, Programming, TSQLMSSQL, SQL SERVER, STUFF(), Stuff() Function, TSQLLeave a comment

Posts navigation

Older posts

Categories

  • Azure (22)
    • ADF (4)
    • ADLA (14)
      • USQL (14)
    • Azure Services (1)
    • Azure SQL (2)
    • Data and Analytics (1)
  • Azure Databricks (1)
  • DevOps (1)
    • Azure DevOps CI/CD Pipeline (1)
  • ETL/ELT (1)
    • SSIS (1)
  • Excel (2)
    • Functions (1)
    • Split csv Files (1)
  • MSSQL (3)
    • TDE (3)
  • Programming (35)
    • C# (5)
    • C++ (4)
    • HTML/CSS (3)
    • JavaScript (6)
    • TSQL (15)
      • Built-in Functions (3)
      • Data Conversion (1)
      • Errors (2)
      • Indexes (1)
      • Merge Statement (1)
      • Mostly Asked Questions (4)
      • Stored Procedure and UDF (3)
  • Reporting (2)
    • SSRS (2)
April 2021
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  
« Mar    

Recent Posts

  • Part 5: Switch case in C++
  • Part 4: Functions in C++
  • Part 3: Loops in C++
  • Part 2: If statements in C++
  • Part 1: Introduction to the C++ Language

Traffic Counts

PHP Hits Count
© 2021 Techfura All rights reserved.