SQL 13 Microsoft SQL, MySQL, or any other database languages, this is SQL as language, it is not the same as Database as Category

Card image cap
Char(39) in SQL table

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

Card image cap
Rows 2 Cell

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

Card image cap
fnGenerateRandomString

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

Card image cap
Shrinking DB

Steps to shrink database in MS SQL

Card image cap
MSSQL backup

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

Card image cap
Split string into table

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

Card image cap
Posts per year-month

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

Card image cap
Import error log

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

Card image cap
Posts Per Year

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

Card image cap
Records Affected by Execute command

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

Card image cap
SQL Join

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

Card image cap
Pagination call

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