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,254 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,550 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,270 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,284 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: )

157 reads

Blogs

Ethics in Modern Data this Saturday with the South Florida Data Geeks

By

This Saturday Aug 7, Christine and I will present our joint presentation on Ethics...

3 Reasons Why Focusing on Tech Is The Worst Way To Deploy a HA/DR Solution

By

This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity...

The PowerBI Volleyball Report – Organizing Data To Start

By

One of my goals this year was to build a report that I can...

Read the latest Blogs

Forums

Minimun Role Permissions Needed

By Lou

Hi Friends, Please some guidance, To import a bacpac file in a MI instance,...

Need counts of payment amounts per week grouped by week

By joewhite

Hello, I have a code that suppose to give me weekly(summed) payments, but instead,...

Import CSV Data Into Existing Tables

By VSCurtis

Hi Guys, I am having issues trying to import data from CSV files into...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers