|
|
hi ,
In "DB1" database I have tables called "Warehouse" and "Machines"
Both are related, 1 Warehouse can have many machines. 1 to many relation ship.
But there is another table "Warehouse" in another database = "DB2"
The one in DB2 is the original Warehouse table which has all the data. Since warehouse and machines are related, I thought of having a warehouse table in DB1 and later can run a SQL job to update the table in DB1 from the one in DB2 . But my requirement is such that I should not have the Warehouse table in DB1, but use the same one in DB2.
But I know that I cant relate tables from 2 databases.
How can I achieve the above requirement
Happy Programming!
Regards,
ctrlnick !
|
|
|
|
|
|
Both the databases are under the same server
Happy Programming!
Regards,
ctrlnick !
|
|
|
|
|
Was this a statement or do you have another question?
only two letters away from being an asset
|
|
|
|
|
Hi ,
I thought linked server was used for 2 different server.
So I wanted to know how to implement that on tables on same servers
Thanks
Happy Programming!
Regards,
ctrlnick !
|
|
|
|
|
Your DB2 database is external to SQL Server, it doesn't matter that it is physically on the same server.
only two letters away from being an asset
|
|
|
|
|
If this is SQL Server, you cannot use referential integrity between two databases even if they are on the same instance. Instead you can implement the logic using triggers. In the triggers you can reference the table from the other local database using notation: databasename.owner.table. For example:
SELECT * FROM OtherDatabase.dbo.Warehouse;
|
|
|
|
|
I want to remove the selected attributes of the HTML tags select language C #.
I have to write source how?
|
|
|
|
|
trinm1987 wrote: I have to write source how?
I use Visual Studio to write code, but you could certainly use any another editor, such as NotePad, or EdLin.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
please just give me a specific source in C #
|
|
|
|
|
Well that's not like this site is working. Post more specific questions!!!
I guess that English is not your mother tongue. Maybe we here at CodeProject could make an exception and you can post your question in another language.
Maybe somebody can help you then.
Regards
Sebastian
|
|
|
|
|
I usually encrypt source code that I post here. Is that okay?
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
Try in way like : i.e.
TextBox.Attributes.Remove("maxlength" );
Parwej Ahamad
|
|
|
|
|
it is un-selected attributes of the textbox I want to remove attribute selected card in HTML source code in C #.
Because I do applications access data from Web
|
|
|
|
|
1- Make as server control.
<select>runat="server" id="Select1">
<option>121</option>
<option>122</option>
</select>
2- In back end code
Select1.Items.Remove(select1.SelectedIndex)
Parwej Ahamad
|
|
|
|
|
Yes thank you!
I want to embed javascript into the C # do?
|
|
|
|
|
|
Oh no! I just want to embed JavaScript code to C #. But I do not know cach.Ban only help me home.
Thank you
|
|
|
|
|
Use RegisterStartupScript to embed in you c# code
Parwej Ahamad
|
|
|
|
|
you can show me the specific source is not?
|
|
|
|
|
i created a form, but later noticed that i have four rows of student data for 1 ID, how do i bring back the four rows of data?
Ferron
|
|
|
|
|
Your DB is obviously broken. You can do a select to get the four rows, but if they have the same Id, then you have a bigger issue.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
they have the same id, but different addresses, so i wanna be able to print all those addresses
Ferron
|
|
|
|
|
is it the way you (outer) join the data in SQL?
Could you post your query
|
|
|
|