Forum Replies Created
Viewing 15 posts - 1,186 through 1,200 (of 5,111 total)
-
Reply To: Replace 1st char in a string if not null
STUFFis really handy for things like this:STUFF(Mobile,1,1,'')
That will remove the first character of the from the column
Mobile. The function is very commonly used when creating... -
Reply To: Using the OUTPUT CLAUSE in a INSERT statement.
INSERTnot being able to reference tables in theFROMclause is documented (OUTPUT Clause (Transact-SQL) - Arguments):from_table_name
Is a column prefix that specifies a table included in the FROM...
-
Reply To: Split file attachment if they exceed size limit
What would you expect to happen if you had a single file with a size of 8MB or more? Could that happen? if so, how would you expect to split...
-
Reply To: Convert source real data type to target decimal(18,5) data type .
I can't replicate your problem db<>fiddle. Could you post us some sample formatted DDL and DML so help us replicate the problem, and explain what the results you're after...
-
Reply To: Quoting posts with Line breaks
Thom A wrote:Title says it all here, but when quoting a post with line breaks in, the line breaks are lost. This actually can easily make the previous quote an unreablemess,...
-
Reply To: Dynamic query
piu.scorpio wrote:Hi Chris Thank you for your reply. But I have an issue. Your suggestion works if i the local variable values are null. But in the actual job they...
-
Reply To: Dynamic query
Does that SQL work? I suspect it doesn't, as
context(ironically) has no context in the 2 lines below:SET @projectId = '' + context.projectId + '';
SET @version... -
Reply To: What has happened to the layout / format of the forum ?
It's something that has been coming for a a while , but they put an announcement up last week: SQLServerCentral v3 coming tomorrow. If you note any problems, best...
-
Reply To: Can see all images when uploading an image
Steve Jones - SSC Editor wrote:For pasting in images, where did you try this? Was this in the article editor? That was working, but I’ve filed a bug for that.
No, that was in the...
-
Reply To: Are the posted questions getting worse?
Grant Fritchey wrote:2373715 wrote:
This “little” problem is also the likely reason why about 80% of all my briefcase listings are now gone. They really need to fix this...
-
Reply To: Are the posted questions getting worse?
Sean Lange wrote:Ugh…how many links all over the interwebs are there to the DelimitedSplit8K article? Or any of the other articles. Not sure why some are still valid and others aren’t.
I...
-
Reply To: Are the posted questions getting worse?
Jeff Moden wrote:Now all everyone has to do is fix the links in their signature line.
Was honestly hopeful that the address for the old articles would be...
-
Reply To: Are the posted questions getting worse?
Something I did purely out of habit (from Stack Overflow/GitHub), but was surprised to find out to worked is backtick quoting (`) works on the site as well. So if...
-
Reply To: I'm In Charge of Books Online
Jeff Moden wrote:From the article:
<hr class="d4pbbc-hr" />
Don’t believe much of what you read today. Keep your head down and focus on code that you know is true.
Great prank, Steve. To...
Viewing 15 posts - 1,186 through 1,200 (of 5,111 total)