sql bit data type: basic

Showing posts with label basic. Show all posts

Tuesday, March 27, 2012

books online tutorial - why am i getting an error?

Hi,
I am doing the MSDN Online tutorial "Accessing the Report Server Web Service
Using Visual Basic or Visual C#".
However, when I come to the 3rd step, Accessing the Web Service, and use the
supplied code, I get an error saying
"Namespace or type specified in the Imports
'GetPropertiesSample.ReportService2005' doesn't contain any public member or
cannot be found. Make sure the namespace or the type is defined and contains
at least one public member. Make sure the imported element name doesn't use
any aliases."
and
"Type 'ReportingService2005' is not defined."
This happens when using C# or VB.
What I am doing wrong?
ThanksSorry, I forgot to rename my project to GetPropertiesSample.
Works ok now.
"PacMan" wrote:
> Hi,
> I am doing the MSDN Online tutorial "Accessing the Report Server Web Service
> Using Visual Basic or Visual C#".
> However, when I come to the 3rd step, Accessing the Web Service, and use the
> supplied code, I get an error saying
> "Namespace or type specified in the Imports
> 'GetPropertiesSample.ReportService2005' doesn't contain any public member or
> cannot be found. Make sure the namespace or the type is defined and contains
> at least one public member. Make sure the imported element name doesn't use
> any aliases."
> and
> "Type 'ReportingService2005' is not defined."
> This happens when using C# or VB.
> What I am doing wrong?
> Thanks

Friday, February 24, 2012

BLAST (Basic Local Alignment Search Tool)

Does any one know if if MS SQL 2000 or 2005 supports the BLAST Search BLAST
(Basic Local Alignment Search Tool) Thanks.
is SQL full-text search what you are looking for?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Fred Pannell" <Fred Pannell@.discussions.microsoft.com> wrote in message
news:C4DE0460-988E-48FC-A164-C7C13A528589@.microsoft.com...
> Does any one know if if MS SQL 2000 or 2005 supports the BLAST Search
> BLAST
> (Basic Local Alignment Search Tool) Thanks.
|||Hilary,
I do not think that they are one in The same. BLAST searches are supported
in ORACLE 10G and in DB2. I am attempting to findout if anyone in the SQL
arena does or uses the concept in SQL 2000 or in the new 2005. I do not see
any refernces in the process for Microsoft SQL.
"Hilary Cotter" wrote:

> is SQL full-text search what you are looking for?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Fred Pannell" <Fred Pannell@.discussions.microsoft.com> wrote in message
> news:C4DE0460-988E-48FC-A164-C7C13A528589@.microsoft.com...
>
>

BLAST (Basic Local Alignment Search Tool)

Does any one know if if MS SQL 2000 or 2005 supports the BLAST Search BLAST
(Basic Local Alignment Search Tool) Thanks.is SQL full-text search what you are looking for?
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Fred Pannell" <Fred Pannell@.discussions.microsoft.com> wrote in message
news:C4DE0460-988E-48FC-A164-C7C13A528589@.microsoft.com...
> Does any one know if if MS SQL 2000 or 2005 supports the BLAST Search
> BLAST
> (Basic Local Alignment Search Tool) Thanks.|||Hilary,
I do not think that they are one in The same. BLAST searches are supported
in ORACLE 10G and in DB2. I am attempting to findout if anyone in the SQL
arena does or uses the concept in SQL 2000 or in the new 2005. I do not see
any refernces in the process for Microsoft SQL.
"Hilary Cotter" wrote:
> is SQL full-text search what you are looking for?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Fred Pannell" <Fred Pannell@.discussions.microsoft.com> wrote in message
> news:C4DE0460-988E-48FC-A164-C7C13A528589@.microsoft.com...
> > Does any one know if if MS SQL 2000 or 2005 supports the BLAST Search
> > BLAST
> > (Basic Local Alignment Search Tool) Thanks.
>
>

BLAST (Basic Local Alignment Search Tool)

Does any one know if if MS SQL 2000 or 2005 supports the BLAST Search BLAST
(Basic Local Alignment Search Tool) Thanks.is SQL full-text search what you are looking for?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Fred Pannell" <Fred Pannell@.discussions.microsoft.com> wrote in message
news:C4DE0460-988E-48FC-A164-C7C13A528589@.microsoft.com...
> Does any one know if if MS SQL 2000 or 2005 supports the BLAST Search
> BLAST
> (Basic Local Alignment Search Tool) Thanks.|||Hilary,
I do not think that they are one in The same. BLAST searches are supported
in ORACLE 10G and in DB2. I am attempting to findout if anyone in the SQL
arena does or uses the concept in SQL 2000 or in the new 2005. I do not see
any refernces in the process for Microsoft SQL.
"Hilary Cotter" wrote:

> is SQL full-text search what you are looking for?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Fred Pannell" <Fred Pannell@.discussions.microsoft.com> wrote in message
> news:C4DE0460-988E-48FC-A164-C7C13A528589@.microsoft.com...
>
>

Friday, February 10, 2012

bit off topic: street name database US

I'm thinking of doing some basic parsing of address. I want to seprate
out the house number from the street name from the suffix. I have the
suffix's from the USPS, but I cant find a database of US street names.
Anyone come across one or know where I can get one?
TIA
Rob
/end off topic"rcamarda" <rcamarda@.cablespeed.com> wrote in message
news:1127439693.974508.70290@.o13g2000cwo.googlegro ups.com...
> I'm thinking of doing some basic parsing of address. I want to seprate
> out the house number from the street name from the suffix. I have the
> suffix's from the USPS, but I cant find a database of US street names.
> Anyone come across one or know where I can get one?
> TIA
> Rob
> /end off topic

