DTS-Less and Jobless Approach to Table Freshness

How about getting the data when the table data is first queried?  The following script checks to see if the specified table (@MyTable) has been updated today.  If so, just return the data found.  If not, then get the data from a "fresher source".  Great for ASP that performs table reporting and needs "baked daily" […]

2002-04-23

1,544 reads

Send True SMTP Mail using CDOSys instead of CDONTS

SQL Server 2000 and Windows 2000 Only.Microsoft suggest using CDOSys rather than CDONTS.  CDOSys stands for Collaboration Data Objects for Windows 2000 Subsystems.  Below is a script that allows you do do just that.  NO EXCHANGE REQUIRED!!  Sample sends the user HTML Mail!Be sure to change @ServerIPAddr to your SMTP server.

2002-04-22

1,867 reads

sp_CHARINDEX

Here's a stored procedure version of udf_CharIndex for SQL Server 7.Sample Usage: DECLARE @iPos INT DECLARE @nRet INT EXECUTE @nRet = sp_CharIndex 'W', 'Hello World', @nPos = @iPos OUTPUT IF @iPos > 0   PRINT 'found' ELSE   Print 'not found' PRINT @iPos  --Only uses on character.

2002-04-22

523 reads

View/Edit ASP Script from From SQL Server 7.0/2000

Ever want to display (and edit) ASP code from the original .asp file?  (like PHP's PHPInfo() function).To setup:  * Just create a .asp with SQL Server connectivity.  * Change @IISHostNameWWWPath to match your servername      -OR-     if SQL Server is on the same machine, use the next     line instead. (see […]

2002-04-22

513 reads

Blogs

Speaking about Latches & Spinlocks at the EightKB Online Conference

By

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...

SQL server Linux and SQLCMD

By

Following on from a previous blog post (https://blobeater.blog/2021/01/15/sql-server-linux/) on installing SQL Linux, a common...

Azure Platform Series: cloudshell code -your (brilliant) online editor

By

This post is about code which is an online editor you can use with...

Read the latest Blogs

Forums

Error in bcp query out

By SQL_Surfer

I've been playing around wiht bcp out the data into csv file but been...

Multi subnet failover cluster

By sqlguru

My goal is to have an FCI across 2 nodes with shared storage (node...

Power Query or SQL Server? Which, when and why

By vsanchezjauregui

Comments posted to this topic are about the item Power Query or SQL Server?...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Strange Code

See possible answers