I am going to use the sql code below in a query in delphy7 SELECT left(edit1.text, 5)+’0 ‘ FROM edit.text2
Answer Question | December 13, 2010 10:26 AM
SQL 2000, SQL Server 2000, SQL Server 2000 administration, SQL Server administration
how can i rertieve data in vb6.0 from sql?
Answer Question | December 13, 2010 4:58 AM
Retrieve Data Area, SQL, SQL Server, VB 6.0, Visual Basic 6.0
tablename:-software pname packagename cost MARY README 1200 ANAND PARACHUTES 6000 ANAND VIDEO TITLING 16000 JULIANA INVENTORY 3500 KAMALA PAYROLL PKG 20000 MARY FINANCIAL ACCT 85000 MARY CODE GENERATOR 20000 PATTRICK README 1200 QADIR BOMBS AWAY 3000 QADIR VACCINES 3100 RAMESH HOTEL MGMT 35000 RAMESH DEAD LEE 4500 REMITHA PC UTILITIES 5000 REMITHA TSR HELP PKG 6000 REVATHI [...]
Answer Question | December 11, 2010 8:39 PM
SQL 2005, SQL Server 2005, SQL Server tables, SQL tables
Is it possible to use a variable in the label-string of the LABEL ON sql statement so that the variable can be changed dynamically in an SQLRPGLE program ?
Answer Question | December 14, 2010 7:26 PM
AS/400 SQL, RPGLE, SQL, SQL Server
In a large logfile I have records containing the field INVNO (invoice-number). The lowest and highest values are easy to find, BUT it looks like some numbers in between are not there. Anyone got a trick with SQL, which can tell which numbers are missing within the numberrange (step 1) ?
Answer Question | December 14, 2010 2:35 PM
AS/400 SQL, SQL, SQL Server, V6R1
sir,plz tell me the procedure from strating that how to create stored procedure
Answer Question | December 11, 2010 11:19 AM
SQL 2005, SQL Server 2005, SQL Server stored procedures, SQL stored procedures
we have SQL 2008, and looking for tools to monitor sql and get sql diagrams. do you know any good tools?
Answer Question | December 16, 2010 10:51 PM
Network Monitoring Tools, Network security, SQL 2008, SQL Server 2008, SQL Server administration
Is crystal 8.5 compatible with SQL Server 2005?
Answer Question | December 10, 2010 4:45 PM
Crystal Reports 8.5, SQL, SQL Server, SQL Server 2005
Hi Sir, I wanna help from you . i have designed a report on reportserver . (sql 2008). its includes two variables which are userid and password. Because entering the user id and password , only the data who can view authorised section. User id and password should be keyed and it check with the [...]
Answer Question | December 9, 2010 6:28 AM
input parameters, SQL 2008, SQL Parameters, SQL Server 2008
I am running plsqldeveloper on a windows xp virtual machine. (Created on a windows 7 box). When I start plsql developer on the virtual xp machine I type in a vallid Username/Password there are no Databases in the drop down list so I type in a valid database name then I get the following error: [...]
Answer Question | December 7, 2010 5:54 PM
Oracle, Oracle Database, PL/SQL Developer, SQL Developer, Virtual PC, Windows XP, Windows XP Virtual Machines
I am looking for a website that is free and where I can learn to write better T-SQL views and stored procedures. Also, would like to find some good books to learn more about managing a SQL 2005 database.
Answer Question | December 31, 2010 5:18 PM
SQL 2005 Database, SQL Server 2005, T-SQL
I am have troble trying to get a select all fuction using AS/400 data on Mircosoft reporting services. Normally I know you just go into the parameter and click multivalued but that is not working. I have create a Stored procedure to use the calender feature for date I don’t know if there is a way I [...]
Answer Question | December 2, 2010 3:29 PM
AS/400, AS/400 reporting, SSRS
I have a schedule SQL2008 job to export the contents of a table to a text file each day. The job runs fine when I manually execute it, but if the schedule executes it, only 4 or 5 lines of text out of about 13000 are produced to the text file. Any ideas anyone? The [...]
Answer Question | December 3, 2010 3:28 PM
SQL 2008, SQL job scheduler, SQL Jobs, SQL Server 2008, Windows Server 2003
I have made a store procedure that runs fine but when I try to Call it into SSRS I am getting an error. The Error says SP_Convert_Date_MMDDYYY_to_CYYMMDD in *N type *N not found. Is there anyway of getting it to find my file in the AS 400 and what would I have to do?
Answer Question | December 2, 2010 7:14 PM
AS/400, SSRS, SSRS 2005, SSRS 2005 errors
Books Online tells me … make sure you have administrator permissions on the computer where SQL Server will be installed. Based on the principle of using the lowest possible user rights is it possible to safely install SQL Server 2005 using an account or group that has the required level of privileges but no more. [...]
Answer Question | December 2, 2010 5:07 PM
Local Administrators Account, SQL Server 2005, SQL Server administration, SQL Server installation, Windows Server 2003
Sir, i have 2 tables , first table column one is 1,2,3,4, and column two is x,y,w,z and second table first column of 1,2,3 second column is (1;2),(1;2;3;4),(2,4), i wand to display the result as in first colum 1,2,3 and second column as (x,y),(x,y,w,z),(w,z) please help me in this regard
Answer Question | February 9, 2011 12:42 PM
SQL, SQL Query, SQL Server, SQL Server 2008, SQL Server tables
how to attach database of sql 2008 into sql 2005
Answer Question | December 1, 2010 6:13 AM
SQL, SQL Database, SQL Server 2005, SQL Server 2008, SQL Server migration
I am trying to refresh an excel file that is on different server. is there any script that can be creatted with SSIS pacage that can do this. any help will be appriciated. Thank you in advance.
Answer Question | November 30, 2010 8:25 PM
excel, Excel Scripts, SSIS, SSIS Package
Can I use mapped drives and environment variables to run SQLPLUS from a local machine(without any Oracle products) to a server. The mapped server has the Oracle products? Example: W - map to my Oracle server C drive EV = w:oracleora92binsqlplusw cmd : start %EV% I’m trying to host out of Oracle Forms 6i to run a [...]
Answer Question | December 1, 2010 8:02 PM
Oracle, SQL Plus, SQL Server, SQLPlus
We need to allow a third party to connect to one of the SQL servers in our DMZ via an externally initiated SQL connection. What is the best approach and what are the risks?
Answer Question | November 29, 2010 11:59 AM
DMZ, Firewalls, SQL, SQL connectivity, SQL Server