hi<br/>can any 1 say the main difference between sql 2000 and 2005.<br/>is there any difference in using the join(left outer join,right outer join) ?

I am trying to obtain the filter from an RDL file that has been created by Report Builder so that I can build a SQL query from the command text value in the RDL file.I am able to read in everything in the SemanticQuery node into a new XPathNavigator object and then apply XSL to this fragment to prod...

Hi<br/>I'm using ms access with ole db. I have a date field in one of my tables and the format its like 25052007. I only wanna retrieve the month '05', which is may. how do i remove the first 2 and last 4 numbers and select it out?<br/>thanks.

I am currently working on developing a website which is based on a mysql database. Normally I develop my databases in Access, but my boss wants the database to be available online so that his employees can just login to the website and view/edit the information in the db.I currently use phpmyadmin t...

Hi guys,I have a stored procedure which has a datetime parameter. But when I call it like this:exec spSomething dateadd(minute, 30, getutcdate())It complains as "Incorrect syntax near 'minute'.But when I call it like this:declare @time datetimeset @time = dateadd(minute, 30, getutcdate())e...

Hi allI'm in the need to insert text data into a BLOB field within a SQL Server 2005 database but I'm stuck on how to do it.The data to insert is text-only, but the problem with simply inserting the text is that it contains chars that make the SQL string wrong (' etc). What I want to...

Using: SQL Server 2000, ASP.NET, .NET Framework version 2.0I have an application that will be used to both submit and service "requests". Within the submission process, I've used a column 'concurrency' in table 'requests' that aids in preventing lost updates, etc (before upd...

We have a job in SQL Server that runs every night to update enrollment statistics. On days where we have a lot of enrollments or changes some people would like to see updated statistics. Instead of calling me and asking me to log into Enterprise Manager and run the job, I'd like them to open...

SQL Server 2000, ASP.NET (Framework version 2.0)I have a stored procedure that does a query to check a particular condition, and then executes a second query based on that result. I want to bind the results of this to an ASP.NET GridView control, but it's taking up the rowset from the first tes...

I have a table named movie, in which there are columsMovie_ID[CHAR]Movie_Name[CHAR]Release_Date[date/time]In this particular case there might be multiple entries of Movie_name in this table. I have to display Movie_name along with its number of entries. What query will I write??...

Hello,I have a column that is a currently set as nvarchar(50) and is called DateEmployed.There are over a hundred rows that contain dates which is in nvarchar format. This column now needs to be changed to a DateTime datatype. (Don't ask me it was not setto a dateTime when this was first design...

hi,everyone<br/>How can I Create a temporary table:have a row (the row's evaluation have a value automatically .for example 。the first one is 1,the second is 2,the third is 3,and so on ),How can I do,please help

Hi, i am a new bee in MySql.This is how i do testing for my stored procedured.declare @A VARCHAR(45);@A='MIS';selectd.DeptDescfrom dept dwhere d.DeptDesc in(@A)The result i get from this query is nothing.There is really a deptDesc=MIS in the table.I try with SQL Server 2005and no problem.C...

I want to execute unix commands from a pl/sql script and retrieve the results into a varible for calcultion. Specifically i want to issue the appropriate unix command to get the amount of available disk space on my unix box, then return this value to my program and do calcualtion/comparison to see...

Hi,<br/>I want to take script of a table with data in sql server 2000.<br/>Can Any one help me?<br/>Thanks In Advance

Hi All,I am writing a C++ application using VC98.It uses MS JET 4.0 (MS ACCESS 2000) OLE DB provider.When opening the 65-th database IDBInitialize::Initialize call fails with return value E_FAIL that means "a provider specific error".I tend to think it is a limitation on the number of simultaneously...

Both examples use ADODB in VB6.Example 1 takes about 4 seconds to populate a grid with 5000 lines.Example 2 takes less than 1 second to populate the same grid with the same data from the same file.WHY ?Have I lost something by using the FAST Method ?Thanks for any commentsEXAMPLE 1 - SLOW Dim st...

I have a search requirement from the client(Asp.net website), which is like i will search among thousends of employees. i will get the results,then i will search within the resultset again.How to do this in the best way.The simplest solution can be to search the whole database again just by adding c...

I am working in ms access database. and vb 6.0 is front end.I have three tables namely:AREA:= AreaId,AreaNameROUTE:=RouteId,RouteNo,RouteName,AreaIDsPARTY:=PartyId,LastName,FirstName,Address,AreaIDThe table ROUTE contains the field AreaIDs which is chain of areaids belonging to that particular route...

hi want to find the out puts There are 2 fields namely name,mark The following are the values in the field name...mark A.........10 A.........10 B.........20 C.........15 C.........5my output should be in...

Hi Friends I have a problemsI have a table Employeetwo fields Name, Age Name Datatype is varchar()Age Datatype is Int() the table look likes thisName.......Age Ram..........23Steve.........22when i swap this two fields using this query"update Employee set Age = Ename,Ename=Age;' then th...

Hi,I'm trying to use VBA to extract a string value from a table in a database.My effort is below:Private Sub Command0_Click() Dim SQLString As String Dim db As Database Dim MachineName As String Dim Category As String Dim FileName As String Stop Set db = CurrentDb...

I made this query several months ago for an internal program. It has worked fine until today. The query returns a list of students that match certain criteria. Today it started skipping a student (the same everytime). There isn't anything unusual about the student the student does meet the...

Hi Friends,I have one query using "IN" clause for example,select empcode from Employee where EmpCode in ('1006','1001','1005')In this I am getting results in the order of EmpCode 1001,1005,1006 that is order in the database...but i want the result in the order of the va...

Hi and goodday!is there any IF THEN onstruction in SQL? I mean in the overall standart SQL , not t-sql and stuff like that. I'm asking because I have a table, say named NUMBERS and it contains a column named COLUMNA (containing unsigned integers). all I have to do, is to change the numbers 1 to...

Need some help deciding the best way to proceed with a project?Im using SQL 2005 I have a table that is basically an audit trail. From this table I will select records based on a field called "code" in the table. Basically it tracks patients and their locations throughout the facility.I collect Ac...

Hi,in my machine (running on Windows XP pro) i have Toad 3.0 for IBM DB2 installed... IBM DB2 is running on HP/Unix box...i'm able to connect to DB2 database using the Toad application...i'm trying to create a ODBC connection to DB2 so that i can use this in the application...While creatin...

am using vc++2005, ADO, and MSAccess 2003. MS "documentation" straight out of the VC++2005 help facility atms-help://MS.VSCC.v80/MS.MSDN.v80/MS.VisualStudio.v80.en/dv_vdt01/html/419ef633-5a89-41a2-aefe-03540afc9112.htmprovided the following code samples for different types of joinsinner joinSELECT...

Hi all...so far 20 views and no help...oh no!I have an SQL statement that works on SQL Server 2005. I need to tweak it for Oracle 8. SELECT sequenceNum, PartID, row_number() over (partition BY PartID ORDER BY sequenceNum) as LNum FROM FTPL;I keep getting the error:From Keyword not found where expe...

Hi,sorry for the crosspost,but i think that this section is better for my question.I am writing an application with MS VC++ 6,in which i use ADO (the older one,not ADO.NET) with an Access database.Now i would like to use MySQL5 instead,maintaining the ADO.I think the only change would be in the conn...

berkeleyDb provide four access method to database : b+tree hash recno quque . the first and the second one is quite easy to comprehen ,but the thirth and fourth one is not that easy as sleepcat doesn't offer sufficient information for that . Does recno just has the extra feature of supporting l...

hi all, [EDIT] I am using sql server 2005 i am having trouble executing the sp_databases stored procedure from my app... i am creating an sqlcommand and assigning the relevant value to their properties... one thing i have noticed is that if i use integrated security=true in the connectionstring it...

I need to use a cursor (I think) to get the next 'EventDateTime' and include it as a field called timeout. I can do this using Crystal Reports but that adds an additional step. Here is the code I use to create the procedure. Can someone point me in the right direction?When pulling the n...

I'm working in Access trying to set a variable based on a value on a table. For some reason my code is giving a runtime error. Can anyone help? Dim SQLString As String Dim db As Database Dim Query As QueryDef Dim MachineName As String Dim Category As String Dim FileName As S...

I just installed C# Express on my Vista machine, and it included SQL 2005 Express. I installed that as well and downloaded the SQL SP2, and all the other SQL updates available. No matter what I do I can't access SQL Server. Every time I try to create a database or do anything inside Management...

Hi,I'm creating an application that has SQL database linked to it. This is my first app that uses SQL. So a bit confused about the table structure. It goes like this.No. | Name | Phase | Start Date | End Date | Hrs | CompletedBut one No.has 7 phases. So how do I go about creating the table? Ple...

I am trying to create an access formula in which the query will evaluate the the values in two fields and then display the results in a third field (All of the fields are in the same table).The overall effect that I am trying to get is: I have many tables with the same fields as above, and I would...

I'm trying to use the SHAPE command create a hierarchical recordset for a report in VB6. I'm using the Data Report Designer in VB and an Access database. This is a report of all client activity for a specified date range. I have a parent Client table with two child tables, FoodService and...

Is there a way to send a printer (zebra printer) some custom code (from a text file) using SQL server or even better, a stored procedure inside SQL server?<br/>Possibly some DOS or Shell command line?<br/>Thanks,<br/>Brandon

Hello :)<br/>Can anyone give me some link(s) where I can download these packages? I Couldn't find them in Internet.<br/>Thanks In Advance.

Could MySQL in wondows system database check and repair (myisamchk) executed in background or after fixed interval to avoid databsae's breakdown, thanks !

the given error message is :<br/>XML "<Info><Account>Monkey</Account><Name>" emerges xml analysis error <br/>and the xml is :<br/><Info><Account>Monkey</Account><Name>功</Name></Info>

Hi Gurus,I am facing some problem in Remote Connection of MySQL Server. I have 2 windows machines (XP) out of those one is Server and another is Client. When I am trying to connect (using telnet PCDP-Serv 3306) to the Server from Client I am getting Error "Could not open connection to the host, on...

I am new to the whole sql/oracle stuff. I am trying to write a query that returns me every row that matches.What I have is three tables:POCINFO is the names, CIRCINFO is the places and CIRCINFOPOC is what joins the names and places.The query is:select poc.POCID, poc.name, poc.phone, cipoc.CIRCINFOPO...

hi alli have a problem with this query to retrive the value of one column into two for examplei have this queryselect CustomerName , Amount, Voucher_Type from customers;resultCustomerName Amount Voucher_TypeA 200...

Hi ,Plz help me. my SQL select is SQL = select * from Employee where (design= 'SE' and dt = 20070702) or (design= 'SE' and = 20070629) If select * from Employee where (design= 'SE' and dt = 20070702) = A gives rows >0 then below condition should be ignoredselect * fr...

What query should I write to delete duplicate records from a table??

I have a database containing a table "Case", and a table "Session". I want to calculate the average number of sessions per case, but I don't know how to do this.The following code does not work:SELECT AVG(COUNT(Session.SessionID))FROM Case INNER JOIN Session ON Session.CaseID = Case.CaseIDGROUP...

Hi,<br/>I want to know,How t create(or genrate) sdf files??<br/>Pls reply me asap.<br/>Thanks!!

Im using this activeX vbscript to either update or insert depending on if the record already exists in the destination table, it inserts OK, but never updates. Can somebody please help me to see where Im going wrong...many thanks'****************************************************************...