Search results 56

Sorted from new to old.

Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

2020Sep19

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

2020Feb9

Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

2020Feb7

ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

2020Jan6

Random GUID

Generate a random GUID using oracle db workbench Also add timestamp to ensure ...

2019Dec22

GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

2019Dec19

List of Databases

Script to list databases available in a server using ADODB connection From

2019Oct6

Country list in arabic

List of countries codes and names in Arabic, you do not know when you need it ...

2019Sep9

Char(39) in SQL table

One of many ways to go around the issue of char 39 in SQL database

2019Aug31

LastInsertedID_SQL

Get the ID of the last inserted record in a table. There are other methods, ...

2019Jul18

HeadingZeros Remove and Add

Adds or remove zeros at start of string Used to clear heading zeros from ...

2019May31

fnGenerateRandomString

SQL function to generate random string I thought it would be easier to find ...

2019May5

1 2 3 4