Click here to Skip to main content
15,072,776 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL:what is wrong in following query Pin
xodeblack25-Aug-09 23:00
Memberxodeblack25-Aug-09 23:00 
GeneralRe: SQL:what is wrong in following query Pin
Sebastian Br.26-Aug-09 0:41
MemberSebastian Br.26-Aug-09 0:41 
AnswerRe: SQL:what is wrong in following query Pin
Ashfield26-Aug-09 1:35
MemberAshfield26-Aug-09 1:35 
QuestionSQL Server login problem Pin
mlowry25-Aug-09 11:35
Membermlowry25-Aug-09 11:35 
AnswerRe: SQL Server login problem Pin
Vimalsoft(Pty) Ltd27-Aug-09 0:04
professionalVimalsoft(Pty) Ltd27-Aug-09 0:04 
AnswerRe: SQL Server login problem Pin
cdpace28-Aug-09 11:33
Membercdpace28-Aug-09 11:33 
AnswerRe: SQL Server login problem Pin
mlowry29-Aug-09 6:32
Membermlowry29-Aug-09 6:32 
Questionxml schema Pin
Ebube25-Aug-09 6:19
MemberEbube25-Aug-09 6:19 
what is wrong with this code


create XML SCHEMA COLLECTION JointCollection
AS
N'<xs:schema
attributeformdefault="unqualified"
elementformdefault="qualified"
xmlns="http: www.w3.org="" 2001="" xmlschema"="">
<xs:element name=":Members"">
<xs:complextype>
<xs:sequence>
<xs:element maxoccurs="unbounded" name="Member">
<xs:complextype>
<xs:sequence>
<xs:element name="LastName" type="xs:string">
<xs:element name="FirstName" type="xs:string">
<xs:element name="MiddleName" type="xs:string">
<xs:element name="GenderId" type="xs:int">
<xs:element name="Telephone" type="xs:string">
<xs:element name="Email" type="xs:string">
<xs:element name="ContactAddress" type="xs:string">
<xs:element name="ContactCity" type="xs:string">
<xs:element name="ContactStateId" type="xs:int">






'


when i execute this in sql server 2005 i got error
Msg 9459, Level 16, State 1, Line 1
XML parsing: line 4, character 41, undeclared prefix
AnswerRe: xml schema Pin
Henry Minute25-Aug-09 6:56
MemberHenry Minute25-Aug-09 6:56 
QuestionCreating the XML Schema Pin
Ebube25-Aug-09 1:15
MemberEbube25-Aug-09 1:15 
AnswerRe: Creating the XML Schema Pin
David Mujica25-Aug-09 3:13
MemberDavid Mujica25-Aug-09 3:13 
QuestionADO.NET / Update Column in memory Pin
Sebastian Br.24-Aug-09 23:42
MemberSebastian Br.24-Aug-09 23:42 
AnswerRe: ADO.NET / Update Column in memory Pin
N a v a n e e t h25-Aug-09 2:05
MemberN a v a n e e t h25-Aug-09 2:05 
GeneralRe: ADO.NET / Update Column in memory Pin
Sebastian Br.25-Aug-09 2:55
MemberSebastian Br.25-Aug-09 2:55 
QuestionCHECKING NULL VALUES Pin
dotnetcsharpdev24-Aug-09 23:31
Memberdotnetcsharpdev24-Aug-09 23:31 
AnswerRe: CHECKING NULL VALUES Pin
dotnetcsharpdev25-Aug-09 0:19
Memberdotnetcsharpdev25-Aug-09 0:19 
GeneralRe: CHECKING NULL VALUES Pin
Ashfield26-Aug-09 1:43
MemberAshfield26-Aug-09 1:43 
Questionregarding foreignkey data Pin
kheer24-Aug-09 23:12
Memberkheer24-Aug-09 23:12 
AnswerRe: regarding foreignkey data Pin
dotnetcsharpdev24-Aug-09 23:33
Memberdotnetcsharpdev24-Aug-09 23:33 
GeneralRe: regarding foreignkey data Pin
kheer24-Aug-09 23:58
Memberkheer24-Aug-09 23:58 
GeneralRe: regarding foreignkey data Pin
dotnetcsharpdev25-Aug-09 0:16
Memberdotnetcsharpdev25-Aug-09 0:16 
GeneralRe: regarding foreignkey data Pin
Ashfield26-Aug-09 1:44
MemberAshfield26-Aug-09 1:44 
GeneralRe: regarding foreignkey data Pin
kheer26-Aug-09 22:01
Memberkheer26-Aug-09 22:01 
QuestionMerging multi results into one row Pin
Wouter Coinless24-Aug-09 9:12
MemberWouter Coinless24-Aug-09 9:12 
AnswerRe: Merging multi results into one row Pin
Luc Pattyn24-Aug-09 9:39
sitebuilderLuc Pattyn24-Aug-09 9:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.