Viewing 15 posts - 166 through 180 (of 222 total)
I could have sworn the question asked which of these actors lived in Colorado...
When I go back to it now, it is "who starred in Independence Day" ...
July 4, 2008 at 6:20 am
I have a different result:
--Assuming that I have the following values in the TimeGroup table (value1, value2, value3, value4), what does this query return?
CREATE TABLE #TimeGroup(column1 VARCHAR(50),column2 VARCHAR(50),column3 VARCHAR(50),column4 VARCHAR(50))
INSERT...
June 20, 2008 at 12:25 pm
WAITFOR
{
DELAY 'time_to_pass'
| TIME 'time_to_execute'
| [ ( receive_statement ) | ( get_conversation_group_statement ) ]
[ ,...
June 17, 2008 at 5:19 am
The most correct answer is "Change the column to data type varchar(max) and use Update
This is the method I have used. UpdateText seems like another way around this.
June 16, 2008 at 7:44 am
Please see the article on how to update text files:
http://www.sqlservercentral.com/articles/Advanced+Querying/manipulatingtextvariables/2066/
Did I read it wrong? UpdateText seems to be the better answer although it looks like WriteText works...
June 16, 2008 at 5:57 am
We all work too hard and deal with too much competition in this industry to safely say that it is okay to not get it done before we leave. ...
June 15, 2008 at 9:47 am
The wording of the question was awkward, no doubt about it. Sorry about that.
Whoa - the whole question went shooting right over my head since first reading. No...
June 6, 2008 at 8:57 am
"THIS"
There is an adjustable bar on my page - can anyone tell me how that was coded. I'm assuming when the question refers to "... this" that the meaning...
June 6, 2008 at 5:47 am
Sometimes we should have a easy qs like this to boost our points
That was my thought a few weeks ago and so I wrote a couple of...
May 22, 2008 at 8:44 am
So then an individual who is a sysadmin logging in would not be impersonateing anything at the server level contrary to what I understand the reference above to mean.
That's where...
May 15, 2008 at 12:18 pm
If the statement is called by a member of sysadmin, server-level impersonation is used. If the statement is called by an account that is dbo, database-level impersonation is used.
If...
May 15, 2008 at 5:36 am
Of note, I learned something today as well regarding the semi-colons as my background is vb where semi-colons make our life more difficult. I am focussing on getting those...
May 14, 2008 at 6:20 am
Viewing 15 posts - 166 through 180 (of 222 total)