2,935 Topics
 | |
 | I'm working with SQL Server 2005 on a stored procedure, but it appears to be going through both parts of the following statement, and not skipping the second half if it is supposed to. Basically it should update the row if there is data there, and remove the row if … |
| | Hello! I have two tables in an MS SQL database that I'm trying to join and display through PHP. My connection is fine and I've done it many times before, so don't worry this isn't a PHP problem. It's a my-query-won't-finish-executing problem. Table A: (about 2 million entries) id | … |
| | Hello, there this is my first post and I´m desperate seeking for help, I have almost not knowledge of SQL as it is not my usual work. However, suddenly it has converted in mine....Hopefully I will got help in here. Well the issue is that our database manager has resigned … |
| | can anybody tell me abt the difference b/w sql server 2000 and 2005 |
| | can anybody tell me about the difference b/s a SP and functions  |
| | but i hope someone can point me in the right direction. here's the story 2 pc's, one upstairs with database one downstairs used to access and make changes to. This was working no problem for months. Then the downstairs pc needed a new AGP video card, easy install no configuration … |
| | [B][B]hi every body i'm new to MS SQL and i want to learn it if any body knows good source or web sites about sql server 2000, i'll appreciate if he lets me know thanx for your help, everunloaded, bye[/B][/B] |
| | LOL - I figured it out - but thanks for looking :) |
| | I want to automate the file transfer from a remote site to my pc over a WAN. Can anyone please suggest an industry standard secure file transfer tool for a windows environment? I am looking for an industry accepted, more secure than traditional FTP. Thanks! |
| | can we write queries in functions I mean can execute queries in funcitons?  |
 | I have a customer with a small accounting/invoice software program (order pro). Not very fancy at all. At any rate, the software stores all of the invoice data in one ".XDB" file. Anyone have any idea what type of database this could be? It seems like the application is an …  |
| | Hi new to the forum. I hope there is someone that can help me. I need to retrive some data from a table in sql server. The data is going to be used in an import to some other tool. The problem i have is as follow. I want to …  |
| | Hey everyone, This problem I've been working with has got me stumped. Let me show you the table layout first. ID_NUM int, SEQ_NUM int, ATTRIBUTE_CODE char(2), ATTRIBUTE_DEF char(50), JOB_TIME datetime This table contains a list of activities individuals like and there is no way of knowing which one they like … |
| | The tables are joined. I want to display last 7 data with grouping their category My tables: Category: categoryId, categoryName Order: orderId, catgoryId, product |
| | Hello, Could you help, with sql injecton about from where i can download it and who it is works. plz  |
| | Hi I have question. When I post a thread, on focus of that thread, the brief discussion of that thread is displayed. I would like to know, how to develop that feature. Can some body help me out? |
| | i have a column "discription" in my item table that is full of HTML code. It was created using and editor like the one i am using here. It is five pages long when i print it out. I need to update the column in all records of the table. … |
| | Hi guys. I have a program which needs to store some user profile data. I want to use a database to do this, but i've never worked with databases. I was wondering if anyone can help me with it. My program is written in the java programming language, and i …  |
| | hi :) any comments appreciated about my site [url]http://extendedprocedure.com/[/url] |
| | Hi All, I have a software module(enquiry) developed in ASP using MSSQL as back end. In the index page , i display 4 new enquiries for the logged in user, clicking on which land to the enquiry pages. This has been working fine. But now recently i have come across … |
| | I've always heard it best to keep processes separate when dealing with Application servers etc. My question is this: [COLOR="Red"]Are there any best practices associated with creating a website that queries a SQL Database? [/COLOR] My thought is to separate the web element from the SQL Server and host it … |
| | probably, all of you have seen this scenario a lot when entering customerID into a large database it takes AGES to bring back one simple record of a single customer === let's say, this has been DONE already , for tuning performance separate the CUSTOMERS table into 2 TBLcustomer1 -- …  |
| | Hi All, I have a software module(enquiry) developed in ASP using MSSQL as back end. In the index page , i display 4 new enquiries for the logged in user, clicking on which land to the enquiry pages. This has been working fine. But now recently i have come across … |
| | company is using SQL version 7 to support heavy many ASP program last weekend, I try to upgrade it by installing extra SQL version 2000 (a software that company got) -- to try to aim for failover custer for the future then I can't find the enterprise manager console from … |
| | Recently had to re-install all of pc...not a prob as all (except db) was backed up to seperate hd. I develop locally using MSSQL client tools and adp's and then upload new tables as and when ready. I had done quite a bit of work when pc died, and now … |
| | Hi, Simple query: [code]select * from MyTable where Id=123456;[/code] The first time I execute this query it takes 14 seconds. However, the second time I execute it takes 0 seconds. I wanted to clear the cache so the second execution takes 14 second just like the first execution. So i … |
| | |
| | I need help to write a stored procedure, or pseudo code, that looks into a table named numbers_ranges and retrieves the next unused value. The table currently has the following data: Columns are: id, start_range (22), end_range (22), status (1), date_created (datetime), date_updated (datetime) 1 8057777777450780000000 8057777777450780000010 N 2007-11-29 16:28:46.793 … |
| | Hi, A third party development company is creating a third party application for us in PHP and uses a MYSQL database. The app is an extension of our website which is developed in .NET and uses a MSSQL 2005 database. There are some cases where the two databases require connectivity … |
| | Hi all, I'm currently finally starting mysql and am have difficulty getting it up online. what i've done so far is correct but only for this error: Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to MySQL server on 'www.dteeducation.ie' (61) in /usr/www/users/adv123site/home/youruser/public_html//settings/database.php on line 10 Cannot connect to database, check if username, … |
The End.