Technical Article

ISINTEGER function

This function is similar to the ISNUMERIC native function, but tests for a valid integer.  ISNUMERIC can return false positive results when testing for a valid integer.  For example this select returns a value of 1 (true):select isnumeric('3d8')For 6.x and 7.0, you can easily convert it to a procedure.

5 (3)

You rated this post out of 5. Change rating

2003-08-14

3,018 reads

Blogs

Leading Through Change: Guiding Teams in Times of Uncertainty

By

Change is not a disruption in technology; it is the rhythm. New frameworks appear,...

The Mystery of the Locked-Up Database -Scooby Dooing Episode 6

By

No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...

Announcements from the Microsoft Fabric Community Conference

By

A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...

Read the latest Blogs

Forums

food places in ontario ca

By bombaycuisine

Ontario, CA is home to a variety of restaurants, but when people talk about...

food places in ontario ca

By bombaycuisine

Ontario, CA is home to a variety of restaurants, but when people talk about...

Compatibility levels on database changing them and impacts.

By jonluder

We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...

Visit the forum

Question of the Day

Changing the Recovery Time

I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?

ALTER DATABASE Finance 
 SET TARGET_RECOVERY_TIME = 12 xxx;

See possible answers