Viewing 15 posts - 1,036 through 1,050 (of 5,111 total)
Out of interest, why not use the GUI? Looks like your statement should be this though:
SELECT @SQL = '-SQL ''RESTORE DATABASE ' + DatabaseName + ' FROM...
May 2, 2019 at 10:50 am
Yes, that's simple enough. I've not got SSRS at home, so you'll have to bare with me on my recollection though.
Right click the text box and select Properties and then...
May 1, 2019 at 5:58 pm
If your data, as you are implying, will have more than 4 columns then I would reshape the data thus, obviously extending it to cover all the columns
You'll need...
May 1, 2019 at 1:14 pm
Thanks Thom, I have thought of LAG function to use, it will work for sure. the only worry is need use same function 200 times as 200 columns in...
May 1, 2019 at 12:01 pm
I think it would be easier to return the value of the name last time in the data set and then check that. So, in your SELECT statement add:
May 1, 2019 at 10:43 am
Ummmm. Since when doesn't SQL 2012 have access to Integration Services as a separate connection? We use SQL 2012 and connect to Integration Services separately all the time. And...
April 30, 2019 at 7:59 pm
As I said,
yyyy-MM-ddisnotambiguous because(small)datetimetreats the value different, and can give the wrong result. For me, If I use the following statement:
The...
April 30, 2019 at 3:38 pm
Because I'm studying for my CISSP, I had to put my 2 cents in on this subject.
I'm sorry you see my response as insulting.
I think you were the...
April 30, 2019 at 2:40 pm
Terrifying yes, but not at all surprised. That is clearly a cowboy shop this person is allowed to do anything and everything and this is the first time...
April 30, 2019 at 1:28 pm
We already know the passwords I'm the one that creates them! All we want is a secure place to store them (among other details) that's why we have created...
April 30, 2019 at 11:00 am
Honestly, at first I was stating that the OP probably shouldn't be trying to decrypt the data without permission in jest (one would hope that they are asking because they...
April 30, 2019 at 10:20 am
I'm just gonna assume there isn't a way of achieving what I want to achieve 🙁
As you should. No one should be able to decrypt a password...
April 30, 2019 at 10:16 am
You can unencrypt a value in a SELECT statement, yes, however, then my previous statement amount what we need to know applies. Considering these are passwords, however, then there should...
April 30, 2019 at 9:49 am
Ah right I think wires are being crossed slightly. I want the field to remain encrypted on the SQL server as it contains users passwords. I was just wondering...
April 30, 2019 at 9:40 am
If you don’t know how to do that, it would suggest you don’t have permission to decrypt that value; and therefore shouldn’t be trying to.
Or maybe I don't know...
April 30, 2019 at 9:32 am
Viewing 15 posts - 1,036 through 1,050 (of 5,111 total)