How to create a query to convert a date datatype to string datatype? I use Ms access database.

I'm using Oracle9i and I have created some stored procedures in them.<br/>Can any of u tell me how to view the stored procedure?<br/>Thanks in advance..

Little background info...1 Web Server running Win 2003, IIS 6.0, .NET Framework 1.1 SDK1 SQL Server running Microsoft SQL Server 2000Here is the problem. I have a massive query that runs from the Web Server as a SQLCommand on a .NET VB page using the SQL Adapter. For the most part it will time out...

Hi,<br/> I am new for database query. I am using Ms Access to store data. In Ms Access the date is in format of MM-DD-YYYY. I want to retrive that date in DD-MM-YYYY format. Can any body tell me how to convert this date format.<br/> Thanks in advance.<br/>Mike

I am writing software that basically stores all information in an access file (*.mdb). I am re desiging the database schema, which means new design within the .mdb file.My questions are previously integrtiy constraints did not exist in the database in much of any degree. I am assuming Access can do...

Hi,<br/>Plz Help me !<br/> If I want to find the n-th record ( order by one or some fields ), where<br/>n is quite large ( such as 1,000,000 ).<br/> How should I compose the SQL to get better performance?<br/>Thanks !!

Hello!:)I have the following code:CRecordset rs1, rs2, rs3;CString strSQL1 = "SELECT * FROM [Orders]";CString strSQL2 = "SELECT *\n FROM [Orders]";CString strSQL3 = "SELECT *\nFROM [Orders]";rs1.Open(CRecordset::dynaset, strSQL1, CRecordset::none);rs2.Open(CRecordset::dynaset, strSQL2, CRecordset::n...

I AM TRYING TO DELETE RECORDS FROM THE SQL SERVER TABLE,I AM USING THE COMMAND BELOW TO DELETE THOSE 71 RECORDS BUT MY WHOLE TABLE 1198 records GOT DELETED AND HAD TO RECOVER FROM BACKUP..SO WHAT IS WRONG WITH THE SYNTAX GIVEN BELOWPlease give me the correct syntax please I am reffering to the tabl...

Hi All,<br/> <br/>I am planning to develop a SQL Query analyser. I am using SQL Server 2000. Now the problem is that HOW I CAN CHECK WHETHER THE QUERY (SYNTEX) IS RIGHT OR NOT.<br/> <br/>Hope a positive response...<br/> <br/> <br/> <br/>.

Hi,I have successfully installed the MySQL client program in my machine, When I try to install the mysql connector [mysql-connector-odbc-3.51.15r409], I get the error,configure: error: Could not use the single thread MySQL client library, please check config.log for errorsduring the ./configure.How...

Hi all,I have a question for you.This is the view i'm working on right now.SELECT Group.Cod_Name,count(*)FROM view_Group Group INNER JOIN view_Last_Date LD ON Group.Emp_No = LD.Emp_Code AND Group.Cod_Code = LD.Cod_CodeWHERE (Group.Cod_Code = 'SEC0001')GROUP BY Group....

I've deployed an upgraded Microsoft Access 2003 application onto my clients computers and one of the users is unable to run it due to the following information message:"license information for this component not found. You do not have an appropriate license to use this functionality in the des...

HiI have encountered a problem and it's assumed that there is a race condition happened.Someone proposed, while my method is running, someone else executed some query and altered the table my stored procedure is supposed to modifiy and causes some trouble.My questions: Is it even possible that...

My company is looking at using a DAL. This will consist of creating business objects, setting of data objects and converting all the data to xml and on the server side turn around and put it back to the type it was. It is using a CRUD approach. These are my concerns1) converting from text then ba...

I have a VB6 App using Access 2000 Database. Frequently, it will lockup on some of the users machines forcing the server to be rebooted.The server is actually just one of the PC's which shares its Access Database with 3 other users.When one PC locks up, it causes the others to stop functioning...

I am using this query to find out the table structure and it works absolutely wellSELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS Where TABLE_NAME = 'tbl_myTable'The only problem with this query is, it is unable to figure out whether a certain field...

