SQL 31

Microsoft SQL, MySQL, or any other database languages, this is SQL as language, it is not the same as Database as Category
  2. Languages
  3. SQL
Sorted from new to old.
Card image
Random GUID

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

2019Dec22
Card image
List of Databases

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

2019Oct6
Card image
Char(39) in SQL table

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

2019Aug31
Card image
Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30
Card image
fnGenerateRandomString

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

2019May5
Card image
Shrinking DB

Steps to shrink database in MS SQL

2019Jan6
Card image
MSSQL backup

The practical way I found to backup database (or tables) to be moved into new ...

2019Jan6
Card image
Split string into table

Returns tag words (as table) in Microsoft SQL Separator set to comma, but you ...

2018Dec18
Card image
Posts per year-month

Create summary list If you have SQL table named Messages, with DateStamp ...

2018Dec15
Card image
Import error log

Imports the SQL Server error log into a table, so that it can be queried This ...

2018Sep29
Card image
Posts Per Year

Create summary list If you have SQL table named Table_Name, with DateAdded ...

2018Sep22
Card image
Records Affected by Execute command

Records affected by sql Execute command https://docs.microsoft. ...

2018Sep1
Card image
SQL Join

Different types of join in SQL. A good illustration image i found during my ...

2018Aug31
Card image
Pagination call

How to read certain page from SQL table Originally from from http://social. ...

2018Aug10
Card image
Modify SQL table

SQL seams to have issues when we try to modify a table and preserving data, I ...

2018Jun9
12