T-SQL: Simplified CASE expression

My last article is providing in depth tutorial about these statements:

  1. ISNULL
  2. COALESCE
  3. IIF
  4. CHOOSE

The main purpose of introducing these statements is improving code readability and achieving cleaner code. Using these statements may result to poor performance in some situations. Therefore, I also discussed about alternative solutions. This article targets all levels of readers: from newbies to advanced.

You can find it in this link:

T-SQL: Simplified CASE expression

My next article will be about Error Handling in Triggers.

Advertisements

[Fixed] SSMS – Create script duplicates the statements for Grant or Deny Column Permissions…

I was reported a bug in Microsoft SQL Server (all versions) that related to generate script for database permissions on August 20, 2013.

Steps to Reproduce

Open SSMS >> Connect to Server >> In Object Explorer expand a Sample Database >> expand Security >> right click on Users >> click on New User… >> Fill needed data in General section >> click on Securables >> click on Search >> select a table and add it… >>
In Permission window in Explicit >> click on Select or Update >> Then click on Column Permission >> select Grant to one column and click OK
>>>>>>
Now If click on Script to generate its script, you can see the statements to grant or deny are duplicated in produced script.

Expected Results

non- duplicate
I’m happy to see that Microsoft fixed it soon on October 17, 2013. And the change will be included in a future release or servicing release for SQL Server. For more info please visit this link:
So, may need to install latest update!