3,481 Topics
 | |
| | Hello, What is the purpose of putting an MDF file in the "app_data" folder? is it a way to avoid using microsoft sql server? currently i'm paying a lot of extra money (more than hosting fees) to my hosting company for mssq database. can i use an mdf file like … |
| | Hi, I am trying to do a search function on my GridView. However when I tried using ( LIKE '%' + @ea_name2 + '%' ), it would only return me values if "ea_name2" is not null. I would like that SQL statement to execute even when "ea_name2" is null. Any …  |
| | Hi all, I am new to sql programming, How can we copy a database from a local system to server? Thanks in advance, karthik. |
| | Hello, I'm making a phone book application (ASP.NET, C#). I store general information of people such as name etc on one table called "people", and I've another table called "relatedInformation" which has 5 columns (ID, Name, Info, PersonID, Type). In this table I store all other information regarding people, because … |
| | Hi, I would like to know if it's possible to create a procedure, where we pass 2 arguments (the databases where the search must be done) and how to use those parameters in select clause What I would like to know is if it's possible something like: [CODE]create proc dbo.uspMySearch …  |
| | I'm working with SQL 7 on a Windows Server 2003 R2 Ent. Things will be working just fine and then we will for some unknowen reason start getting this error message and then we have to restore the DB to resolve it? This has now happened twice within the last … |
| | I have tried everthinh and cannot get rid of this. PC Tools and Symantec will lock up once they hit the prunnet.exe file. I am starting to get all kinds of pop up that I don't want. P,lease help this is driving me nuts.. Any help would be greatly appreciated. … |
 | I wanted to ask this before I tried to build these two large tables myself. Does anyone know where or if I can find an MS Sql table of the United States, Cites and States. Possibly with the relationship between state and cites already built, or even an Sql procedure … |
| | Hi, I am currently trying to develop my system that would send an email reminder to a user when the deadline for a particular matter is approaching. I did a bit of a research online and I realised that I will need to do some sort of a cron job. … |
| | Hi, we are shifting our data-setup from SQL Server 2000 to SQL Server 2005. With regard to this, I am facing an issue with replication of the databases. We have a database with over 600 articles that are published. The procedure that we followed with SQL Server 2000 in order … |
| | How would I select everything from last month in a sql statment my cell has a time stamp in it [CODE]SELECT DateTimeStamp from Get_estimates[/CODE] Ouput [DateTimeStamp] 2008-02-28 11:39:35.247 2008-03-09 13:15:12.513 2008-03-09 13:16:53.700 2008-03-26 13:30:20.077 2008-03-26 13:30:51.810 |
| | Hi there, I'm completely lost. I have 3 tables: - work (workID, description) - machine (machineID, name) - work_machine (machineID, workID, hours) What I want is to obtain a result similar to: work, machine1, machine2 A , 1 , B , 3 , 5 The problem is that the number … |
| | Hi all, I have managed to get my average using cross tabs but only if I have grouped it by their categories. If I remove the GROUP BY clause, the cross tabbing doesn't seem to work. Can anyone help me? I would need to get something like:- [CODE]Year | Month … |
 | |
