Technical Article

Occurs

Returns the number of times a character expression occurs within another character expression.cSearchExpression -- Specifies a character expression that OCCURS( ) searches for within cExpressionSearched. cExpressionSearched -- Specifies the character expression OCCURS( ) searches for cSearchExpression.OCCURS( ) returns 0 (zero) if cSearchExpression isn't found within cExpressionSearched.

2003-12-03

79 reads

Technical Article

OccursAny

Returns the number of times any word in comma delimeted character expression occurs within another character expression.cSearchExpression -- Specifies a comma delimeted character expression that OccursAny( ) searches for within cExpressionSearched. cExpressionSearched -- Specifies the character expression OccursAny( ) searches for cSearchExpression.OccursAny( ) returns 0 (zero) if cSearchExpression isn't found within cExpressionSearched.Example:OccursAny('the,dog','The quick brown fox […]

2003-12-03

59 reads

Blogs

Daily Coping 26 Jan 2023

By

Today’s coping tip is to focus on what’s good, even if today feels tough....

Using SQL Data Compare from the Command Line with a Project

By

SQL Data Compare (SDC) is a great way to sync data among tables. It’s...

Daily Coping 25 Jan 2023

By

Today’s coping tip is to be gentle with yourself when you make mistakes. I...

Read the latest Blogs

Forums

Can't Add Delegation for MSSQLSvc to IIS for AG Listener

By skreebydba

I have a two-replica SQL Server Availability Group running on Windows VMs in the...

Read # of trace files

By Chitown

I have a SQL agent job which starts the trace (for audit purpose) everyday...

cannot grant user view definition on a database

By winston Smith

I have a number of databases on a sql server 2017 instance. For most...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers