hi,
i have a php code
i want to change my table cell background color to red if the value is sold and green if its available im using php and mysql
i want to know where should i write this ...
Is there a way to get access to the data in other databases within SQL Express? I am assuming the 4 gig liimit is applicable to each database so if I have multiple databases about 2 gig each,...
Hi Experts,
The database at work (which has a MS SQL database backend and MS Access front end that sits on a Citrix box) is quite large (around 750Mb) and seems to be crashing occasionally....
Looking for syntax, if possible, for a caculated field in MS SQL 2008.
Normal syntax in a query:
typeCtotal= CASE OL_TYPE WHEN 'L' THEN OL_EXT ELSE 0 END
I tried "CASE OL_TYPE WHEN 'L' TH...
hello,
I am trying to search a database where the date field is blank, its an advantage database. The bellow code returns values but I want the rows which have not data. I have but just get...
I have the table below and it's susceptible to update anomalies, what is an example of an insertion, deletion, and modify anomalies of the table?
About the delete, I was thinking that if I ...
I am trying to create a connection to an Access Database in my GoDaddy account. I used DNSless connection strings several years ago but I don't remember how I did it.
GoDaddy allows me to set...
Hello this question is related to 24852806, where i am having few syntax error executing a stored procedure in sql server.
When I execute the below command I get the :
Incorrect syntax ...
Hey,
I'm trying to create a table in MySQL, this is the first time I'm using it, so I don't really know what I'm doing... I tried looking through http://www.w3schools.com/SQl/defaul...
I will be taking Oracle 11g Administration. This course teaches the core (ins and outs) of Oracle sever. However, is structure of SQL Server as complex as Oracle Server?
If you have any onl...
Hi Guys,
I am trying to develop an sp where you enter in a ref no, and it will display the ref no, and all ref no's associated with that ref no (via an old_ref_no link)
CREATE TABLE TEMP...
I have mistakenly taken my default database offline (not the master database) and now cannot access the local server from within Enterprise Manager.
I get the following error:
A connectio...
I am just starting to learn about databases, and I keep running across a term that I do not really understand. Could someone point me to a good link that explains database "input sanitation" ...
Hi,
I have a number of databases on my server - 80 to be precise which I need to return in the below query.
What I also need to do is next to each database is to return a field from a ta...
Hi.
I'm told that every SELECT statement returns a table, so why doesn't the following statement work in SQL Server 2000?
SELECT * FROM (SELECT * FROM MyTable)
"Incorrect syntax near ...
I'm getting the following error with the below code:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'Select'.
The erro...
Hey,
I was just wondering how we use data from one table to search another table... I wanna use the first column in one table and compare it to the first column of another table... ...
Can someone please assist with fixing the error msg I am getting:
insert statement conflicts with foreign key cosntraint.. FK_Employee_Job_title..
Thanks
Add auto increment in 'ProId' with PgAdminIII I try right click and I can not find how can add auto in crement please suggest
I am wanting to set a time limit for a job in SQL Server to process before it is stopped. I have a job that runs a DTS package which hangs every once in a while (seldom) but it is still a pro...
I am setting up a basic payment database in SQL, it consists of a few key areas, members, payments and deductions
payments get imported into the database, however, I need the system to dedu...
I have imported two csv files into a new database and both are now in different tables. The two tables have one field in common and that is the item ID.
The tables come from ebay sales and...
I have a database that has a table that stores data. I want it to only store data for the past 90 days instead of infinately. Mainly because the table gets too large and fills up my hard dis...
Hello -
I have an application that sets up multiple databases with varied names on my users PC's. I need to write a utility that deletes the databases in order to reset the application fo...
I would like to connect two tables of data. The first table called Master table and I would like to match my second table ,which is very messay, to the master table. For example: the data bel...
