7,494 Archived Topics
Remove Filter  | |
 | Good Day all I have an SP that is defined like this [CODE]ALTER PROCEDURE [dbo].[sp_Constraints_Update] @xml ntext, @TTBLType varchar(5) AS set nocount on DECLARE @xmldoc int DECLARE @sql varchar(8000) -- In one long sql string do all of the following --Create an internal representation of the XML document. EXEC sp_xml_preparedocument … |
| | Hi all, I am a student trying to access a database that is on a different server than where my web pages are stored. My webpages running PHP scripts are here (128.118.142.34 through 128.118.142.46) and my database is here (146.186.83.60) Here is the code that I implemented: [code]$con = mysql_connect(146.186.83.60, … Databases mysql php web-server |
| | I use the following code to make a rule and use it for my PHONE column: [code]CREATE RULE phone_rule AS @phone LIKE '([0-9][0-9][0-9]) [0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]'[/code] The problem is : When I run this code nothing add to my "Data Type" drop down box to set my PHONE column data type to … Databases mssql  |
| | I have to create a report based on the customer for particular order. For example find all the customers who ordered an item ‘ABC’ for current month and look back 11 months to find out if the same customers ordered the same item and list all the customers who ordered … Databases oracle |
| | Hello, please bear with me if this question is stupid. I'm fairly new to this and i really need to know. is it possible to use [B]"SELECT COUNT"[/B] to get the number of DIFFERENT values one column currently holds grouped by a value from another column.? Databases mysql |
| | Good Day all I have a Sp that is written like this set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[Import_RegistrationsXM] @xml ntext AS set nocount on DECLARE @doc int EXEC sp_xml_preparedocument @doc OUTPUT, @xml TRUNCATE TABLE _RegistrationXM INSERT INTO _RegistrationXM SELECT * FROM OPENXML ( @doc , 'Import/Item' … |
| | hi, i have my php pages done already and it's running good in my localhost but when i have uploaded it, search engine would not work. i have changed the appropriate database names and tables provided by the web host , but it just doesnt work still. I know that … Databases mysql |
 | Dear all, Sorry, if this Thread is wrong room :$ . I want to return a field value from a table, so I created a function like this : [CODE]CREATE FUNCTION dbo.CheckStatusTrx(@TransNo Varchar(20)) RETURNS varchar(20) AS BEGIN DECLARE @Flag Numeric(1) SELECT @Flag = Flag, CreatedBy, ApprovedBy FROM TrxTD WHERE TransNo … Databases mssql |
| | Hi, Please excuse my general lack of knowledge in regards to I.T related issues. I am doing work for a Property Company setting up a rather complex (roughly 50 relational tables) internal database created which holds information about the properties that we currently own and prints out reports e.t.c. I … |
| | ok so i created a database and made a table that i inserted data into it. i would like to know how would i be able to put the extension .sql at the end of my table? |
 | I'm playing around with SQLite, which is very similar to what i've seen in MySQL, and I want to write some code that returns the column names along with the data for output purposes. Is there an SQL query I could use to do that, or is it done differently … |
| | ER Model: [url]http://img22.imageshack.us/img22/7292/modeloer.jpg[/url] I´ve got this: [IMG]http://img31.imageshack.us/img31/2384/antesj.jpg[/IMG] And want this: [IMG]http://img12.imageshack.us/img12/5241/depoispkd.jpg[/IMG] (Paint image.. lol) Anyone knows how to build a stored procedure who does that or a view? Thanks! Databases mssql |
| | Hi, Im learning SQL and I've hit a bit of a wall early on.... I have these 2 statements [CODE]SELECT AcNum, FamName, GiveName, DeptNum, count(AcNum) FROM academic NATURAL JOIN interest GROUP BY AcNum HAVING count(AcNum) < 4[/CODE] [CODE]SELECT GiveName, FamName, DeptNum, AcNum FROM academic NATURAL JOIN department WHERE LOWER(state)= 'ny';[/CODE] … Databases mssql |
| | Hi! I would like to do something like this: [url]http://www.adp-gmbh.ch/ora/explainplan.html[/url] with an .mdb file. Thanks! Databases microsoft-access |
| | Hi Guys, Kind of stuck on a query here. [CODE] select *--, c.last_name + ', ' + c.first_name as name from dbo.tblLevelOneApprover a inner join dbo.tblLevelTwoApproverToLevelOneApprover b on convert(int, b.level_two_emplid) != convert(int, @emplid) where convert(int, a.emplid) = convert(int, b.level_one_emplid) [/CODE] I'm trying to get all level one managers who are … Databases mssql |
| | I have a query which has a prompt when you insert the year a graph on a report displays.My problem is that when I enter the date the same prompt appears two times after I inserted the year. Also when I what to print the graph it also prompts me … Databases microsoft-access |
 | I'm working with Access 2000. I have a form with data from a table, tblParts, and a list box with data from another table, tblRDM_Numbers. The two tables have a one-many relationship with tblParts.name as a foreign key for tblRDM_Numbers. I would like the list box to update every time … Databases microsoft-access |
 | I have a drupal user table: [CODE]+------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+----------------+ | uid | int(10) unsigned | NO | PRI | NULL | auto_increment | | name | varchar(60) | NO | UNI | | | | pass | varchar(32) … Databases mysql  |
| | Hi, I am using this query for count [ICODE]SELECT Count(ID) from Table[/ICODE] But its showing the count of all the fields which are empty and zeros. I want the count of fields which are empty and zero. please guide me. Thanks. Take care. Databases mysql  |
| | Is there a setting to suppress warnings from dispalying when running a script via SQL Query Analyzer? I would like to have only errors print. Thanks! Databases mssql  |
| | Hello, I need to write a query for MySQL in vbscript that is just not coming to me. I have written it in vbscript with two SQL statements then did a date comparison in vbscript but it just grinds the server to a halt. What I need to do is … Databases client-server mysql vbscript |
| | Hello, I have two tables aspnet_Membership and aspnet_Users. I want to remove all of the records from [B]both[/B] tables that are older than 30 days by using a single stored procedure. So far I have this: [ICODE] BEGIN BEGIN TRY BEGIN TRANSACTION DELETE FROM aspnet_Membership WHERE CreateDate < DATEADD(DAY, -30, … Databases mssql |
| | I have a aspx page written in Vb and one of my button_click events has a function to connect to a sql database and retieve the data of a specific record by using the sql statement "SELECT * FROM Calendar WHERE Day="27" " The Name of my Table is Calendar. … Databases mssql |
 | Hi I want to know how can I make my database that the user can add a field to a table from a form or sth? thanks Databases microsoft-access |
| | |
| | Hi, I have the following table: Name Row(number) Nico 1 Marko 2 Peter 3 Joy 4 Kimi 5 I delete Nico and Joy: Marko 2 Peter 3 Kimi 5 And how to make a table would look as follows: Marko 1 Peter 2 Kimi 3 How to automatically re-arranged in … Databases mysql |
| | I have one table in this format: [ICODE] Product Component --------------------------- A part1 A part2 B part1 B part4 A part3 C part5 D part1 [/ICODE] now I want to display product which components meet requested items, for example: I know component are "part1" and "part3", need to show product … Databases mssql |
| | Hi guys i cant open the mdf on the ms sql express 2005 why this will happen it is another ways to open it. Databases mssql |
| | hey guys, I've just got sql server installed in my system but i dont know how to start it. There are 3 options when i click on "Microsoft SQL Server 2005" in the programs namely: SQL Server Configuration Manager SQL Server Error and usage reporting SQL Server Surface Area Configuration … |
| | Hi! I'm looking to update a field in a table via PHP, basically asking it to change a fields contents to 'foo' if it currently contains the word 'bar', or to change its contents to 'key' if it currently contains the word 'board'. I can't seem to get the syntax … Databases mysql |
| | I ran this query on my database: [code=sql]select O.ORDER_NUM, O.ORDER_DATE, O.CUSTOMER_NUM, C.CUSTOMER_NAME, C.STREET, C.CITY, C.STATE, C.ZIP from CUSTOMER C, ORDERS O where O.CUSTOMER_NUM =148 and C.CUSTOMER_NUM = 148;[/code] +-----------+------------+--------------+--------------------------+----------------+----------+-------+-------+ | ORDER_NUM | ORDER_DATE | CUSTOMER_NUM | CUSTOMER_NAME | STREET | CITY | STATE | ZIP | +-----------+------------+--------------+--------------------------+----------------+----------+-------+-------+ | 21608 | … Databases mysql |
| | I have a table that has become corrupt and I need to merge the records back into one record. I have multiple records that should be recombined and I have hit a brick wall on this. In my table the data looks like this part_id Unique c_date m_date Qty ht_num … Databases mssql |
| | I have 2 tables: a claim table and a corresponding date table. There can be multiple dates for each claim, with a qualifier type to distinguish them, and I'd like to retrieve them all in one row. Here's a snippet of what I have: [code=sql] SELECT d.PointerField , a.ApplianceDate b.AccidentDate … Databases mssql |
| | I'm trying to install SQL2008.AdventureWorks_All_Databases.x86.msi, but whether I try to install "Sample Files" or "Create AdventureWorks DBs", I keep getting the following error: PrepInstance() failed for MSSQL$SQLEXPRESS. The following features are missing: Full Text Search I already have installed on my PC: Microsoft SQL Server 2008 Microsoft SQL Server 2008 … Databases client-server database-design mssql publishing |
| | Hi, in MS SQL we have [B]TOP [I]some_value[/I][/B] clause which means that only some first records are selected. For example: [I]select top 10 products from table_products[/I] How can I select rows for example from 4th to 15th? Databases mssql |
 | I have 3 tables. Company, phone, companyPhone. The company table has an auto_increment companyID primaryKey The phone table has an auto_increment phoneID primaryKey The companyPhone table row is made up the companyID, and the phoneID. On my form the user will enter company information and the company phone number. After … Databases mysql |
 | Hi, Does anyone know of any simple to use software for bulk uploading products to an ecommerce website database? I dont know enough PHP or MYSQL to write my own scripts, so I was hoping there is a program to do it for me. I will have to use a … |
 | Pardon this post here as I didn't see any Postgres forum. I have a table with a 16 length bit value. Can someone please help me how I do the where clause on my select? example data for that field 0000000000000001 0000000000000011 0000000000000010 how would I select one of the … Databases mysql |
| | I have 3 tables, below are their structures ( a bit of pseudo code ) I'm trying to update one table, with a variable column name, retrieved from another table [B]order[/B] [id,field1,field2] [I]example row ( '1' , '', '' )[/I] [B]produkt[/B] [order_id,produktnr] [I]example row ( '1' , '23' )[/I] [B]fields[/B] … Databases mssql |
| | hi friends fetching datetime values from database, when data is null in code side it is displying the some garbage value instead that i want to show 'date is not found' the result is showind in grid view control service written for fetching datetime [code=C#] public List<Topics> GetAllTopicNames(int communityId) { … Databases mssql |
| | In this days, I am making dictionary site with PHP & Mysql. I write SQL like this [CODE]select * from dblist where `Word`='A' Union select * from dblist where `Word`like 'A%' Union select * from dblist where `Word`='%A%' Union select * from dblist where `Word`='%A'[/CODE] I don't use [CODE]`Word`='A' OR …  |
| | ok so i am doin a table that has info on all 44 presidents. i have to show the state the produces the biggest number of presidents...i am not sure how to do it. here is a lil bit of the table for you . I want it to show … Databases mysql |
| | Hi everyone, A few days ago I posted a question which someone did reply to. However, the tables have been re-arranged a bit and I didn't want to make my last thread confusing, so I thought I'd start fresh here. (Mod, you may close down my other thread; thanks). So … |
| | Hi, Anyone,please help me out.How to give ODBC Connection on Centos5.5(linux machine) and also what do you meant by FREETDS? Thanks in advance............... with regards, santhanalakshmi. Databases mssql |
| | Hi There. I am newbie. I need some helps on the below issues. Please help me! 1. How to create / delete user in Sql / Oracle? 2. How can I set privilages while create a new user? 3. How can I view all forms / tables? 4. How can … Databases oracle |
| | i need a source code of LIBRARY SYSTEM or a RENT A CAR System plz help me. the code should be written in oracle. thank you. Databases oracle  |
| | ok so i am working on a program that has a table of all the presidents and info on each of them. i tried to insert the date of their birthdays and deaths, but just got 0000-00-00 for a result when i went to see what the outcome looked like. … Databases mysql |
| | I want to find the percentage for each question’s answer and how many user response to that question The answer either yes , no, escaped (null) Table structure :[CODE] CREATE TABLE useranswers ( userAnswerID int(10) unsigned NOT NULL auto_increment, answer varchar(45) default NULL, userType varchar(45) default NULL, ques_tesxt varchar(300) default … Databases mysql |
| | Hey guys, Although I decided against using a listbox and simply just using a subform, I did spend a lot of time trying to figure out how to get the listbox to store more than one values for that field. If the listbox multiselect property is on "None", it stores, … Databases microsoft-access |
| | i am a al atudent...i hv to do a pjt about creating a database of sports day...although i hv learnt some sql about database...but i really don't know how to start to create a database.....eg...use wt software..wt have to include inside.....how can i show my product to my teacher...the pjt … Databases |
The End.