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 […]

2002-01-05

662 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 […]

2001-12-18

814 reads

Blogs

Daily Coping 23 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Cloud Formations – A New MVP Led Training Initiative

By

Hello, data friends! Let me spread a few words about the new MVP led...

Daily Coping 20 May 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Call multiple packages based on result set of the query

By komal145

Hi, I have a query like "Select tablenumber from a table" Tablenumber 1 2...

LDF is not automatically shrinked with simple recovery mode

By mnemonicator

Hi there, we have SQL Server 2014 (Build - 12.0.6259.0) and my database have...

Best way to learn T-SQL for MS SQL Server?

By natsu30

Hello Everyone, At work, I've been getting more involved with hosting and database stuff....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers