3,481 Topics
 | |
| | Hello, i've got two tabels, "Artists" and "Music". The relevant columns are: Artists: [Id],[Name] Music: [Id],[ArtistId], [Title],[Added] I want select the post's in the music table, but instead of returning the artist id, it should return [Name] from the Artist table where Music.ArtistId = Artists.Id (so it looks in the … |
| | Hi! i've been searching for answeres on mssql questions and this looks like a place to find them. hope i can return the favor some day. maybe in perl or something else i know better. |
| | i have a problem on my coding, where it only show me the result of 4 tables instead of 100(for examples)..can someone check the coding flow for me. thank you it is about checking the table and the index size(individually). i tried for days,but still cant get the problem solved.Thank … |
| | i have a problem on my coding, where it only show me the result of 4 tables instead of 100(for examples)..can someone check the coding flow for me. thank you it is about checking the table and the index size(individually). i tried for days,but still cant get the problem solved.Thank … |
| | |
| | I have a MS Access db that I use on my local machine to generate numerous reports etc. currently I am manually downloading a copy of the table from the online Microsoft SQL db which contains the data I use in generating these reports etc. I would like to link … |
| | hello, how to close all open sql server connections from vb.net? please help. |
| | Hey, I want a search of name ='Jose' to find both Jose and José, but with SELECT * FROM Users WHERE name LIKE '%Jose%' i only get Jose, in "Inside SQL SQL" an article shows this: If you want a search of name ='Jose' to find both Jose and José, … |
| | Hi all i m currently having mysql5.0.18 installed on linux box and i want to downgrade it to some of 4.1.xx. at that same time i want to retrive data also so can any helpme with the same. plz provide some soltion as i dont know how to do that … |
| | Hello, I'm pretty much a newbie with SQL. I have a database that is growing out of control and I'm unable to delete any records (data) from it. I've tried numerous open source applications but nothing has worked. The database is with a hosting and they provide ASP.NET Enterprise Manager. … |
| | Hi, 2 days ago my computer got hit by the amaena / winfixer problem. I haven't been able to sort it out until tonight though. I read through other threads to help me find a solutiion and I followed the advice for running Hijack This and also for running ewido …  |
 | I've been working on a production DB on a POS and Inventory System for over a year. That's over a year of data and along the way, I took that system and implemented to 4 locations and 4 individual servers. I've major software updates and Schema changes (adding Views, SP, … |
 | Hello, hello... I've done a little bit of spyware annihilating and whatnot, and I guess I have a fairly clean log now; but seeing as I am not a professional, I cannot be too sure that my log is 100% clean. Anybody care to check it for me please? [CENTER]~~~~~[/CENTER] … |
| | Hi, I am having a table with 16 lakhs records in it. Each record contains approximately 50 columns. I am using MSSQL Database. Basically the table contains details of the user's registration details. I have a application built in VB.net which will be selecting a random user_id and then searches … |
| | hi im new to this ....but have read a few posts about this trojan.cachecache kit thing. Although this is not my computer i am trying to sort it. A trojan keeps coming up an an autoprotect window .. i take it somehting to do with symantec antivirus .. but when …  |
| | Hi all, Has anyone ever tried creating a form in infopath that collects timecard data (hours worked, etc.) then, when the user clicks "Submit", the information gets posted to an SQL database? This is probably fairly easy, but my feeble attempt failed horribly today. If any knows of a link … |
| | Ich transferiere gerade ein Hosting von einem alten auf einen schnelleren Server. Gleichzeitige Versionsänderung MS SQL Server von 6.5 auf 2000. Dabei habe ich mit einer SQL-Abfrage zu kämpfen. Und zwar sieht die folgendermassen aus: SELECT COUNT(*) AS nrecords FROM ABData WHERE (0=0) AND (MARKE='Dodge') AND (Rubrik='Autos') Cold Fusion meldet … |
| | PERL / LAMP PROGRAMMER COMPANY OVERVIEW: We are a small internet applications development firm, which develops concept-to-completion solutions for mid- to large-sized companies. We’ve been serving loyal clients for over 10 years. POSITION DESCRIPTION: Programmer will develop corporate internet applications which adhere to specified standards. Must be able to follow … |
| | Hi All, I want to save a large string (>8KB) in to a table feild. How can I do this,Pls help me on this |
| | hi if i have table employee with employee_id as a primary key [b]how can i assign the primary key to the columns firstname and lastname?[/b] table structure is something like this : employee_id int not null, firstname varchar(20) not null, lastname varchar(20) not null the problem is that there is … |
| | hey cna you please explain to me the following <" Because the database also stores all the data of the database itself, each database has a number of system tables. Each new database is created following the Model database model. The Master database keeps track of information about the other … |
 | You guys probably think I'm nuts, but I am considering doing a massive *condensing* of ALL forums on the site. I think that having so many forums and subforums levels deep just is so incredibly confusing and overwhelming to new visitors. What I am proposing is getting rid of all … |
| | Hi all, I'm looking for a nice query tool to query MS SQL and/or Sybase databases. Currently, I'm using Excel to do some minor query stuffs...and I don't mind using it but it get's repetitive when you have to do it for 70 different databases. So I'm looking for something … |
| | I'm running a query through XML from the local database which uses PHPMyAdmin to a remote one which uses MSSQL. Unfortunately I have no way of checking syntax against MSSQL so all I know is that this works in PHPMyAdmin. So the query gets as far as running, but is … |
| | Hi, I got this problem on my laptop and it's driving me nuts!!! Everytime I access [url]www.webmsn.com[/url], a searchportal window pops up!!! I used Adware, Spybot S&D, Ewido, CS shredder but it's still popping up. Can someone please take a look at my HJT log and see what's causing this?? …  |
| | Regarding my subject line: Here's my HJT log. Can anyone help? Logfile of HijackThis v1.99.1 Scan saved at 4:21:38 PM, on 3/3/2006 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\Program Files\Windows Defender\MsMpEng.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\Explorer.EXE C:\WINDOWS\system32\LEXBCES.EXE C:\WINDOWS\system32\spoolsv.exe C:\WINDOWS\system32\LEXPPS.EXE C:\WINDOWS\System32\hkcmd.exe …  |
| | im working on a asp.net project, sorta like a web portal, which will need a user database. i have a very good understanding of sql. i just want some examples or tips on writing a good user database. ive create a few which i think are good, but could be … |
| | Hey Guys I am looking, (with hardly any prior experience; some unix scripting knowledge), to write a Time Record program, which keeps track of how long people spend on each tasks. This may incorporate some Billing aspects at Version 2. I am willing to learn all the programming aspects required, … |
| | I've been having trouble with a strange popup box showing up when I try to access my IIS server through it's IP address (even on the host computer itself). If I enter the host computer's user/pass it will work fine, but unfortunately the other users on my intranet have to … |
| | Hello have a good day is there a way to retrive top records by range , i mean like this "select top 15 to 20 record from Table name any condition" i dont mean top 15 or top 20, i mean records from 15-20 take care thanking u in advance …  |
| | trying to get a count of transfers from one account to another account within the same bank relevant columns: table transfers transferid, toaccount, fromaccount table accounts accountid, bank what i have now is select count(*) from transfers where toaccount in (select accountid from accounts where bank = @bank)and fromaccount in(select … |
| | Hello have a good day is there any way to retrieve record number with each record in simple sql qry? e.g select "REC_no",name from "table_name" the result should display like this 1 ,noman 2,imran 3,Jose etc take care thanking u in advance Bye |
| | I got some experience working and managing ms sql databases, but now I am in a need to replicate 2 databases and I can't make it work. Please advise. If it's possible step by step. Thanx |
| | on 14.1 norton discovered hacktool.rootkit on my system. tried to fix using norton with no succes. On 16.1 Liveupdate couldnt install new virus definitions and scan couldnt find hacktool.rootkit anymore. I downloaded Intelligent updater but couldnt run because subscription expired. But subscription status shows remaining 332 days! Any help to …  |
| | Hi, I've had a website built for me using asp and mssql. Im getting errors relating to the date format in queries being submitted. The asp is trying to insert dates in format dd/mm/yyyy, but after testing my mssql server is expecting the dates in format yyyy/mm/dd. Is there a … |
 | [b]JodoHost celebrates its 3rd anniversary [/b] and enters into its 4th year of business. We are providing Shared and Reseller Hosting on Windows, Linux and VPS (Linux) Servers. It has been a long journey for us since December 30th, 2002, when we started off as a tiny webhosting company offering … |
| | Hi All, Ive been infected with Spy Sheriff (amoung others no doubt). I have trawled thru the various forums on how to clean this any everything seems to be different and all seem to start with a HJT log so I will start here too. Please help me. Many Thanks … |
| | I've been enlisted by a friend to remove Hacktool.Rootkit, but I can't seem to get rid of it. It seems to be acting differently than the other reports I've read. The computer was infected in a similar way (IM about pictures) but Norton isn't constantly popping up errors, it only … |
| | Well here it is. Norton found some stuff and i want to make sure i am all clean. [quote] Logfile of HijackThis v1.99.1 Scan saved at 12:39:09 PM, on 1/7/2006 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe … |
| | Hello every body, Iam santhosh .I need help.Iam using MS Sql server 2000.I have one database.In a column of one table i haved set that to identity property that property generating serial numbers for that table .But that table is not updating. Table 1 Sno SID Name 1 212 Klen … |
| | Does anyone know how to connect to an MSSQL View in syntax. If you know please right back asap. I need this project done quick. Thanks. |
| | Gallery database -------------------------------------------------------------------------------- Hello averybody I would like to know your opinion how do you design a database that will works as photo gallery, let's count there will be a lot of pictures. Do you save the pictures on the disk or directly on the database? Write please your ideas … |
| | For some reason i cant get the mssql function to be inabled. When i go to view the phpinfo.php that i made to view the extension that are enabled it gives me an error saying that it cant load the extension. So i try to enable the pdf.dll in php.in … |
| | Hi - I was hoping someone could help me out. Computer is having all kinds of problems...Winfix pop-ups, among other things have basically rendered the computer useless at times. Any assistance would be greatly appreciated. Hijack This Log is posted below. Thanks. Logfile of HijackThis v1.99.1 Scan saved at 9:05:35 … |
| | Hi, my problem is that I can't seem to connect to certain websites using both firefox and IE. You have already addressed this same issue with another person and after following all of the steps outlined in his solution I still can't seem to fix it. Using FF I get … |
| | I am not new to computers and consider myself to be fairly competant. This is the first time I have received something that I can't fix on my own (knock on wood). I have never used HijackThis, but seems to be working fairly well for others. From other forums I … |
| | while iam running a jdbc connection program iam getting the following exception : Exception in thread "main" java.lang.ClassNotFoundException: com.microsoft.jdbc. sqlserver.SQLServerDriver at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClassInternal(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at DBCreate.main(DBCreate.java:7) plz … |
| | I have a value E101 as my empId in my employees table and now i need to increment this value, i.e. E102, E103...etc. How can i get this to work? I've used the procedure but it's not working what am i doing wrong? ALTER PROCEDURE CalcPrimaryKey AS DECLARE @numValue int, … |
| | [B][I]MSSQL Where Statement Problem[/I][/B] [COLOR=BLACK] [LEFT]I want to select all in a column if variable = null I am placing a php variable in there and i know how to do that so i no that is not the problem but i want a where statement to return all rows … |
| | Situation table1 has 2 columns: userid and requiredInfo It will have an entry for every user table2 has 2 columns: userid and optionalInfo It will have entries for some users but not others Problem: need a statement that returns either userid, table1.requiredInfo, table2.optionalInfo --if table2 has an entry OR userid, … |
The End.