| | Greeting When it comes to SQL I'm a novice and I think what I want to do is WAY outside my expertise. I have a file management system called ProjectWise. Everything to create the folder path is located in a single table. You start with the lowest folder then you … |
| | Hi Group , A small Query ,I need to know how can I notify a new row entry in a table. to be more specific I have a table Users If at all a new users registers from web his details are stored in database. i would like to know … |
| | I am a SQL n00b, mostly using some hand-jammed ASP to access/update data. Now I have been tasked to develop a web map of our campus so I need the geospatial functionality of SQL 2008. I have a server (Windows 2003) that is limited by domain policy. I tried to … |
| | My computer is having problems that seem virus related. First I have a laptop and I am having a problem turning it on when it is on its docking station. Also, when I am finally able to get it running the task manager keeps saying there is a picture opening … |
| | Hi guys. I have web site, but my hosting don't support php functions(mssql,sqlsrv,obdc_connect) :cry: for connections to MS SQL. I need that remote connect to MS SQL and receive from data online. Can you tell me, about alternative ways to import data from remote MS SQL server with php script. … |
| | Hello I have two tables a Master and Child. I want to return a recordset that has all of the Master records and any related child values. Sample Data: [INDENT][B]Master Table[/B] 'id' 'field1' 1 Test1 2 Test2 3 Test3 [B]Child Table[/B] 'id' 'masterID' 'field1' 1 2 Child1[/INDENT]The following code will … |
| | hello Guys, I facing a sql query problem which is i need to join many query into one query. That is : a) [code=sql]SELECT sum(Total) As [MONEY1] FROM ((SELECT SUM(T1.Amount+T2.Amount) AS Total FROM TABLE1 T1 INNER TABLE2 T2 ON T1.ID = T2.ID) UNION ALL (SELECT SUM(T3.Amount+T4.Amount) AS Total FROM TABLE3 … |
| | using PHP with mySQL, or ASP with msAccess 2000 on a win2000Server web server; also using a "rich text format" utility to allow formatting of text in a text area: when i use the mySQL command "UPDATE", and data from the textarea is written to the database, it adds erroneous … |
| | Hi I have a problem when I am copying data from my excel document to sql server 2005. I have a document called database.xls Every time I try to copy files from the document to sql server. It comes up with an error. "Column 'tid' does not allow DBNull.Value." You … |
| | this computer has had problems kind of coming and going and it seems fine at the moment but i'm wondering if there is any hidden problems still around. here the hijackthis log Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 8:28:35 PM, on 12/23/2008 Platform: Windows XP SP2 (WinNT … |
| | I am having a problem with my sql select statement below. What i am trying to accomplish is add a weighted gpa average to the actual average that gets calculated after a vendor gets assigned a gpa per job. The sectioned off area is where the problem lies. it is … |
| | I need to replicate data from server A to server B, server A is for transactional use, while server B is for reporting, where we do some database modification, for example posting, the problem is everytime the replicate agent run, it reset the modification into the original data. and when … |
| | We are building a query to count the number of events per hour, per day. Most days there are hours that do not have any activity and therefore where the query is run the count of activities per hour show up but there are gaps and the query excludes these. … |
| | Hello all! I need that awesome knowledge I know you have!! In your opinion, how would you create the following? Here are the specs. Database driven website Multiple users <200 from all over U.S. Intranet based < 700 different fields Server side will be mssql (IT requirement). Same record edit … |
| | How do search an entire SQL server - every database, every table, every field - for an exact match? Help much appreciated, Harry |
| | I need to connect my hosted vps in a data center to my sql server so I can pull info out of a database for our website. I setup a vpn by the windows dialup vpn wizard. It works fine but when I logoff the VPS it disconnects the VPN … |
| | Hi Jholland, I have the same problem what Asurocks had. My Windows start is fully disabled I am not able to use any of the options provided by Windows start i.e, All Programs, Control Panel, Setting etc. I think this is caused by a virus. Can you please help me? … |
| | Hello guys. I'm trying to make a database about football games (results, managers, players etc.). For my Players table i want to include these stats: - first and last names, nationality, date of birth (constants through time) - games played the current season, goals scored, cards received, minutes played in … |
| | Hi, I am a beginner in Microsoft SQL. I want to create a fulltext index from a UNIQUE key. For that purpose I have the following code: [code=sql]CREATE FULLTEXT INDEX ON sample_table (data) KEY INDEX UQ__sample_table__59FA5E80 ON Catalog_data WITH CHANGE_TRACKING OFF, NO POPULATION[/code] This works fine. The problem is that … |
| | Hi, I am trying to copy som data from an excel document that I have on the server into a table in my ms sql server. I think the problem now is that I am having trouble connecting to the sql server. I'm using sql server 2005. You can see … |
| | how to select last record from a huge amount of database?can anyone help me with this? |
 | hey there lovely people, i am trying to make an application that makes database backups, now obviously i need to add the file / filegroup backup option too , which is not a problem except for this one little problem... How can i get the application to display a list …  |
| | I am transferring This Thread from java forum [URL="http://www.daniweb.com/forums/thread161727.html"]http://www.daniweb.com/forums/thread161727.html[/URL] i am edit table.....add column change_id And i want to write data...means update table..... [COLOR="Green"]original table[/COLOR] id user_id rating date_created 123 1 4 2008-12-09 211 1 3 2008-12-08 33 1 4 2008-11-30 45 1 3 2008-10-31 57 1 2 2008-10-31 666 …  |
| | Hey hey I have two tables with a lot of data, i need to insert certain column values from table one into table two - eg Table one column = First_Name Table two column = Name I need to get all the values in table one (First_Name) into table two … |
| | hi, i have one table called EMP with 3 fields SSN,ENAME,MGRSSN. query to retrieve all employees name and their respective manager names(only using this table no other table and ssn primary key. i know till here.. [code=sql]SELECT ENAME,??? FROM EMP WHERE SSN=MGRSSN ;[/code] here im only getting manager's name..so how … |
| | Hey there, i really want to break my pc by now can anyone tell me how to get around this ?? I just want to update the new database here [code] USE NGCOLLECT GO INSERT INTO dbo.Cases ( CustId , Consultant , Bank , OldAccountNo , LastAmountReceived , DateReceived , … |
| | Hey, I'm dealing with a problem I cannot solve because I have no idea why it doesn't work. I'm trying to store some XML into an MSSQL database, using TEXT as fieldtype. I pass the XML as one large string. I don't get any errors but the xml field in … |
| | I've mssql 2000 database is it possible to change it to 2005? |
| | Hi, For my assignment work I have to make 3 queries, and one of my queries includes a part that needs me to work out with orders have a total price above £70. Here's the code I have so far: [code=sql]SELECT SUM(Quantity*Price) As Total_Order_Cost FROM Orders JOIN [Product_orders] ON [Orders].Order_ID … |
| | hi, i need some advise regarding storage of data is it good to store data in files rather than storing into database? (eg data like comments or additional features of products that users advertise on our website.) will it help for speed optimization. |
| | Hi i need help on how to create a query so that the result will be like in my attach screenshot |
| | Hey guys, I'm currently testing my application with some scripts I have written. I'm using the following query to list known errors within my application, and the status of the tests that are are affected by each error: [code=sql]SELECT ERROR.BG_ERROR_ID, ERROR.BG_USER_03 as HardwareID, count (RUN.CY_RUN_ID) as NumAffected, sum (CASE RUN.RESULT … |
| | I downloaded SQL Server 2005 standard edition from MSDN. I tried to install it but the splash.hta and setup.exe don't work. When I click on splash.hta, northing happens. When I click on setup.exe I get the message "setup failed". When I uninstalled the standard edition and instead downloaded the developer … |
| | Hey can anyone give me the query to retrieve a list of databases on a server rather than this query [code]SELECT NAME FROM sysobjects[/code] which gives me a list of tables ???? Thank you |
| | was directed here by another member...great site! (am a newbie and I recently posted this on MSDN with 0 replies, am hoping someone can help here - you do not need to know VFP, just need help formatted a correct string that ASP will honor), Current Setup: Using: Visual Web … |
| | [code=sql]res = PQexec(conn,"BEGIN"); PQClear(res); res = PQexec(conn,"DECLARE myportal cursor for select * from test"); PQClear(res); res= PQexec(conn,"FETCH ALL IN myportak"); ---- ---USE THE RESULT SET ------- PQClear(res); res = PQexec(conn,"END"); PQClear(res);[/code] |
The End.