Its probably not in a convenient format, but you could try parsing
streetnames from TIGER data - www.census.gov/geo/www/tiger/index.html. TIGER
data is used by a lot of applications and is free. They might do a separate
street name download, but I couldn't get to the site when I tried just now
to look.

Hope this is useful.
--
Brian Cryer
www.cryer.co.uk/brian|||Brian,
That did the trick, thanks! I found the detail files in Tiger located
here: http://www.census.gov/geo/www/tiger.../tgr2004se.html
I used GETRIGHT to download all the zip files (over 1,600). There is a
ton of data that I dont need, ill just use SQL to keep the unique
street names. I plan to get all the unique street names and all the
street suffixes. If anyone is interested in the data when I'm done,
post and I'll send you the info.

After I get all the text data loaded, my next step will be parse out
the addresses, so I'm sure I'll be posting in this group again!

Cheers,
Rob

Bit of a beginner question on SQL-XML

Hello there, I have a very basic question but I'd appreciate some help. My query results in SQL QUERY ANALYSER with a FOR XML clause are not yielding correctly formatted results. I am expecting to see XML elements returned on individual lines. Instead my results are returned all concatenated onto one line and truncated after 256 characters (the default for a column in my results tab). I can increase the number of characters but that does not improve the formatting. Large result sets produce multiple rows but the next row does not start where the previous one finished, so the correct results cannot be reconstructed even by manually adding carriage returns

e.g.

My query

SELECT Code, ClassName FROM CLASSMAPPING
FOR XML RAW

returns the results like this, it's a single line of text word-wrapped and truncated after 256 characters:

<row Code="AUS" ClassName="Australia"/><row Code="CAN" ClassName="Canada"/><row Code="GBR" ClassName="UK"/><row Code="IRL" ClassName="Ireland"/><row Code="NZL" ClassName="New Zealand"/><row Code="PAR" ClassName="Partner schools"/><row Code="USA" ClassName=

But I surely I should really see results laid out like this:

I can't find any information about a switch or trigger to make this work but all the literature I've read indicates it should work. Has anyone seen this before? Can you help?

I have SQL server 2000 with W2K3 server.

I don't think FOR XML does any attempt to format the XML it generates for human reading so you have to live with lack of line breaks and indentation. If you look at the result in an XML editor then it should provide you an option to pretty print the XML.

|||

I am not an expert but I am trying to learn like you; maybe something like this?

Code Snippet

declare @.xml xml
set @.xml = '<row Code="AUS" ClassName="Australia"/><row Code="CAN" ClassName="Canada"/><row Code="GBR" ClassName="UK"/><row Code="IRL" ClassName="Ireland"/><row Code="NZL" ClassName="New Zealand"/><row Code="PAR" ClassName="Partner schools"/>'

select x.t.query('.') as Results from @.xml.nodes('/row') x(t)

/*
Results
-
<row Code="AUS" ClassName="Australia" />
<row Code="CAN" ClassName="Canada" />
<row Code="GBR" ClassName="UK" />
<row Code="IRL" ClassName="Ireland" />
<row Code="NZL" ClassName="New Zealand" />
<row Code="PAR" ClassName="Partner schools" />
*/

|||Are you sure about this? Many queries on an average database will generate far more than the maximum 8192 characters for a single line. The results out of QUERY ANALYSER will be pretty much unusable in almost every case. That doesn't seem very sensible. Surely at least each <row /> element (FOR XML RAW) would drop into a separate results row?
|||I have not done much with SQL Server 2000 but with SQL Server 2005 the XML generated with FOR XML is all on one line. However SQL Server Management Studio or Management Studio Express has a built-in XML editor pane where it pretty prints and colorizes the XML for human viewing.|||OK, thanks for confirming this.
|||

I have, I think, the same problem; given N rows, return a recordset with N xml documents.

The 'FOR XML EXPLICIT' looks like the way to go, except that I can't break up the result into distinct rows.

|||

Could be that this solution will help;

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1702105&SiteID=1

Bit of a beginner question on SQL-XML

e.g.

My query

SELECT Code, ClassName FROM CLASSMAPPING
FOR XML RAW

returns the results like this, it's a single line of text word-wrapped and truncated after 256 characters:

But I surely I should really see results laid out like this:

I can't find any information about a switch or trigger to make this work but all the literature I've read indicates it should work. Has anyone seen this before? Can you help?

I have SQL server 2000 with W2K3 server.

|||

I am not an expert but I am trying to learn like you; maybe something like this?

Code Snippet

select x.t.query('.') as Results from @.xml.nodes('/row') x(t)

I have, I think, the same problem; given N rows, return a recordset with N xml documents.

The 'FOR XML EXPLICIT' looks like the way to go, except that I can't break up the result into distinct rows.

|||

Could be that this solution will help;

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1702105&SiteID=1

Tuesday, March 27, 2012

books online tutorial - why am i getting an error?

Friday, February 24, 2012

BLAST (Basic Local Alignment Search Tool)

BLAST (Basic Local Alignment Search Tool)

BLAST (Basic Local Alignment Search Tool)

Friday, February 10, 2012

bit off topic: street name database US

Bit of a beginner question on SQL-XML

Bit of a beginner question on SQL-XML

sql bit data type

Blog Archive

About Me