Hello: If a table X contains several columns, and might contain many (millions) rows, all rows can be splited into 5 groups by value of one column.then, below two design1. All rows in one table, and use a column to differentiate the groups2. Split rows into 5 tables, without differentiate columnWhi...

hi all,we r using sql server 2005, and we are facing many issues with the lookup performance..wherever we r using more than one lookup the performance drastically decreases and even if it caches all the rows, it does not proceeds..it takes almost half hour for a single lookup for approx 7-10 million...

Update [image] set Active = 1 where exists( select * from dwellingimage as d right join [image] as i oni.id = d.imageidwhere imageid is null)My Select statement above selects the correct number of records, but when I add the Update command it goes and update's the whole table. Can someone tell...

hi all. i would like to know how i can convert text to field. <br/>for example: <br/>BEGIN<br/> declare test varchar(10);<br/> set test="id,name"; <br/> SELECT test from m_question; <br/>END<br/>many thank for your help.

Hello, I'm attempting to teach myself SQL from the book "Essence of Databases" by F.D. Rolland. I've stumbled across an exercise which has me tearing my hair out a little.Given a table STAFFwith fields StaffID, Sname, Job, Sal, BranchIDAttempting to identify all staff whose Salary (SAL) i...

Hi everyone, I'm trying to execute a SQL command in VC++.CString sSentence;sSentence = "SELECT * FROM Client WHERE Name LIKE 'j*'";rs.Open (CRecordset::forwardOnly, sSentence.c_str ()); So it must return the names in the Client table starting with 'j', but this function does...

Can someone help shed some light on why this sproc isn't working:CREATE PROCEDURE [dbo].[SaveUser] @ID int, @UserName varchar(50), @Password varchar(50), @EmailAddress varchar(50)ASBEGIN IF EXISTS (SELECT * FROM [user] WHERE [id] = @ID) BEGIN UPDATE [user] SET [username] = @UserName, [passw...

Hi All, Is there any way to make the "Primary Key" generate itself? I think in anAcess database there is an option so that whenever you enter a new line it automatically generates a Unique Primary Key. I don't see how to do this in a SQL Server Database? Perhaps I just missed it. This is new to...

The following code produces 0 results, however, if I replace '%' with '%%' I get the entire table returned. Any ideas?<br/>declare @blah char(2)<br/>set @blah = '%'<br/>SELECT * FROM dwJobs WHERE cono LIKE @blah

Hi Guys,New here, i am just wondering what the easiest way would be.I need to copy over a complete access 2003 database as we will be using it for another campaign. The VBA code and forms need to remain intact (with minor changes at a later date), the tables need to remain but the records need to be...

hi all !!<br/>I want database for forums, so that I can practice on forum management.<br/>Please provide database which contains data.<br/>Thanks,<br/>technoroj

SQL Service Broker in Microsoft's SQ 2005 product looks interesting. We have been using replication to keep remote client's databases in sync with ours. Would SQL Service Broker be a better way to accomplish this?

I have a project made with VB6 using RDO connection to connect to SQL 2000 to a database with collation sequence SQL_Latin1_General_CP1_CI_AS, same collation is used for the columns, This database contains Arabic Data in VARCHAR fieldsI wrote a small program with VB.Net 2005 that connect to the same...

Hi All,I currently have the following SQL Statement:select c.Id, c.name, c.active, a.name as attribute from component as c join attribute as a on c.attributeid = a.id order by c.name ascthis gives me data in the form:183 Communal Enclosure 1 Cleaning150 Composite 1 Door...

Hello,I wanted to ask if anyone knows of a way to prevent injection in an SQL SERVER 2005. I mean, is there any way to do all the blocking in the server and not have to escape each special character one-by-one?For example, in PHP I used mysql_escape_string and automatically the string was OK to send...

Hi,i have a strange scenario that means i have to createa duplicate record and then update both when a certain criteria is met.The database is for the company i work for, and we create coils of wire.We have Data Capture Database that tells us the Start Time and End Time of a Coil.We also have A shif...

