Database

FirstPrevNext

Re: Retrieving UNICODE data Divya Rathi24-Feb-06 9:36 Divya Rathi 24-Feb-06 9:36  when some unicode characters (like sanskrit , chinese) are entered into DB , they are encoded in sense that a character in sanskrti is converted to say "&55;" & then it is stored in db . Divya Rathi download multiple files from database oga_ns23-Feb-06 0:53 oga_ns 23-Feb-06 0:53  Does enyone know how to get all byte[] from records in database. When user click on the button to give him all records in some arhive?? Some code???(C#) Thanx Oga -- modified at 6:53 Thursday 23rd February, 2006 Re: download multiple files from database Colin Angus Mackay23-Feb-06 12:29 Colin Angus Mackay 23-Feb-06 12:29  Perhaps if you explain more clearly what you are looking for we could help. oga_ns wrote: Does enyone know how to get all byte[] from records in database. What do you mean by this? Are you talking about an image or varbinary column? ColinMackay.net Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more? Re: download multiple files from database oga_ns23-Feb-06 22:33 oga_ns 23-Feb-06 22:33  In datatable I have field with type: "binary data", and I put into it some jpeg, doc, xls, .... files. Then I have a web form with download button, when user click it i wont to give him all files from that datatable. I hope this explanation is better oga How to sort Numeric Data? padma_0122-Feb-06 18:56 padma_01 22-Feb-06 18:56  I need to sort numeric data in an access database table. The following command is used in my current program which sorts string values (Names of employees) but i do not know what command can I use to sort numeric data. Please help me. I am using this currently: SELECT * INTO TargTable FROM SourceTable ORDER BY EmpName Regards, padma gahlot Re: How to sort Numeric Data? Mike Ellison22-Feb-06 19:10 Mike Ellison 22-Feb-06 19:10  Hi there. Just use ORDER BY with your numeric field - SELECT * INTO TargTable FROM SourceTable ORDER BY MyNumericField How Does SQL work? (easy question, i assume) ThePmanLives22-Feb-06 18:23 ThePmanLives 22-Feb-06 18:23  All i want to know is, is SQL a interface like Access or is it just a server manager for databases... i downloaded SQl express and MySQL and nither had any GUI i could find unless i did something wrong. i just want a program to make databases as easily as access with more functionalty, as access can only hold 500-1000 records per file, efficently... "Love, Life and Option Explicit" Re: How Does SQL work? (easy question, i assume) Paul Conrad22-Feb-06 18:34 Paul Conrad 22-Feb-06 18:34  SQL Express and MySQL are database servers. You have to use tools like SQL Server Management Studio Express to have any kind of gui similar to Access. MySQL has tools like MySQL Tools which help build databases, queries, etc. If you are looking for something like Access Forms, then you have to program a front-end in VB or C#. ThePmanLives wrote: access can only hold 500-1000 records per file Are you sure? Because I have a client who has 130,000+ records per table and about 50+ tables and he insists on Access. Re: How Does SQL work? (easy question, i assume) ThePmanLives22-Feb-06 18:44 ThePmanLives 22-Feb-06 18:44  I guessed as much, by the interface, just wanted to be sure i wasnt being stupid or anything. I'll look into SQL Server Management Studio Express, if not i will just use access. i have no problem with that. i use VB .net 2003. It should work fine with that. the 500-1000 figure was given to me by a friend of mine. he may have ben referring to '97 office. I inteend to use 2000. "Love, Life and Option Explicit" Re: How Does SQL work? (easy question, i assume) Paul Conrad22-Feb-06 18:48 Paul Conrad 22-Feb-06 18:48  My client uses Access 2000/2003 so that could be the reason. I don't know about older versions of Access. Good luck with SQL Server Management Studio. Paul Re: How Does SQL work? (easy question, i assume) Mike Ellison22-Feb-06 19:18 Mike Ellison 22-Feb-06 19:18  SQL is a standardized declarative language for interacting with relational database systems. It literally stands for "Structured Query Language" and was originally developed by IBM in the 70's. As of 1987, it was standardized by ANSI and ISO, and has gone through a number of revisions since. Typically a RDBMs will have a command-line interface of some sort (if not a full blown GUI) that accepts SQL commands. You can download one for Sql Express from Microsoft here[^]. I've heard MySQL's command-line interpreter is much better than its graphical tools, but I don't know that from my own experience. Re: How Does SQL work? (easy question, i assume) japel22-Feb-06 22:28 japel 22-Feb-06 22:28  If you like the GUI of Access but want the power of SQL use both. You can link Access to SQL tables and have the best of both worlds... http://www.sqlservercentral.com/columnists/kKellenberger/accesstosqlserverlinkingtables.asp[^] You will need a GUI to create the original SQL table, search the web there are others apart from the standard offering or you can generate tables in code. Have fun... When people make you see red, be thankful your not colour blind. Re: How Does SQL work? (easy question, i assume) Boris van de Laarschot25-Feb-06 6:19 Boris van de Laarschot 25-Feb-06 6:19  Access is an aplication. SQL server (express) is an OLE database server. That means it is made to handle calls from other programs. OLE = Object Linking and Embedding. A Microsoft technology which allows you to link elements from different applications within each other. How do I execute a sql script? Mundo Cani22-Feb-06 13:50 Mundo Cani 22-Feb-06 13:50  Hello, I'm new to database programming. I'm currently reading Pro ADO.NET 2.0 from Apress. The book has been great so far, but when he get's to his first example, he supplies a script file to set up a simple data source. So, i have this .sql file that i don't know what to do with. when I double click it, it just opens in notepad. Yes, i'm a doofus. please help me! I'm running a local instance of sql server 2005 standard. thanks! Ian Re: How do I execute a sql script? Mike Ellison22-Feb-06 19:12 Mike Ellison 22-Feb-06 19:12  Hi Ian. If you're running Sql Server 2005, you should have access to the Query Analyzer program, yes? Open the .sql file in Query Analyzer, then execute it (F5 will do it) Re: How do I execute a sql script? Mundo Cani23-Feb-06 8:34 Mundo Cani 23-Feb-06 8:34  i can't find the query analyzer. I'm going to reinstall and give that a shot. Thanks! Ian Re: How do I execute a sql script? Colin Angus Mackay23-Feb-06 12:22 Colin Angus Mackay 23-Feb-06 12:22  SQL Server 2005 does not come with Query Analyser. That was a feature of SQL Server 2000. ColinMackay.net Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more? Re: How do I execute a sql script? Mike Ellison23-Feb-06 13:49 Mike Ellison 23-Feb-06 13:49  My mistake. Thanks Colin. Re: How do I execute a sql script? Colin Angus Mackay23-Feb-06 12:26 Colin Angus Mackay 23-Feb-06 12:26  Open Microsoft SQL Server Management Studio Connect to the SQL Server In the tree on the left open the databases folder Right click on the database you want to query and select New Query... In the main pane you can now type SQL. You can execute the SQL by pressing F5 or using the Execute button. Does this help? ColinMackay.net Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more? Install SQL 2K default instance over MSDE 2k default instance nnurani22-Feb-06 4:38 nnurani 22-Feb-06 4:38  The system already has a default instance of MSDE2000 installed. I would liket to upgrade this to a default instance of SQL server 2000. Is this possible without uninstalling the MSDE? The SQL installation asks me for an instance name and disables the default instance (since it already exists in MSDE)?? Trigger Adarsh Shah22-Feb-06 3:43 Adarsh Shah 22-Feb-06 3:43  Hi, Can I get previous and current values of row in trigger for update operation. Regards, Shah A. Re: Trigger Alomgir Miah22-Feb-06 7:31 Alomgir Miah 22-Feb-06 7:31  Use updated.colname Live Life King Size Alomgir Miah Re: Trigger Adarsh Shah22-Feb-06 17:43 Adarsh Shah 22-Feb-06 17:43  Thanks for the reply Alomgir. Can you pls elaborate? I think updated.colname will give the value after the execution of query. How can I get the previous value, so that I can compare both. Regards, Shah Adarsh. Re: Trigger Adarsh Shah22-Feb-06 21:58 Adarsh Shah 22-Feb-06 21:58  I got the answer . deleted table contains the old record and the inserted table contains the newer one for update operation trigger. Regards, Shah Adarsh. Need help on creating ENDPOINT to define a Web Service in SQL Server 2005 Slow Learner22-Feb-06 2:54 Slow Learner 22-Feb-06 2:54  Hi there, I am just trying to create an ENDPOINT to define a Web Service in Sql server 2005. Here is my code Create ENDPOINT AWService STATE = STARTED As HTTP ( PATH = '/ADVENTUREWORKS', AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR), SITE = 'DEVI\SQLDM2005' ) FOR SOAP ( WEBMETHOD 'GetProductList' (NAME = 'AdventureWorks.Dbo.GetProductList'), DATABASE = 'AdventureWorks', WSDL = DEFAULT ) and when i run this T-SQL its complaining about Msg 7807, Level 16, State 1, Line 1 An error ('0x80070057') occurred while attempting to register the endpoint 'AWService'. I am trying this code to run on Windows XP pro and Sql Server 2005. Any clue why its complaining about this ? Thanks -D

Last Visit: 31-Dec-99 18:00     Last Update: 4-May-24 16:47 Refresh ᐊ Prev1...1955195619571958195919601961196219631964 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.