Technical Article

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" […]

You rated this post out of 5. Change rating

2002-04-23

1,553 reads

Technical Article

List Network Share Directories Quickly

Need a quick way to list shared folders?  Do it in one call.  Great for ASP page popups and user drop-down lists.Let's say that you want to display a list of projects, just call usp_GET_ProjectFolder and VIOLA! Only works with 2k; however, can be ported to ss7 if the udf is ported to a proc […]

You rated this post out of 5. Change rating

2002-04-22

345 reads

Technical Article

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.

You rated this post out of 5. Change rating

2002-04-22

1,898 reads

Technical Article

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.

You rated this post out of 5. Change rating

2002-04-22

535 reads

Technical Article

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 […]

You rated this post out of 5. Change rating

2002-04-22

527 reads

Technical Article

Write Reports from SQL to Disk (Even HTML!)

Ever need to write reports out to a folder? I have found that creating output files are SA-WEET! (and easy too) The sample script uses BCP to create an HTML file.This process works well for reports that need to be generated nightly and take too long to run in real time.  Use an SMTP mail […]

You rated this post out of 5. Change rating

2002-04-18

4,271 reads

Blogs

How important is having great soft skills as a Software Engineer for personal growth and career…

By

How important is having great soft skills as a Software Engineer for personal growth...

Master Advanced SQL: 2 Essential Courses for Every Data Analyst

By

If you're a data analyst, you already know that SQL isn't just a nice-to-have...

Friday Flyway Tips–State-based Deployments

By

Recently the Flyway Desktop (FWD) team release support for state-based deployments. These are similar...

Read the latest Blogs

Forums

The Costs and Rewards of Speaking

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Costs and Rewards of...

Manage Elastic jobs in Azure using Azure Elastic Jobs Manager

By Kunal Rathi

Comments posted to this topic are about the item Manage Elastic jobs in Azure...

Takeaways from Data Grillen 2024

By Tonie Huizer

Comments posted to this topic are about the item Takeaways from Data Grillen 2024

Visit the forum

Question of the Day

Inserting Transaction Marks

When is a transaction mark first inserted into the msdb.dbo.logmarkhistory table?

See possible answers