My company is considering changing from using webservices to retrieve data from a sql database to a data access layer utilizing business objects. Has anyone actually use both and can comment on performance differences. Also is a dal the definite way to go, not taking into consideration the time to...

Hi All, I am a newbie. I am using SQL SERVER EXPRESS ( Free Version ) and theFree version of VB.net 2005. I have created a Database inside the VB.netIDE and can use it with the program fine. How do I view this same databasewith another program ? I found the Database viewer and I can't seem to g...

Hey folks. I am having a terrible time trying to learn some pretty old software (not much info about them around anymore). I am a network Admin (0 db experience) who has been shouldered with DB issues... I have a progress database (v9.1) that I need a bit of help with. My issue is that I am not...

i am using sql server 2005 <br/>my table consist information date wise...<br/>now i want to delete top 20 or 30 rows of each date<br/>thanks in advance...

Hi, is there a "SQL Profiler" which comes with SQL 2005 Express Edition ( http://msdn2.microsoft.com/en-us/express/bb410792.aspx) <br/>If not, can I download one separately?<br/>Thanks

I have Vista Business (64bit) and I tried to install MS SQL SERVER 2005. My computer`s name is HFAST. During installation I have choosen 'Windows Authentication" and LocalSystem login. I`m running Administrator account. Here is my problem: I have installed 2 database engines (one default and on...

How do I connect from php to mysql through a Unix socket not going into TCP/IP as they both on same server?

Hello to all gurus, <br/> I am making a software for payroll system in my company. But the time limit is very less. So I am in a hurry. Can anyone please send me links of the table structures of Payroll system<br/>Thank You

hii all,Im doing a research about search engines.if any body knows how it works pls reply this thread.I found some details but don't know whether correct.Also i would like to know is there any difference between the mechanism of search engines? ***first it searches the all web pages based on t...

I have a table like thisCREATE TABLE tbl_CustMaster(CustID BIGINT IDENTITY(1,1)CustName VARCHAR(100),JoinDate DateTime,EndDate DateTime)Now I want to run a query in which I want to extract custID which lies between JoinDate and EndDate. Can someone help me in doing this??...

how can i insert a database in my website that where i can add edit delete?

HiI am trying to display either source1 or source2 thumbnail image but unable to find a solution. Hopefully someone will be able to help.Here is the code I am trying to figure out.$db=mysql_connect ($DB_HOST ,$DB_USER,$DB_PASSWORD) or die ('I cannot connect to the database because: ' . mys...

Hello everyone.I was confused on what makes a many-to-one relationship. For instance I modeled this .ddl db2 code in Rational Software Architect and its showing its a many to 1 relationship based on the code I'm going to paste.The reason Im' asking this is because I'm writing a progra...

I am trying to write a procedure which returns a simple boolean, 1 if an item exists in our database with the same combination of values as what the user defines from the UI.The tables are structured such as:itemNo, Property, ValueSo you can have a table that looks like this:001, a, 1001, b, 2001, c...

Hi,<br/>I want to extract oracle version information installed on my host programmatically ( using c++).<br/>Kindly give me the idea, how can get the Oracle version information on windows.<br/>Regards,<br/>Jokhan

I have a SQL task that fetches some data from sql server 2005 which is then fed to a foreach loop to iterate through the recordset and call a webmethod for each record. The method parameters are extracted from fields in the recordset and one of the parameter types happen to be a simple enumeration...

I am using this procedure to extract records from a tableALTER PROC [dbo].[dbWBS_usp_DisplayCertificatesDetails]( @PageNum BIGINT=1, @PageSize BIGINT=10, @OrderBy VARCHAR(50)='Certificate_Id', @TotalRowsNum BIGINT=0 OUTPUT ) AS BEGIN -- SET NOCOUNT ON added to prevent extra...

Hello,I'm new with ESE API.I have this attached sample program that I downloaded from somewhere.It seems quite complicated to do even simple things like searching with more than one condition (i.e select * from TABLE where COL1='bla' and COL2 like '123%').Can you direct me t...