Technical Article

Encryption Example

Here in this T-sql tip I'am trying to compare the word "Hijacker" with two cases(line 3 and 4). Now they are in same when you compare the case (letter to letter), now you change the case of word "Hijacker" in either of the lines and run this SQL statements it will return different results. This […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2002-01-05

717 reads

Technical Article

Granting Access Permissions...

Usually when we recreate or rename a table we need to give the appropriate access permissions to the SQL users...this is very common in database under development environment where frequently table structure changes and we have to recreate it....we can accomplish this with Enterprise Manager but what will you do if Enterprise Manager fails to […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2001-12-18

870 reads

Blogs

Power BI Fun With Travels

By

I’m back from a great vacation. I had the chance to visit two new...

DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods

By

Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...

T-SQL Tuesday #203: Risk and Reward

By

This is timely, as I’m currently on a boat in the Adriatic taking a...

Read the latest Blogs

Forums

Communication, For Incidents and Life

By Pat Wright

Comments posted to this topic are about the item Communication, For Incidents and Life

PostgreSQL psql Meta Commands: Tables

By Grant Fritchey

Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables

Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server

By john.martin

Comments posted to this topic are about the item Building a Support Ticket Triage...

Visit the forum

Question of the Day

PostgreSQL psql Meta Commands: Tables

Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?

See possible answers