Viewing 15 posts - 3,361 through 3,375 (of 3,666 total)
Another question: Does anyone write T-SQL queries using non-ASCII characters?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 15, 2009 at 2:33 pm
Chris Morris (4/15/2009)
Anyone for pork chops?
Maybe. How are you cooking them? ANSI or ASCII?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 15, 2009 at 7:39 am
GilaMonster (4/14/2009)
<Sigh>http://www.sqlservercentral.com/Forums/Topic696113-92-1.aspx
It boggles the mind, eh?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 14, 2009 at 1:05 pm
ALZDBA (4/13/2009)
Select datediff(dd, dateadd(mm,-18,getdate(), getdate)
i.e. determine the number of days ( dd ) between the getdate minus 18 months (12+6) and the current date.
It will not...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 13, 2009 at 1:28 pm
1.5 years is 547 or 548 days, depending on how you want to count it.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 13, 2009 at 11:21 am
Bob Hovious (4/13/2009)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 13, 2009 at 8:52 am
From the drop down box select constraint and expression (I hope that's the correct wording)
In the text box, enter:
@[your_variable] > 0
Replace your_variable with the name of your variable.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 12, 2009 at 3:47 pm
You could add a script block inside the Foreach container that increments a variable on each pass.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 12, 2009 at 1:18 pm
Y'all making want to attend the conference. I may get the chance to attend the conference for free but that does not include travel, lodging, or food. Being...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 12, 2009 at 8:00 am
Bob Hovious (4/11/2009)
You should feel safer now, too. 😉
Well said.
Now if I could get Kalen to agree too I'd feel extremely safe. 😀
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 11, 2009 at 10:17 am
GilaMonster (4/11/2009)
Alvin Ramard (4/11/2009)
If you have to use that kind of logic then you might want to use stored procedures and use something like:If A = B
BEGIN
EXEC Stored_Procedure_1
END
ELSE
BEGIN
EXEC Stored_Procedure_2
END
That's often...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 11, 2009 at 10:05 am
oops, I guess I forgot. I did use GOTO with VB6. (On Error Goto ______)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 11, 2009 at 8:31 am
Bob Hovious (4/11/2009)
The original example was actually following the IF/Begin-End ELSE/Begin-End structure.By the way, Alvin, enjoyed the presentation Thursday night.
Thanks Bob. FYI, you're doing the presentation next month....
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 11, 2009 at 8:28 am
I didn't even realize GOTO was part of T-SQL. I think the last time I used it was on a Vic-20.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 11, 2009 at 8:23 am
I hope that I would never use GOTO in SQL code.
If you have to use that kind of logic then you might want to use stored procedures and use...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 11, 2009 at 8:20 am
Viewing 15 posts - 3,361 through 3,375 (of 3,666 total)