Database

vanikanc wrote: Sql server 2005 SQL Server is a database server. The end of line character means nothing in the database. There is no way to 'display' it. So that is not how you are using it. Best I can suppose is that you are running the Microsoft SQL Server Management Studio and it show 'rows' and columns and your value is thus in a row and in a column and it will not display it any other way.

Access can only be used remotely on MS Sharepoint websites, but you could uses Access as a data store behind a hosted web application (though I would suggest the use of SQL server). Alternatively, you can use Access as the front end to a hosted SQL server database, so your user interface is local, but links to the remote database. Many web service providers offer MSSQL and/or MySQL databases ==================================== Transvestites - Roberts in Disguise! ====================================

You don't need to copy/paste. Just open the script in SSMS, then click Query>CMD Mode, then click run.

You're welcome :) Full-fledged Java/.NET lover, full-fledged PHP hater. Full-fledged Google/Microsoft lover, full-fledged Apple hater. Full-fledged Skype lover, full-fledged YM hater.

vanikanc wrote: I need to convert this value of datetime 2012-09-16T20:08:30Z to this format "mmddyy". Doesn't seem a valid datetime format to me As a string-function use: SELECT LEFT('2012-09-16T20:08:30Z', 10) ... With values in datetime-format: SELECT CONVERT(DATE,@datetime) ------------------------------ Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.

veon cheng wrote: I wanted to display the main category of the Juice which is beverage. No matter how hard i tried, i can't display the Main category in access. SELECT a.CategoryName FROM Category a INNER JOIN Category b On a.CatId = b.SubId WHERE b.SubCategory = 'Juice'; ------------------------------ Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.

Start from here: http://www.w3schools.com/sql/default.asp[^] http://www.microsoft.com/en-in/SQLserver/default.aspx[^] http://learnsqlserver.in/[^] Start to learn about: - Various query types - CREATE, UPDATE, DELETE, ALTER, SELECT, INSERT, GROUP BY , HAVING etc - Various query functions - COUNT, LENGTH, LTRIM, RTRIM, SUBSTRING, etc - Various query statements - Distinct, Union, Union all, Intersect, Order by, etc - Various query grouping and execution - Store procedures, Trigger, Cursor, Views, etc Try! Sandeep Mewara Microsoft ASP.NET MVP [My latest Article]: Server side Delimiters in ASP.NET[^]

r_mohd wrote: and data file and log file lying on pen drive. And you can go into SQL Server Management Studio and create a database using that drive? On your box? Notice that has nothing to do with your application. It is just a test to insure that SQL server accepts that.

John Robert Wilk wrote: My question is, is this even a remotely good idea. It merely proves that someone does not understand what a database-server is, and how it's being used. Whoever came with the proposal should not be doing any work outside of Microsoft Access. :) Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

To add to the rest of the advice; It's a bad idea to tinker with the seed-values. You should NOT be wasting time on having them start from a particular range (like 1). Why? Because the artificial key does not hold information, it is merely a link to another record. It's contents should not be relevant outside that purpose. Ever. Second, having an artificial key does not mean that you no longer need to find the "real" primary key, the combination of (non-identity) fields that make the record unique. Why? Because the user needs to be able to differentiate between the records, based on something else than an artificial identity that holds no information. Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

xp_startsmtp is a system procedure that starts a mail session for a specified email address by connecting to an SMTP server. This connection can time out. Therefore, it is recommended that you call xp_startsmtp just before executing xp_sendmail. If you specify smtp_auth_username and smtp_auth_password, and the server does not support the SMTP authentication capability, error code 104 is returned. Virus scanners can affect xp_startsmtp, causing it to return error code 100. For McAfee VirusScan version 8.0.0 and later, settings for preventing mass mailing of email worms also prevent xp_sendmail from executing properly. If your virus scanning software allows you to specify processes that can bypass the mass mailing protections, specify dbeng12.exe and dbsrv12.exe. For example, with McAfee VirusScan you can prevent mass mailing by adding these two processes to the list of Excluded Processes in the Properties area. Documentation[^]. Which error-code is it returning btw? Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

KUNWAR999 wrote: Can someone help me in this please.. ?? You already received help in the C# forum. Pete posted the best answer, as far as I can judge. Did you try his answer, what where the results, and why are you repeating the question? It'd be appreciated if you at least included a link to the prior question, otherwise I'll simply start copy/pasting the old answers to your question. Same question -> same answer. Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

without seeing the code directly, I can't say for sure if that is your problem, but why don't you just code it by hand. (not using the helper). The basic idea is: Open a connection to the database create a SQLcommand which takes parameters Load the parameters while loop(more data to load) execute SQL command load new values in paramters end while close and dispose of connection and command object The idea is that you have made one connection to the database, created one command and loop around the command just changing the parameters. Just a thought. :rose:

If only you knew how many times a day I think about it... :laugh: Full-fledged Java/.NET lover, full-fledged PHP hater. Full-fledged Google/Microsoft lover, full-fledged Apple hater. Full-fledged Skype lover, full-fledged YM hater.

Andrei Straut wrote: Oh, sorry for not making it clearer. my fault. glad we got it cleared up :D If it moves, compile it

Jörgen Andersson wrote: Anything wrong with google today? Same impression here, I'm starting to believe I'm the only person with Google access today :) Full-fledged Java/.NET lover, full-fledged PHP hater. Full-fledged Google/Microsoft lover, full-fledged Apple hater. Full-fledged Skype lover, full-fledged YM hater.

David Mujica wrote: Sometimes when you don't have the actual data to test with, you forget some stuff. Tell me about it. :rolleyes: That's almost something I can put in my CV. Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions

How about this: SELECT (DAYOFWEEK(NOW()) * 1E9) + @@LAST_INSERT_ID