Database

Check these out ... http://www.toadworld.com/Freeware/ToadforOracleFreeware/tabid/558/Default.aspx[^] http://squirrel-sql.sourceforge.net/[^]

Please try to add some further information, perhaps we can understand then what you are trying to do. Which database do you use - Oracle? What is that "partition" - a partition of your hard disk, a "table space", ...? What is the "scheme" - is that the wording used by Oracle? And finally, what do you mean with "applied to my table"? Do you want to copy/move your table to that scheme?

That doesn't sound like a database question.

Is your situation is like this[^]

As there is a fundamental problem with change management I think that would be the least of his problems. It sounds like he does not own the database and he is not in the change management loop. We recently had something like this where the IT team changed a view that was feeding us and did not inform the clients of the view. A rocket went around the IT team and we are now in the CM loop. Never underestimate the power of human stupidity RAH

thnx,but if ay one plz do it in sql

Seems that you can't directly drop a remote table then. How about creating a sproc in the remote database that takes a tablename and drops it? Could that be called with the three prefixes? I are Troll :suss:

Hi, thanks for your answer; I will get the solution in the last post.

ASP is the older serverside scriptlanguage ASP.NET is the newer version ADO is what's used to talk to the database AJAX is used to have the client call some serverside function Do you have a webserver that's capable of running ASP.NET pages? You can verify by executing a small test-aspx :) I are Troll :suss:

You're welcome. I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be Forgive your enemies - it messes with their heads My blog | My articles | MoXAML PowerToys | Onyx

I'm not sure how you would get table modifications, however getting RECORD modifications is a VERY simple excercise, you do have a number of options. ALL of them require additional columns/fields to be added to the tables you want to monitor. We monitor all tables so we have a Modified and ModifiedBy on all tables. Add a timestamp field to the table and trigger it every time a record is saved, I think you can trigger this in access, not sure anymore. From your UI pass in the userid and datetime whenever you write back to the database. In your update/insert query automatically gather the current user and the datetime and add then to the update/save Never underestimate the power of human stupidity RAH

you're welcome. :) Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

There's an ebook for this[^] one. The printed copy is excellent (I never buy ebooks, I prefer paper copy). I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be Forgive your enemies - it messes with their heads My blog | My articles | MoXAML PowerToys | Onyx

As Luc Pattyn said get top 1 value which is lower then max value, Look this example and hope you will figure out with your case: SELECT MAX(vlera) HighestValue, (SELECT TOP 1 m.vlera FROM mytable m WHERE m.vlera < (SELECT MAX(vlera) FROM mytable) ORDER BY vlera DESC) secondHihgestValue FROM mytable I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

Hrm. It appears that I wasn't setting InitialCatalog when building the connection string, at least not in the right place. You don't have to have an initial catalog when testing a connection to a database, which is code near what I'm doing, but you do have to have it to access database tables. I was worried that it was something simple - turns out it was. Upon reflection, I'm kind of glad.

You can try like the following For SQL Select Processid From OPENXML(@xml_hndl, 'root/Process') With ( ProcessId int ) Use XML as '<root><Process ProcessId="8712"></Process> <Process ProcessId="1424"></Process></root>' Look http://msdn.microsoft.com/en-us/library/aa276847%28SQL.80%29.aspx[^]

It's printed correctly. Query's return type is an array string(I've implemented like that). So, I've to convert it to int using atoi.

Alter Procedure sp_TablolaraEkle @marka_ad nvarchar(50), @model_ad nvarchar(50) as Begin Set Nocount on Declare @id int Declare @Marka nvarchar(50) Select @id=id From Marka where marka_ad=@marka_ad IF isnull(@id,0)=0 BEGIN INSERT INTO Marka(marka_ad) values (@marka_ad) SELECT @id=@@Identity insert into Model(marka_id,model_ad)values (@id,@model_ad) END Else BEGIN insert into Model (marka_id,model_ad) values(@id,@model_ad) END End ok man i altered my procedure like it and it works now as i wished..thanks for your help...

?! And if i really need to nest transactions ??