Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,831 through 13,845 (of 59,095 total)

RE: Encrypt a column in sql server?

vsamantha35 - Sunday, November 5, 2017 12:53 AM
Sorry my bad. I want to encrypt and not masking the data. Editing the original...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 5, 2017 at 9:32 am

#1966702
RE: Core T-SQL

TomThomson - Saturday, November 4, 2017 8:20 PM
Jeff Moden - Saturday, November 4, 2017 7:36 PM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 4, 2017 at 9:15 pm

#1966678
RE: Encrypt a column in sql server?

vsamantha35 - Saturday, November 4, 2017 2:46 PM
Hi All,
Need help in encrypting a column and share the encryption key with...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 4, 2017 at 8:42 pm

#1966677
RE: The Importance of Clear Data Displays

Ooooo... don't get me started. This was a stupid mistake on all fronts including the human checks and balances that are supposed to be in place even for such mundane...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 4, 2017 at 8:36 pm

#1966676
RE: Core T-SQL

TomThomson - Saturday, November 4, 2017 5:23 PM
Gary Varga - Wednesday, November 27, 2013 2:06 AM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 4, 2017 at 7:36 pm

#1966674
RE: Core T-SQL

TomThomson - Saturday, November 4, 2017 5:08 PM
Jeff Moden - Friday, November 29, 2013 10:37 AM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 4, 2017 at 5:18 pm

#1966672
RE: Changing NVARCHAR to VARCHAR...

GilaMonster - Friday, November 3, 2017 9:13 AM
Jeff Moden - Thursday, November 2, 2017 9:23 PM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 4, 2017 at 5:11 pm

#1966671
RE: Send Job Alerts to User Base

ThomasRushton - Thursday, November 2, 2017 4:48 AM
When setting up the SQL Server scheduled jobs, what you could do is add a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 3, 2017 at 6:15 pm

#1966645
RE: CLR to write to the Windows Event Log

Phil Parkin - Friday, November 3, 2017 8:18 AM
Jeff Moden - Friday, November 3, 2017 8:05 AM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 3, 2017 at 1:03 pm

#1966615
RE: CLR to write to the Windows Event Log

giles.clapham - Friday, November 3, 2017 6:32 AM
Thanks Phil,
I hadn't considered that route but now I have and had my taste...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 3, 2017 at 8:05 am

#1966561
RE: CASE Help

Thom A - Friday, November 3, 2017 2:09 AM
Jeff Moden - Thursday, November 2, 2017 6:50 PM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 3, 2017 at 7:44 am

#1966558
RE: Changing NVARCHAR to VARCHAR...

Arsh - Thursday, November 2, 2017 1:08 PM
So , that boils down to normalization. Then would it be ok to indiscriminately use...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 2, 2017 at 9:23 pm

#1966522
RE: CASE Help

Thom A - Wednesday, November 1, 2017 11:04 AM
Firstly, let's have something that's (marginally) more readable than a single line of text:
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 2, 2017 at 6:50 pm

#1966517
RE: Return Code for an If Statement

rjjh78 - Thursday, November 2, 2017 1:08 PM
Hello, I am writing a Stored Procedure and would like to return an error code...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 2, 2017 at 6:45 pm

#1966516
RE: Return Code for an If Statement

Henrico Bekker - Thursday, November 2, 2017 1:19 PM
Try the following. I set @myvalue to 6 as a test for a normal...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 2, 2017 at 6:42 pm

#1966515

Viewing 15 posts - 13,831 through 13,845 (of 59,095 total)