Viewing 15 posts - 436 through 450 (of 8,731 total)
Functions are meant to return values. Functions are NOT meant to make changes to a database.
You might be trying to create a Stored Procedure. Understanding the difference between both...
July 2, 2018 at 6:27 am
July 1, 2018 at 4:36 pm
You could try to use the functions presented in the following article:
http://www.sqlservercentral.com/scripts/String+Function/141686/
June 29, 2018 at 1:21 pm
Kaye Cahs - Friday, June 29, 2018 6:54 AMFRIDAY!
No meetings and I answered the question right!
Whooo!
Show-off
June 29, 2018 at 12:10 pm
I'm trying to solve an exercise and can't seem to solve this without doing...
June 29, 2018 at 12:06 pm
I am calculating to Standard deviation and i am using standard deviation function, i am...
June 28, 2018 at 9:02 am
June 28, 2018 at 8:52 am
Last night, something weird happened in my dream.
I saw some advertisement for SQL consulting services charging $8USD per non-clustered index. I'm still trying to determine if the bad...
June 28, 2018 at 8:09 am
This might give you an idea on how to control the values a little bit more.
WITH
E(n) AS(
SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)
),
E2(n)...
June 28, 2018 at 7:29 am
What about creating a huge script with all the views' definitions and use replace functionality of the text/code editor (SSMS?) to change the values?
This can also be done using...
June 27, 2018 at 2:07 pm
What about adding a column to the table to add a flag. Then update the flag whenever needed and use that column in your views instead of the Term column.
June 27, 2018 at 1:33 pm
The main problem I can see is that there's no guarantee that you'll have humanly distinctive colors for each user.
If you get #EE1010 and #EE1012, it would be really...
June 27, 2018 at 10:38 am
A thirsty one? LOL.
I have never been to Twin Peaks but they serve...
June 27, 2018 at 8:00 am
June 27, 2018 at 7:57 am
Viewing 15 posts - 436 through 450 (of 8,731 total)