Viewing 15 posts - 1 through 15 (of 71 total)
Hi Lowell,
I'm using views to auto-decrypt the select statements. Can you please give me an example as to how I can use procs for insert/update/delete statements. I made some...
May 30, 2017 at 11:24 am
Hi Lowell,
I appreciate your prompt response. I do have all the encryption columns and data types set up with Symmetric and Asymmetic keys required for encryption. Here is the...
May 30, 2017 at 8:50 am
Any other recommendations?
May 24, 2017 at 3:03 pm
Steve,
The idea behind creating a view is to allow programmers to perform CRUD operations using views. My table has firstname, lastname and e_firstname, e_lastname columns (encrypted columns using orginal...
March 20, 2017 at 9:12 am
I do not have any applications or non-DBA users that have sysadmin or DBO privs. How can we perform CRUD operations on the encrypted table? Once I get the view...
March 20, 2017 at 8:49 am
Jeff,
Can you suggest an alternative to views? Need help with this.
Thanks
March 20, 2017 at 8:03 am
anthony- I tried using Luis's code and got below error message. Any inputs on what I may be doing wrong. Thanks.
Msg 208, Level 16, State 1, Line 19
Invalid object name...
October 16, 2015 at 8:47 am
All-I appreciate your response. In the salescode column there is single salescode also. How do I handle it? Here is the updated DDL. Is there a way to create 2...
October 16, 2015 at 8:34 am
Luis,
The query you suggested works fine. I've a small issue with it. If there is Jobnumber that has OperationCode 2001 it still shows up. In the below DDL there is...
September 21, 2015 at 8:35 am
Thank you very much Luis.
September 21, 2015 at 8:06 am
Any help is appreciated. Thanks again everyone.
September 21, 2015 at 7:38 am
ScottPletcher,
Thank you for your help before. I've to create a new report where I have to show all the jobs that DO NOT have OperationCode 2001 and 2002. Any help...
September 21, 2015 at 7:09 am
ScottPletcher & Lowell- Thank you very much for your help.
September 16, 2015 at 1:58 pm
Viewing 15 posts - 1 through 15 (of 71 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy