Database

FirstPrevNext

Re: Sql Server 2000 Debugging option joemonvarghese13-Nov-07 1:48 joemonvarghese 13-Nov-07 1:48  thnx for the reply i will check it out... Regards Joe Date Problem : Urgent Suryanairg12-Nov-07 22:02 Suryanairg 12-Nov-07 22:02  I have a problem with one of my sql query Start Date is 10/11/2007 (dd/mm/yyy format) End Date :10/12/2007 I have to get all dates listed from 11/11/2007 to 9/12/2007 (all dates between Start Date & End Date Pls help me... Sunil Nair Re: Date Problem : Urgent [modified] Pete O'Hanlon12-Nov-07 22:20 Pete O'Hanlon 12-Nov-07 22:20  select * from table1 where mydate between @startdate and @enddate. Take a look at UTC and datetime formats to make sure that you are working with your date properly (you are using a stored procedure aren't you - and you are passing @startdate and @enddate in as datetime). -- modified at 4:36 Tuesday 13th November, 2007 Ah - I see from others that you are trying to solve a different problem. Oh well. Deja View - the feeling that you've seen this post before. Re: Date Problem : Urgent Adeel Chaudhry12-Nov-07 22:41 Adeel Chaudhry 12-Nov-07 22:41  Pete, Unless and untill we get to know what solution was exactly required, we are not very sure of the problem. Regards, Adeel Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks. Re: Date Problem : Urgent Adeel Chaudhry12-Nov-07 22:26 Adeel Chaudhry 12-Nov-07 22:26  Hi, Use DATEADD function. For details: http://msdn2.microsoft.com/en-us/library/aa258267(sql.80).aspx[^] And place a loop with a check, if equals the end date, stop. Regards, Adeel Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks. Re: Date Problem : Urgent joemonvarghese12-Nov-07 22:28 joemonvarghese 12-Nov-07 22:28  hi while @fromdate<=@todate begin print dateadd(day,1,@fromdate) set @fromdate=dateadd(day,1,@fromdate) end try this Regards Joe How to filter a number matjame12-Nov-07 21:11 matjame 12-Nov-07 21:11  Hello there guys. Im using MS Access to store colleague's ID numbers and now I need to only the third to till the sixth digits of the ID number to determine if the person's birthday is today.(i.e 840920 5992 081 and I only take 0920 to and check if they are equal to today) Does anyone knw how to do that.Ive tried to trim it and take only those digits but nothing works. Thanx in advance. kagiso Re: How to filter a number Adeel Chaudhry12-Nov-07 22:44 Adeel Chaudhry 12-Nov-07 22:44  Hi, Currently what datatype you are using for storing date of birth? Regards, Adeel Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks. Re: How to filter a number matjame12-Nov-07 22:48 matjame 12-Nov-07 22:48  Hi Adeel. My Birthdate is a string. Same as the IDNumber. Thanx in advance. kagiso Re: How to filter a number Adeel Chaudhry12-Nov-07 22:57 Adeel Chaudhry 12-Nov-07 22:57  Hope this is what you require: http://www.techonthenet.com/access/functions/string/mid.php[^] Regards, Adeel Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks. Re: How to filter a number matjame12-Nov-07 23:09 matjame 12-Nov-07 23:09  Thank you very much.It helped a lot kagiso Create Table prithaa12-Nov-07 18:56 prithaa 12-Nov-07 18:56  Hello, If I want a table with decimal then what is te syntax I should use to create the table. I have doubt about the data type to be used "decimal(10,2)" Is the following right? Create Table Sales (Amt decimal(10,2)) Thanks Prithaa Re: Create Table pmarfleet12-Nov-07 19:42 pmarfleet 12-Nov-07 19:42  Have you tried it? Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush Re: Create Table prithaa12-Nov-07 19:54 prithaa 12-Nov-07 19:54  Hello, Yes I have tried it and it gives me field definition error. I think the problem lies in declaring right kind of data type . decimal(10,2) or numeric(10,2) doesn't work. Pritha Re: Create Table pmarfleet12-Nov-07 21:36 pmarfleet 12-Nov-07 21:36  The syntax you gave in your original post works for me. There must be another error in your code. Have you posted all your code? Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush Re: Create Table Pete O'Hanlon12-Nov-07 22:38 Pete O'Hanlon 12-Nov-07 22:38  When posting a question like this, you may want to include information such as the database you are using. It could be that you we try something on SQL Server that works, and you think we're looking at Access. Deja View - the feeling that you've seen this post before. Re: Create Table venkat vuppala12-Nov-07 23:25 venkat vuppala 12-Nov-07 23:25  try this create table<table name>(<br /> <field1> <datatype>,<br /> <field2> <datatype>,<br /> <field3> <datatype>,<br /> ..................,<br /> ..................,<br /> ..................,<br /> <fieldn> <datatype><br /> ) Re: Create Table prithaa12-Nov-07 23:53 prithaa 12-Nov-07 23:53  Hello, Thanks for your replies I am using this in Access.The statement Create Table Sales (Amt decimal(10,2)) is written in Access. I get the error Syntax error in field definition. Prithaa Server Explorer not visible. mgr_2k712-Nov-07 16:48 mgr_2k7 12-Nov-07 16:48  Message: Clicking on the following menu items does nothing. View -> Server Explorer Tools -> Connect to database Tools -> Connect to server Please advise. Manish Ganguly Re: Server Explorer not visible. joemonvarghese12-Nov-07 17:26 joemonvarghese 12-Nov-07 17:26  hi presess Ctrl+Alt+S try it.. Re: Server Explorer not visible. mgr_2k712-Nov-07 17:29 mgr_2k7 12-Nov-07 17:29  Hi joe, tried it. no luck. What is it suppose to do? Manish Re: Server Explorer not visible. mgr_2k712-Nov-07 23:44 mgr_2k7 12-Nov-07 23:44  FINALLY GOT IT.... HAD TO TYPE THE FOLLOWING IN THE COMMAND PROMPT devenv /resetskippkgs Re: Server Explorer not visible. venkat vuppala12-Nov-07 23:18 venkat vuppala 12-Nov-07 23:18  hi do u try this key (ctrl+alt+L) Database problem kingletas12-Nov-07 11:28 kingletas 12-Nov-07 11:28  hey all, I think this is more problems with the computers i am working on, i don;t have administrator rights, rather than the database itself... I have a database file that i would to have as many applications to access it as possible, but the problem is since i don't have the rights the sql server reportst that under default configurations remote connections cannot be established. However when i add it to each individual application is added it and works fine. My question is, is there a way i can have a central database as i would do if i could have sql server running? I am using C# as the programming language. Thanks all, Best regards... Luis E Tineo S Re: Database problem Michael Sync12-Nov-07 14:29 Michael Sync 12-Nov-07 14:29  You mean, you wanna host the SQL database locally, right? If you are using SQL 2000, you can install MSDE on your Windows 2000, XP. or you can install SQL server if your OS is the server-type (e.g. Windows 2000 Advanced Server or Windows 2003) If you are using SQL 2005, you can install SQL 2005 Express (Advanced setup that includes the Management Studio) on your Windows XP or Vista. Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) "Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."

Last Visit: 31-Dec-99 18:00     Last Update: 24-Sep-24 11:54 Refresh ᐊ Prev1...1344134513461347134813491350135113521353 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.