Viewing 15 posts - 1,186 through 1,200 (of 2,038 total)
Jeff Moden (4/30/2009)
Florian Reischl (4/30/2009)
Jeff Moden (4/29/2009)
http://www.sqlservercentral.com/articles/T-SQL/63003/Thanks Jeff!
Great article! Am I allowed to refer to?
Absolutely.
Thank you!
I also have some code for you on cleaning a string. I've repaired...
April 30, 2009 at 12:04 pm
Hi
Sorry for barging in 😉
What about selecting the columns instead of print them?
DECLARE @Prefix VARCHAR(10)
DECLARE @Table VARCHAR(128)
SELECT @Prefix = 'pfx.', @Table = 'Calendar'
SELECT @Prefix+syscolumns.name + ', '
FROM syscolumns
...
April 30, 2009 at 10:21 am
Hi
This can also depend on the .Net web-service. .Net uses on demand loading of related assemblies. Since you need at least System.Data.dll and maybe some other middle tier layer DLLs...
April 30, 2009 at 9:07 am
lmu92 (4/30/2009)
@Flo:The "quote-trick" works on my FireFox-Version, too... :w00t:
Just kidding ;-). The quote-trick works on every browser. The problem is not the browser but the java-script client-side render engine...
Sorry
Flo
April 30, 2009 at 5:54 am
kavitus (4/30/2009)
Any good resources of starting with XQuery
There are some good example in BOL.
Here a little sample for your XML. Do not copy the rendered code! It is damaged by...
April 30, 2009 at 5:51 am
Hi kavitus
Still not valid:
<DEPTID = "10">
... is missing the attribute qualifier.
Tip for posting XML the best way is just attach as file.
Greets
Flo
April 30, 2009 at 5:39 am
Hey Lutz!
Install Firefox 3.0.10, then err... click "Quote" at his post 😛
Greets
Flo
April 30, 2009 at 5:14 am
kbotha80 (4/29/2009)
Excel 2003 has a row limit . I suggest use Excel 2007 it has a row limit of 65536.:-D
Hi kbotha80
65,536 was the Excel restriction until 2003. Since Excel 2007...
April 30, 2009 at 5:12 am
Hi
The collation doesn't matter for the storage of these characters. The collation describes the sorting and matching of the text data. Use column type NVARCHAR and everything works. We handle...
April 30, 2009 at 5:10 am
Hi
Your XML is not valid.
* XML is case sensitive
* Start element "record" and end element "RECORD"
* Start element "deptid" and end element "DEPT"
* Start element "DEPTID" and end element "DEPT"
Greets
Flo
April 30, 2009 at 4:55 am
Jeff Moden (4/29/2009)
http://www.sqlservercentral.com/articles/T-SQL/63003/
Thanks Jeff!
Great article! Am I allowed to refer to?
Greets
Flo
April 30, 2009 at 2:19 am
Bruce W Cassidy (4/29/2009)
Roy Ernest (4/29/2009)
I finished my article and it is on the way for publication... May 4th is the D-Day for me....
[font="Verdana"]Well done, Roy! International Star Wars...
April 29, 2009 at 3:14 pm
Great! Something I didn't yet work with so you have your first student 🙂
April 29, 2009 at 2:50 pm
Hi Roy
I'm curious about it! 🙂
Is the topic already public known or would it be a secret since 4th?
Greets
Flo
April 29, 2009 at 2:43 pm
Viewing 15 posts - 1,186 through 1,200 (of 2,038 total)