Yousef Ekhtiari


The Truth Table

Truth tables are an important part of working with logical values in SQL Server. Yousef Ekhtiari brings us some T-SQL that can help you construct those many variable truth tables and ensure you are getting the results you expect.

3.57 (7)

2008-03-07 (first published: )

11,148 reads

Usages of CONTEXT_INFO

How many of you have ever used SET CONTEXT_INFO in your SQL Server applications? Chances are it is not something you have been exposed to, but new author Yousef Ekhtiari brings us an example of how this particular construct can be used in your application.

4.6 (15)

2007-12-18 (first published: )

13,237 reads

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,267 reads

Some Usages for XML

While SQL Server 2005 has greatly expanded the XML capabilities of the platform, many DBAs are still not familiar with or comfortable
with using XML in their coding. Yousef Ekhtiari brings us a new article that looks at a basic use of XML in inserting data into a table.

5 (2)

2007-02-22

7,251 reads

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: )

153 reads

Blogs

Logical crossroads in Azure Data Factory (IF and Filter operations)

By

(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Read the latest Blogs

Forums

Multiple rows of same site with different managers for each - how to pivot

By andrewjmdata

Hi, I have a table of sites where the there are multiple site names...

Inner Join creating duplicates in SQL along with Group By

By lynhudson1

I have two datasets, where I would like to join and then group by...

Trying to get output of PRINT command after select in Transaction

By boughrogers

Hi I am looking to select the output of the data that I plan...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers