Search results 59

  2. Search results
  3. SQL Server
Sorted from new to old.
Card image
ServerXMLHTTP stream

Using ServerXMLHTTP object to show (stream or download) and image , or any ...

2021Aug3
Card image
Wrong file permissions

Fix to unable to delete file from FTP server after uploading using PHP function ...

2020Dec21
Card image
TrimEnters

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

2020Sep19
Card image
NextID_Reset

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

2020Mar31
Card image
DB_Connect_Install

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

2020Mar24
Card image
DB_Connect

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

2020Mar20
Card image
Reset ID Column

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

2020Feb9
Card image
ANSQLWherein

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

2020Jan6
Card image
AN_SafeFileName

Clean filename from special characters to make it safe for server upload Then ...

2019Dec10
Card image
List of Databases

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

2019Oct6
Card image
bs_grid

Bootstrap grid with php server-side example code (jQuery Datagrid plugin) From ...

2019Sep20
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
eMailMe (CDO)

Single asp file (having function) to send an email It is used here to send an ...

2019May3
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
1234