Database

FirstPrevNext

Re: Functions in SQL Server...... Colin Angus Mackay15-Mar-07 23:21 Colin Angus Mackay 15-Mar-07 23:21  Databases are set based - That means there is no order. The implementation of most database systems give the illusion of order, but that is just a by-product of the algorithms used in the implementation. There is no guarantee that the perceived order will be preserved if you migrate to a new database, upgrade your existing database, or possibly even if you apply a service pack. Next, Where does this "Submain" come from - the code you showed cannot create that row? Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects My website Re: Functions in SQL Server...... Smart_Boy15-Mar-07 23:37 Smart_Boy 15-Mar-07 23:37  Sir, I didnt got ur First Point.... And regarding Submain1 it just a column in table which i ve not inclucded. Its just a reference..... Regards, Smart Boy Mumbai, (INDIA) Re: Functions in SQL Server...... Colin Angus Mackay16-Mar-07 1:21 Colin Angus Mackay 16-Mar-07 1:21  Smart_Boy wrote: I didnt got ur First Point.... You want the data to be inserted in a specific order. You cannot. The table contains no order. Any perceived order is an illusion created by the specific implementation of the database. If you attempt to add an order by class to an INSERT statement it will come back with an error. The order data is inserted is not necessarily the order in which it is stored. The order in which the data is stored may change. It is outwith your control. If you want the data to be retrieved in a specific order then you have add some markers to the table so that it can be done. e.g. The table contains the columns: Menu, SubMenu, Detail, Combined The first three columns can be used in an ORDER BY clause. The last column is used in the SELECT's column list SELECT Combined FROM MyTable ORDER BY Menu, SubMenu, Detail The INSERT statements would need to be altered to add the additional data to your table, with nulls in place where there is no relevant information. Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects My website Re: Functions in SQL Server...... Smart_Boy16-Mar-07 18:37 Smart_Boy 16-Mar-07 18:37  Thanks Sir, I forgetted dat i ve given order column in the table. And I used UNION to join 2 tables, and then given order by order column. Thank you Sir for ur help.. My task is Achieved...... Regards, Smart Boy Mumbai, (INDIA) SQL Server 2000 and 2005 [moved] Richard Andrew x6413-Mar-07 10:51 Richard Andrew x64 13-Mar-07 10:51  Do SQL Server 2000 and 2005 co-exist peacefully on the same development machine, or should I uninstall 2005 before installing 2000? -- moved at 17:18 Tuesday 13th March, 2007 -------------------------------- "All that is necessary for the forces of evil to win in the world is for enough good men to do nothing" -- Edmund Burke Re: SQL Server 2000 and 2005 MoustafaS13-Mar-07 10:58 MoustafaS 13-Mar-07 10:58  I have SQL server 2000 and SQL server express 2005 installed, and no problem occurred. ------------------------------ "About : Islam ..." Re: SQL Server 2000 and 2005 Richard Andrew x6413-Mar-07 11:00 Richard Andrew x64 13-Mar-07 11:00  Thanks for your post. I'll give it a try. -------------------------------- "All that is necessary for the forces of evil to win in the world is for enough good men to do nothing" -- Edmund Burke Re: SQL Server 2000 and 2005 [moved] Bad Programmer13-Mar-07 15:02 Bad Programmer 13-Mar-07 15:02  We can't install lower version of SQL Instance, if we have higher version in it But its possible for reverse (SQL 2000 and then SQL 2005) Bala, Hero ITES, Gurgaon (INDIA) Re: SQL Server 2000 and 2005 [moved] kaliem13-Mar-07 21:35 kaliem 13-Mar-07 21:35  "We can't install lower version of SQL Instance, if we have higher version in it" its not the case. We can still install lower version, yeah some unexpected problems might happen and sometimes , you have to break head with the nearest wall. In my case, I installed SQL 2005 Express and then SQL 2000 Enterprise on my machine, When i tried running DotNetNuke there, it said "Failed to generate server instance of SQL Server" something like that. Recommended: I think you better use only one , or if you want two, go from 2000 to 2005. Btw, 2007 is in line now Re: SQL Server 2000 and 2005 [moved] Keshav V. Kamat13-Mar-07 22:53 Keshav V. Kamat 13-Mar-07 22:53  It shouldnt be a problem at all. Keshav Kamat India Connection string problem Saira Tanwir13-Mar-07 9:11 Saira Tanwir 13-Mar-07 9:11  hi i'm trying to connect to the server without giving the static connection string. i want my application to access the connection string automatically. i'm using the follwoing code, but it doesn't give the connection string ConnectionString = @""; conn = new OleDbConnection(ConnectionString); cmd = conn.CreateCommand(); can u please explain that what am i missing, as i've already used the same code once and it is still working, but now that i am using the same code at some other location in the application it is not working. thanku for the time Re: Connection string problem Marcus J. Smith13-Mar-07 10:07 Marcus J. Smith 13-Mar-07 10:07  ConnectionString = ConfigurationManager.ConnectionStrings("YourConnectionString") CleaKO "I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School) Re: Connection string problem Saira Tanwir13-Mar-07 11:16 Saira Tanwir 13-Mar-07 11:16  thank u help me about this query sepel13-Mar-07 5:43 sepel 13-Mar-07 5:43  i have two table first table is "book " .that i keep book information in this and the next table is "Translater" that i store name,lname,id of translaters in it. i want to create a query to see all information of all book with and without translater such as: --title -transName---transLastName ..... ...... ....... and if a book has not any translater fill that filed free in query i use a table to join them to each other "BT" that contain book.id and trans.id but when execute query i just see the book that have translater and i can't see all book how can i see all of my book? sepel Re: help me about this query Marcus J. Smith13-Mar-07 5:52 Marcus J. Smith 13-Mar-07 5:52  Use a LEFT JOIN on the Book table. CleaKO "I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School) Re: help me about this query sepel13-Mar-07 5:57 sepel 13-Mar-07 5:57  thanks i test it sepel Database Schema - multiple apps/single table? ehelinProgrammer13-Mar-07 5:19 ehelinProgrammer 13-Mar-07 5:19  Hi: We are combining alot of old applications which each have their own tables and structures within those tables...not really compatible enough to combine straight out...but they could all use the "text" or similar sql server type and be put into one or two "super" tables with a type to differentiate them. On one side, this would vastly simplify our schema and allow the data to be centralized. On the other, its not intuitive and could be confusing if we fall behind with our database schema documentation. But more importantly, having all of these applications hitting these one or two tables puts a fair amount of stress on our server. This table might look something like this: Application 1 is type 1 Application 2 is type 2 Application n is type n Text1--Text2--Text3...--Textn--Type val1 val2 val3 valn 1 val1 val2 val3 valn 2 val1 val2 val3 valn n Any thoughts of this issue would be appreciated. Thanks! Re: Database Schema - multiple apps/single table? Marcus J. Smith13-Mar-07 5:54 Marcus J. Smith 13-Mar-07 5:54  A database should contain data that is related, assuming you are talking about a RDBMS. If the data is not related then putting it all together in a few master tables will be confusing years from now, or even tomorrow if there is enough of it. You could use master DBs for things like zip code and other common fields but to try to mash everything together would be a big mistake IMHO. CleaKO "I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School) Re: Database Schema - multiple apps/single table? ehelinProgrammer13-Mar-07 5:58 ehelinProgrammer 13-Mar-07 5:58  Hi cleako: This is a very valid point...and it will grow. Thanks! Re: Database Schema - multiple apps/single table? ehelinProgrammer13-Mar-07 7:57 ehelinProgrammer 13-Mar-07 7:57  Ok, scrapping this idea and leaving original tables intact...this just ignor every accepted database design practice I have learned...chalk it up to a bad idea Re: Database Schema - multiple apps/single table? Marcus J. Smith13-Mar-07 9:04 Marcus J. Smith 13-Mar-07 9:04  Was this a boss' idea or yours? CleaKO "I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School) Re: Database Schema - multiple apps/single table? ehelinProgrammer13-Mar-07 12:41 ehelinProgrammer 13-Mar-07 12:41  the source will remain nameless to protect the innocent...but it wasn't me exactly...more like an interpretation of a conversation I had with him Guidance for SQL Server 2005 certification Prasad_Quasar13-Mar-07 5:10 Prasad_Quasar 13-Mar-07 5:10  Hi, I have started preparing for SQL Server 2005 certification(Exam 70-431). Can anyone guide me how to proceed or share his own experiance? Your help in this regard will be highly appreciative. Prasad " Learn, grow, heal,and move forward " Connection Timeout to sql server MD1213-Mar-07 5:10 MD12 13-Mar-07 5:10  whenever we connect to sql server it return timeout exception ErrNumber = -2 Query result return in query analyzer it takes 44 seconds and in ADO it returns Connection timeout what we do? First we create a datatset and then create object of dataadaptor and call Fill method after 50 to 60 seconds it returns connection timeout Re: Connection Timeout to sql server Marcus J. Smith13-Mar-07 5:55 Marcus J. Smith 13-Mar-07 5:55  44 seconds is a fairly long time for even Query Analyzer. You can extend the DB connection time in the connection string, I think it defaults to 30 seconds. CleaKO "I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)

Last Visit: 31-Dec-99 18:00     Last Update: 14-Jun-24 11:12 Refresh ᐊ Prev1...1636163716381639164016411642164316441645 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

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