Viewing 15 posts - 1,051 through 1,065 (of 5,111 total)
You need to unencrypt the value before it gets to the report. If you don't know how to do that, it would suggest you don't have permission to decrypt that...
April 30, 2019 at 9:17 am
Are you using SQL Server? There's no such thing as "Now()", as far as I know.
A Google suggests that NOW() is a MySQL function. Hopefully the OP...
April 29, 2019 at 3:48 pm
When I do it in SSMS I use the fact that it allows multiple lines in a single quoted string
I'm not actually a fan of that method. It's fine...
April 29, 2019 at 3:29 pm
Great article Thom! I've been working on a SQL Saturday presentation right along these lines. There were a couple of points that I'd like to include in my presentation...
April 29, 2019 at 3:25 pm
Additionally, I use variables for them.
I really like the idea of putting the line break and carriage return in a variable, that would certainly make the code a...
April 29, 2019 at 9:00 am
Even
yyyy-MM-ddis not ambiguous, as it is interpreted differently when using the(small)datetimedatatype to the other date(time) datatypes.
I do not understand this. Is it 'not...
April 29, 2019 at 7:56 am
Haven't you already asked this question? 🙂 What was wrong with Grant's answer? (I assume your old account was banned for spam, as you're advertising in that other post.)
April 28, 2019 at 2:47 pm
'0x58' and 0x58 aren't the same; one is a string representation of a binary value, and one is a binary value. If you run SELECT CONVERT(varbinary,'0x58'); you don't get 0x58...
April 28, 2019 at 8:03 am
Considering that SSMS 2018 only just came out officially, which is the first to support 2019 in full, I do wonder if it's sooner round the corner that we think....
April 27, 2019 at 12:17 pm
This seems like a task better suited to something like SSIS, rather than a Stored Procedure. C:\ is also the disc on your SQL Server host, not on your PC...
April 27, 2019 at 11:36 am
There are formatting functions. You should be able to convert to any format you want.
=Format(Fields!MyDate.Value, "dddd, MMM d yyyy")
That's effectively identical to what I suggested. The...
April 26, 2019 at 7:34 pm
Use Registered Servers.
In SSMS hit Ctrl+Alt+G (or go to View->Registered Servers) and a new pane will be opened. If you wish you can dock that to a position (I have...
April 26, 2019 at 4:01 pm
Sounds good. Horizontal scroll bars will definitely be a welcome addition.
April 26, 2019 at 3:21 pm
Thought there was an issue for this, Luis, but don't see one in the various code style items. Added this.
You mean probably mean this one (Wide code doesn't...
April 26, 2019 at 2:27 pm
Viewing 15 posts - 1,051 through 1,065 (of 5,111 total)