|
you must use two table with foreign key in another table.
One table include (SeedID,FirstName,LastName,Gender and CultureID foreign key) and another table include(CultureID PrimeryKey,Culture)
|
|
|
|
|
This is the repost as my code snippet was not formatted correctly.
I have got a field in a table which is of xmltype, say file_block
the data for the same is structured as shown below
<data type="Structure">
<control id="txtWeight">
<value>74</value>
</control>
<control id="txtHeight">
<value>174</value>
</control>
</data>
And the above structure is taken in different ways for different
purposes in project so i cannot change that
DATA VALUE
txtWeight 74
txtHeight 174
Now how could i retrieve the data as a tabular structure as shown above using xquery. Please help if anyone know how to do that
|
|
|
|
|
Are you still having troubles with this?
Please... SAVE my time by rating the posts that you read!
There are 10 kinds of people in the world: those who understand binary and those who don't.
|
|
|
|
|
I have got a field in a table which is of xmltype, say file_block
the data for the same is structured as shown below
data type="Structure">
control id="txtWeight">
value>74/value>
/control>
control id="txtHeight">
value>174/value>
control>
/data>
(I have removed the '<' tags from the xml code as codeproject
is only taking the content 174 and 74 only while removing all other
codes as they are treating the code as a formatted one... So
please read my code by prepending the appropriate line with '<')
Now I want to retrieve the values from it as follows
Data Value
txtWeight 74
txtHeight 174
And the above structure is taken in different ways for different
purposes in project so i cannot change that. Now how could i retrieve the data as a tabular structure as shown above using xquery. Please help if anyone know how to do that.
|
|
|
|
|
hi all,
I want to do following task as programmaticaly (not manually) to Allow Remote Connection
1.Enable the Shared memory, Named Pipes, TCP/IP protocols in SQL Server Configuration.
2.Allow Local And Remote connection which we perform IN SQL Surface area configuration.
3.Restart SQL Browser and SQL Server After making changes.
4.Create Login on Remote SQL Server
I face above problem when i Installed SQL Express on one machine and Try to connect to Remote SQL Server. Also if I want to Connect to Remote server, then Guest Account(or SQL Authentication) must be Configured on Remote machine. So how can i Configure the Account on remote server Programmatically or how can i Get the Configured account which is on Remote server . so using this account information i can connect to Remote SQLServer.
one more thing I am able connect to Remote server using trusted connection but failed to connect to Database. I use Following statement to connect to Remote SQL Server
Dim MainServer As Server = New Server(cboServer.Text.Trim & "\SQLEXPRESS")<br />
With MainServer.ConnectionContext<br />
.LoginSecure = True<br />
.ConnectionString = "Trusted_Connection=Yes;"<br />
.Connect()<br />
.PublicServerName = cboServer.Text.Trim<br />
frmLogin.Show()<br />
Me.Close()<br />
.Disconnect()<br />
End With
but i am unable to Use Databse which reside on Remote server. I use following connection string
Dim ConnectionString As String = "Data Source=" & PublicServerName & "\SQLEXPRESS;Integrated Security=True;Initial Catalog=ABC "
or
Dim ConnectionString As String =Data Source=" & PublicServerName & "\SQLEXPRESS;Initial Catalog=ABC;Trusted_Connection=Yes; "'
but this time it give error "Login failed for user MachineName\Guest"
I try lot of googling but nothing is helpful. Please provide appropriate guidance to me
|
|
|
|
|
Hi,
You can use SAC command line utility for importing configurations. Restarting services would be most easy with NET START / NET STOP commands and after that the login can be created using T-SQL (CREATE LOGIN ).
Hope this helps,
Mika
|
|
|
|
|
sir, can i change the default setting during installation of SQL Server.Importanat thing is that i want to Install SQL Server In Silent mode and i want to change all specified setting during Installation
|
|
|
|
|
Ok,
Most of the settings can be configured during silent installation. The key is TEMPLATE.INI-file. Have a look at this article http://msdn.microsoft.com/en-us/library/ms144259.aspx[^].
I don't remember if all of the things you wanted to do are possible. For example login creation may not be possible, but you can always use a custom command line script, which first runs install and configuration and then use (for example) OSQL to create login silently.
Hope this helps,
Mika
|
|
|
|
|
I have one table and the columns are exactly as they should be. I am sent new data that needs to match the columns headings of this first table exactly. How do I create a sql query (it's really in Access) that does a quick compare and show me any differences or how the new violates the standard?
|
|
|
|
|
By violates do you mean violates a foreign key?
|
|
|
|
|
There are no keys. I simply want to check the column headings with a table we know is correct with the new incoming table. How does the new table (if at all) differ from the standard (I know the columns are right) table.
|
|
|
|
|
I use ado _RecordsetPtr to get an item from oracle database using GetValue()to read a field named Source which is of varchar2(10) datatype.
variant_t vtSource = rst->Fields->GetItem("SOURCE")->GetValue();
Can anyone show me sample code on how to convert vtSource which is of variant_t data type to char* or char array or const char* or CString data type?
|
|
|
|
|
How to get the output parameter value
|
|
|
|
|
Check this google result.[^]
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
|
hi all,
can any body help me to find the SQL Server Express which is compatible to Vista. If yes then Please provide the link So i can download the SQL Server
|
|
|
|
|
|
Are you sure that the link,Provide by you is For SQL Express(Compatible with vista)
|
|
|
|
|
|
sir,
perhaps this version is not compatible with VISTA since when i run this, this system prompt me that this product has known comaptibility issue .Please suggest
|
|
|
|
|
Did you download SQL Express 2005 and not MSDE. MSDE is not compatible with Vista. For example I have SQL Server 2005 downloaded from there and I'm running it on Vista.
Also, are you sure that you don't have any earlier Beta or CTP versions of SQL Server 2005 or .NET framework 2.0? These are not compatible with the product version.
Here's another link directly to download page and information about installation.
http://www.microsoft.com/express/sql/download/default.aspx[^]
Mika
|
|
|
|
|
|
I have an IMS project which authenticate user against the AD. Now, I want that if user enter the wrong password 3 timesm his account get the lock .
to lock user i am using
objDirectEntry.Properties["LockOutTime"].Value = 1;
objDirectEntry.CommitChanges();
if i set any value rather than 0 to objDirectEntry.Properties["LockOutTime"] , it throw exception.
Anoop Sihag
|
|
|
|
|
When i have to sql sever 2005,How to make connection string?
please help to me
|
|
|
|
|
If you can't figure this out you really shouldn't be writing code. Try Google.
Bob
Ashfield Consultants Ltd
|
|
|
|