Yousef Ekhtiari


SQLServerCentral Article

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

SQLServerCentral Article

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

14,845 reads

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

SQLServerCentral Article

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

161 reads

Blogs

Goal Progress for Jan 2023

By

The grade for January is a D. Details below, but just not making a...

Context Info Across Databases–#SQLNewBlogger

By

Does Context Info work across databases? This post shows it does. Another post for...

Introducing… Data On Rails!

By

Data On Rails is a Data On Wheels project designed to give a platform...

Read the latest Blogs

Forums

"ID" primary key from two separate tables as a foreign key in a new table

By Edub1122

I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with...

blocking issue

By vsamantha35

Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried...

Identity column and "EntityID" column naming convention

By CreateIndexNonclustered

This isn't* specific to 2022, but SQL in general. I will be joining a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers