Home

Update consecutive numbering with UPDATE statement – MSSQL

I want to update a table with consecutive numbering starting at 1. The update has a where clause so only results that meet the…

Read More
What is – DML, DDL, DCL and TCL – Introduction

DML DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database. Examples: SELECT, UPDATE,…

Read More
The feed does not have subscriptions by email enabled – FeedBurner

If you see the FeedBurner error message above, this means that you need to enable the subscription by email option in your FeedBurner account…

Read More
Oracle – Create Table by Select Statement

–WITH data –without data — For example, create a table named EMPLOYEE3 that includes all — of the column definitions from EMPLOYEE where the…

Read More
Find Duplicate Values with SQL Script

Let’s assume that data has been entered in a table and now you want to find if a table column have duplicated values. Here…

Read More
List all triggers in SQL Server database with table name and schema

Sample query: Here is and another version where you can the code of the trigger:

Read More
How to create PDF files from Microsoft Office Product

Microsoft a built-in feature that can facilitate in creating a PDF file from any Office product. Here is a quick guide with screenshots.

Read More
FORMAT Function for Transact-SQL – T-SQL

Returns a value formatted with the specified format and optional culture in SQL Server 2016. Use the FORMAT function for locale-aware formatting of date/time…

Read More
MySQL Store Procedure to Loop with Table Cursor and Update with UUID()

This is a sample MySQL store procedure where I loop in all rows in a table and then I update each row with a…

Read More