Database

FirstPrevNext

Re: How can I add a string that has a single quote character in it? Daniel Turini10-Dec-02 1:40 Daniel Turini 10-Dec-02 1:40  You need to execute the query with prepared statements. Depending on the language you are using look for something named Command or SQLCommand and a collection named Parameter or SQLParameters. Forget about double-quotes. More details in my article[^] I see dumb people Re: How can I add a string that has a single quote character in it? Bart-Man10-Dec-02 3:39 Bart-Man 10-Dec-02 3:39  Hello, Thanks for the link to your article, it was very helpful!! Re: How can I add a string that has a single quote character in it? David Salter11-Dec-02 10:37 David Salter 11-Dec-02 10:37  Daniel Turini wrote: Forget about double-quotes. More details in my article[^] Does that work in ODBC also? Dave Re: How can I add a string that has a single quote character in it? Daniel Turini11-Dec-02 11:49 Daniel Turini 11-Dec-02 11:49  Davey wrote: Does that work in ODBC also? Yes, it works. Almost any modern database access technology will provide functionality simillar to ADO's Command/Parameter. I see dumb people Record Number ... RJS9-Dec-02 7:41 RJS 9-Dec-02 7:41  Hi, I would like to know if it is possible to do something like these: 1) select field1,field2 from table_name where line_number_in_table >50 and line_number_in_table < 100 in sql2000? So I would get only those records between the 50 and the 100.. 2) Is there any similar command in sql2000 for rownum in Oracle? Thanks a million! Re: Record Number ... David Salter9-Dec-02 10:04 David Salter 9-Dec-02 10:04  RJS wrote: 2) Is there any similar command in sql2000 for rownum in Oracle? Select top xxx * from tablename e.g. select top 10 * from authors Re: Record Number ... Not Active9-Dec-02 14:33 Not Active 9-Dec-02 14:33  That will only get the top 10 rows. You would need to use your index( if you have one) to select the rows. select * from table where index > 50 and index < 100 This assumes that the index is numberic and sequential. Re: Record Number ... Daniel Turini10-Dec-02 1:43 Daniel Turini 10-Dec-02 1:43  RJS wrote: 1) select field1,field2 from table_name where line_number_in_table >50 and line_number_in_table < 100 in sql2000? No. You need a real column. BTW, in SQL, in general, it's a bad practice to assume a physical order of records in a query. RJS wrote: Is there any similar command in sql2000 for rownum in Oracle? No, but you can fake it. I see dumb people Partial Search Sarvesvara (BVKS) Dasa9-Dec-02 1:25 Sarvesvara (BVKS) Dasa 9-Dec-02 1:25  I want to do a partial no search in the database... Like... I want to search the data containing just the characters "age" in it. Is this possible in MS-Access-2000?? I want to access this through my ASP page!! I started with nothing, And I still have lots of it left with me. Re: Partial Search Not Active9-Dec-02 2:09 Not Active 9-Dec-02 2:09  I think you need to sit down with a good book on SQL and Database Design before asking any more questions. We will give you help but you need to do some work also. Re: Partial Search Sarvesvara (BVKS) Dasa9-Dec-02 2:39 Sarvesvara (BVKS) Dasa 9-Dec-02 2:39  Mark Nischalke wrote: sit down with a good book on SQL and Database Design Phew... If at all I have the time, I wont have posted this question to the site. All my responsibility on me is to port from ms-access to sql-server 2000. And finally, some more current jobs like this search too. What shall I do other that hook on my questions to cp. If u have answers... let me know.... I am posting the question to get idea. I am not asking u do come and do my project as a whole.... Thanks I started with nothing, And I still have lots of it left with me. Re: Partial Search David Salter9-Dec-02 3:00 David Salter 9-Dec-02 3:00  In its simplest form: select requiredcolumn from table where column like '%age%' will do the job. Dave. Re: Partial Search Sarvesvara (BVKS) Dasa10-Dec-02 20:33 Sarvesvara (BVKS) Dasa 10-Dec-02 20:33  Thanks dear!! I started with nothing, And I still have lots of it left with me. Linking tables Sarvesvara (BVKS) Dasa8-Dec-02 18:38 Sarvesvara (BVKS) Dasa 8-Dec-02 18:38  I have two tables in my MS-Access database. TableA has list of the doctors and attached clinics, address etc. TableB has the list of hospitals, address etc. The problem is the address,phone etc are repeating data in both the tables. The tables are very big 400 and 600 data respectively. Any way to link the database and gat the stuff working soon, and have the same table names respectively. I access them using my ASP page. I started with nothing, And I still have lots of it left with me. Re: Linking tables Mazdak8-Dec-02 19:58 Mazdak 8-Dec-02 19:58  Add autonumber primary key to TableA,then add foreign key to TableB and put its reference as TableA. Mazy "And the carpet needs a haircut, and the spotlight looks like a prison break And the telephone's out of cigarettes, and the balcony is on the make And the piano has been drinking, the piano has been drinking...not me...not me-Tom Waits Re: Linking tables Sarvesvara (BVKS) Dasa8-Dec-02 22:57 Sarvesvara (BVKS) Dasa 8-Dec-02 22:57  Mazdak wrote: Add autonumber primary key to TableA It is already like that.... Similar is the TableB. Now how do I change that one?? and Mazdak wrote: put its reference as TableA. How to do it in Ms-Access??? I started with nothing, And I still have lots of it left with me. Re: Linking tables Mazdak9-Dec-02 7:39 Mazdak 9-Dec-02 7:39  SPS wrote: How to do it in Ms-Access??? Errrrr,I don't know so much about Access,but I think it must have it. Mazy "And the carpet needs a haircut, and the spotlight looks like a prison break And the telephone's out of cigarettes, and the balcony is on the make And the piano has been drinking, the piano has been drinking...not me...not me-Tom Waits Re: Linking tables Sarvesvara (BVKS) Dasa10-Dec-02 20:34 Sarvesvara (BVKS) Dasa 10-Dec-02 20:34  Mazdak wrote: I think it must have it. I wish it has the feature! I started with nothing, And I still have lots of it left with me. Newbee question Sarvesvara (BVKS) Dasa7-Dec-02 19:40 Sarvesvara (BVKS) Dasa 7-Dec-02 19:40  I am verymuch new to SQL-Server applications.... All the time, I have managed to do my database with the MS-ACCESS itself. And trying to pick the SQL... as I just identified that my website supports that too. And got the stuff installed in my PC now.... It says... SQL Server 2000... I want to use it with my HTML/ASP applications My question is.... WHERE DO I START??? What should I do to configeure with my local IIS? What Should I do to create my database? How do I create table?? How do I upload to my site?? Any article to explain to this new-to-SQL preson?? Thanks in advance.... I started with nothing, And I still have lots of it left with me. Re: Newbee question Not Active8-Dec-02 10:01 Not Active 8-Dec-02 10:01  SPS wrote: What should I do to configeure with my local IIS? Nothing unless you want to use SQLHTTP, but I think that is out of your scope right now. SPS wrote: What Should I do to create my database? Since you have SQL Server 2000 installed use the Enterprise Manager. Look in the database section of this site or use the Books Online for SQL Server. SPS wrote: How do I create table?? Same as above SPS wrote: How do I upload to my site?? You don't upload the database to your site. Your pages connect to the database using such things like SqlConnection and SqlCommand Re: Newbee question Sarvesvara (BVKS) Dasa8-Dec-02 18:28 Sarvesvara (BVKS) Dasa 8-Dec-02 18:28  Mark Nischalke wrote: Your pages connect to the database using such things like SqlConnection and SqlCommand I dont own the site... I mean... the rented web-space. So the database should be uploaded is it?? Should I upload the corresponding .mdf file?? I started with nothing, And I still have lots of it left with me. Re: Newbee question Jeremy Oldham9-Dec-02 1:43 Jeremy Oldham 9-Dec-02 1:43  Remeber that SQL Server is not like Microsoft Access. Microsoft Access is a file base database. Everything you need is contained in the database file. SQL Server is on a server based architecture. Although there is a file(s) related to the databases withing SQL Server, they are not the same as the Access files. In order to get data from a SQL Server, you must connect to the Server. If you have SQL Server on your personal machine at home, then it would have connected to the internet at all times in order for you to access it. If this is not an option, then you need to check with your service provider to see if they have SQL Server installed. Jeremy Jeremy Oldham Re: Newbee question Sarvesvara (BVKS) Dasa10-Dec-02 20:38 Sarvesvara (BVKS) Dasa 10-Dec-02 20:38  Jeremy Oldham wrote: if they have SQL Server installed. The sql server is inatalled... I will ask them the details then! I started with nothing, And I still have lots of it left with me. SQL Data Type info in SQLDMO Paul Watson7-Dec-02 2:34 Paul Watson 7-Dec-02 2:34  I am looping through all Columns in a Table using SQLDMO. I need to ouput both the datatype and the length of that datatype. That is pretty simple, the problem comes when the DataType is bit, int etc. These DataTypes in a Stored Procedure parameter declaration must not have their lengths specified. But DataTypes like navarchar must have it declared. Now I could do a long and ugly switch/if statement which filters out the bits and ints but it seems, well, long and ugly. Is there a way to programaticaly check if the DataType must have it's length declared or not in SQLDMO or .NET? ta Paul Watson Bluegrass Cape Town, South Africa Christopher Duncan wrote: Which explains why when Santa asked, "And what do you want for Christmas, little boy?" I said, "A life." (Accesories sold separately) Re: SQL Data Type info in SQLDMO Richard Deeming9-Dec-02 1:26 Richard Deeming 9-Dec-02 1:26  AFAIK: decimal needs scale and precision; float needs size; char, varchar, nchar and nvarchar need size; Everything else doesn't. One thing you may run in to: nvarchar with a size of 1,073,741,823 is actually ntext, and varchar with a size of 2,147,483,647 is actually text. I've seen the problem with ADO and ADO.NET, so SQLDMO may be affected as well. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Last Visit: 31-Dec-99 18:00     Last Update: 24-Sep-24 6:34 Refresh ᐊ Prev1...2387238823892390239123922393239423952396 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.