Yousef Ekhtiari


Technical Article

Extracting words with removal of punctuations

Extracting words of a string with removal of unwanted punctuations.This is a flexible function to extract words from a string and tested on both SQL 2000 and 2005As you see the logic of this function is very simple. Maybe the update statement seems strange to beginners because it does not update any field of underlying […]

5 (2)

2007-09-26 (first published: )

1,273 reads

Technical Article

Search for an expression in the body of programmable objects

Sometimes you want to modify an object (like a stored procedure, Function, trigger and view) and you can not remember the name of that object, but you remember some words of the comments that you placed in the body of that object. If this is your case, you can use the following procedures depending on […]

2006-11-30 (first published: )

159 reads

Blogs

Updates from Coping Tips

By

I’ve written a lot of coping tips now. Over two years worth (Mon-Fri) since...

What I’ve learned in my first 100 days with a consulting group

By

In case you don’t follow me on LinkedIn or Twitter, your humble host joined...

Power BI as a enterprise data warehouse solution?

By

With Power BI continuing to get many great new features, including the latest in...

Read the latest Blogs

Forums

Last Cube Refresh Showing Wrong Time

By Shivs

Hi I have a tabular model and have been asked to retrieve the last...

Working with T-SQL function AVG ()

By Manvendra Deo Singh

Comments posted to this topic are about the item Working with T-SQL function AVG...

The Useful Cloud Tags

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Useful Cloud Tags

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers