Search results 53

  2. Search results
  3. .sql
Sorted from new to old.
Card image
ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

2019Apr14
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
Arabic SQL+ASP

Enable Arabic in MSSQL DB, the correct way, as of Sep 2018 Tested in Alwah and ...

2018Sep24
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
Programming Languages

A nice illustration on different types of languages (the most famous ones only) ...

2018Aug31
Card image
Pagination call

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

2018Aug10
Card image
Posts_per_Year

Gets list of years and total of posts per year from a table, by using date ...

2018Jul29
Card image
RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

2018Jul29
Card image
MSSQL DB Connection

Connects to MSSQL database from Classic ASP All DB variables need to be ...

2018Jul29
Card image
Convert2SQLDate

Converts a date (numeric date) into Date acceptable by SQL, as in YYYY-MM-DD ...

2018Jun14
1234