3,481 Topics
 | |
| | Hi you wonderful helpers who generously give your time away to help the less competent :) I thought this would be an easy task but I'm not an advanced SQL guy and don't know how to use an inner join, which apparently I need to use. I have two tables … |
| | When i try to install MS SQL 2000 on Windows XP machine it says that server component is not supported by this OS.What should i do get it run on this machine? |
| | hi every one, i want to know about configuring sql mail.i have sql server on my computer and i want to configure it to send sql mail.i want to know which account i have to use as local system account is not being accepted.when i try to create seperate account,i … |
| | Windows XP SP 2 I have an Acer AL1912 with a Nvdia GFORCEMX440 graphic card (I think I spelled that right) I know the PC came with a built in video [URL="http://www.daniweb.com/forums/thread77487.html#"]display[/URL] on the motherboard but its been bypassed in favor of this one. Unfortunately most times when I boot … |
| | How can i copy Tables from mssql server from my computer to oder /from my server to oder/. The Data Bases are ready created i must put only the Tables to oder DB. Please can you tell me how? |
| | I am using VS 2005 to connect to my MS SQL server. I dont have remote access or anyother way of getting into the box. I am missing Object Explorer in the vs. I need this in order to set some contraints on the database. Is there a way to …  |
| | I am trying to do some constraints on a database. Since I dont have the object explorer option. What is the command line syntax for a constraint |
| | hi, does anybody know how to update garbled characters that are being stored in the database..i am storing vietnamese characters in my db and found out that it some characters are garbled appeared as ? or squares... any help is grately appreciated..thanks in advance.. :):) |
| | How do you check free space or space used within an MDF? The "Percent Log Used" performance condition alert doesn't check MDF files. The sp_spaceused is close, but combines all files, and sp_helpfile shows current file sizes and growth specs, but not free/used. How do you programatically get the same … |
| | Hi, Im having a nightmare trying to install SQL server Evaluation Version onto Windows XP Pro. In the installation, at the service accounts section, it just wouldnt recognise any of the Windows Accounts that are on my machine, therefore i using a Local System Account so i could come back … |
| | Hey everyone I want a where clause based off a variable input and I'm having some trouble with the syntax. My current code(incorrect) is below but it shows what I am aiming for. Does anyone have any suggestions? [CODE](CASE WHEN @inIndustry = 'ALL' THEN WHERE EXISTS (SELECT 1 FROM sysdba.C_PROJECTREVENUE … |
| | I'm trying to migrate some code to generate an rss feed from classic ASP to .NET (because its cleaner). I've got it working perfectly for the first feed I try, but when I tried to modify the code for the next feed I get a [B] [I]Specified cast is not … |
| | hi every one, iam a newbie in .net,i have a application in which i have to send email using triggers.can any one plz help, on how to configure sql mail .my application needs to delete rows on completion of expiry date and send the administrator email notifying it. ok waiting … |
| | am making a CMS solution and need help to get out an article list. The reason why this is a bit tricky is because articles does not have the same fields stored in one static article-table. In tblArticle all standard information about each article is stored. In tblArticleAttribute all different …  |
| | Having numerous issues here. Windows Defender cannot update, getting various error codes each time I try. Such as 0x80040154 and 0x8007043c. Have tried various solution suggestions on Internet but none work. Also, Internet Explorer will not load Windows Updates and cannot load Microsoft Update engine. Tried in safe mode also. … |
| | I need to write a query that pulls out Zip codes by the first three characters, so I started with this: [code] SELECT SUBSTRING(Zip, 1, 3) FROM AvailHomeZips AS tZip [/code] But I would also like to query out the zips by those substrings I pulled out, so that would … |
| | Hi, I created to data tables to hold information provided through peer reviews in the company that I work for. One table has 5 different levels of quality (unsatisfactory, meets some requirements, meets requirements, exceeds expectations greatly exceeds expectations), and another table that holds the data for each peer review … |
| | It seems I've been infected with an obnoxious little vermin. Not sure exactly how I picked it up, in that I haven't been to any sites that I hadn't used many times before. The remaining artifact is a persistent bubble that pops up from the system tray saying: System Alert! … |
| | I bet you guys get sick of these requests, but I need some help, so here goes. Get random automatically opening Explorer advertising pop ups coming up... Here's the log. Logfile of HijackThis v1.99.1 Scan saved at 5:17:04 PM, on 6/7/2007 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer … |
| | Hello all My wife accidently installed some crap on the computer, now I have pop-ups, my home page gets changed and it slows my internet down. Here is my hijack log. Logfile of HijackThis v1.99.1 Scan saved at 1:20:10 PM, on 6/10/2007 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet … |
| | could any one help in inserting images or files directly into mssql database using cold fusion and also should pull the data directly from the database without using any temporary folders both inserting and retrieving. |
| | I'm in need of some help with 3 tables I have with MSSQL. Is there a way to use a single database query to get the results I'm looking for? (See the bottom for an ideal returned recordset.) Thanks! TABLE: APPLICATION APP_ID APP_NM GRP_ID -------------------------------------- 1 Script 1 1 2 … |
| | Hi All, I want to develope database-driven application using JSP and JRun as the server. THe thing I want to know is how do I connect to the MSSQL Server 2000 database using JSP? What type of JDBC? And how to install the JDBC driver? Thanks in advance... :) |
| | i have table (id1,id2) 1.row [1,2] 2.row [2,1] 3.row [3,4] 4.row [4,3] 5.row [5,6] 6.row [6,5] i want to get result: 1.row [1,2] 3.row [3,4] 5.row [5,6] or 2.row [2,1] 4.row [4,3] 6.row [6,5] i try anithing, (but not temporarry table), to eliminate cross data, but ... , can you … |
| | I need to create connection pool i think shared connections and controlled through semaphores. or its only on connections string level? , i saw code in java but NET nothing. |
| | I've just finished a long term contract and looking for another big project; 3-6 month contract or a full time offsite position as an ASP.NET developer/architect. I have 6 years of a full cycle development experience with ASP.NET 2.0 (C#) and Microsoft SQL Server 2005 development. * I have strong …  |
| | I'm Using Microsoft Visual Web Developer 2005 Express Edition to design a web site, and it displaying this error " Saver Disabled" any time that i try to run the programm , pls what is d couse of this problem and how can i solve it. am using SQL Server …  |
| | hello, I have a table with int Primary key. Is there a way to set identity property on this field w/o dropping/recreating the table? Thank you. |
| | Hi, I've run into a situation where I can not see how to write efficient code to perform a check that I need to do. I am running on MSSQL 2005 The check is to compare a varchar passed in to the stored procedure against the words in a table. … |
| | Hai, I need to read the Foxpro(dbf) file, and execute that file in MSSQL through Java code. That means Migrate the Foxpro dump file into MSSQL. Also i am using the Struts Tags for create new application. But the Tag was not working. I am using the following code for … |
| | [COLOR=#0000ff]UPDATE[/COLOR][COLOR=#000000] table1 [/COLOR] [COLOR=#0000ff]SET[/COLOR][COLOR=#000000] ID[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000][DESC] [/COLOR][COLOR=#808080]=[/COLOR][COLOR=#000000] [/COLOR] [COLOR=#808080]([/COLOR][COLOR=#000000] [/COLOR][COLOR=#0000ff]SELECT[/COLOR][COLOR=#000000] ID[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000][DESC][/COLOR] [COLOR=#0000ff]FROM[/COLOR][COLOR=#000000] tmptable[/COLOR] [COLOR=#0000ff]WHERE[/COLOR][COLOR=#000000] tmptable[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]ID_SUN [/COLOR][COLOR=#808080]=[/COLOR][COLOR=#000000] table1[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]ID_SUN[/COLOR][COLOR=#808080])[/COLOR][COLOR=#000000] [/COLOR] [COLOR=#0000ff]WHERE[/COLOR][COLOR=#000000] [/COLOR][COLOR=#808080]EXISTS [/COLOR][COLOR=#808080]([/COLOR] [COLOR=#0000ff]SELECT[/COLOR] ID[COLOR=#808080],[/COLOR][DESC] [COLOR=#0000ff]FROM[/COLOR] tmptable [COLOR=#0000ff]WHERE[/COLOR] tmptable[COLOR=#808080].[/COLOR]ID_SUN [COLOR=#808080]=[/COLOR] [Table1][COLOR=#808080].[/COLOR]ID_SUN[COLOR=#808080])[/COLOR] [COLOR=#808080]I tired this but i coudn't uptade tow columns at once[/COLOR] [COLOR=#808080]do i need to seperate them or i have any mistake? … |
| | Asset Table +-------+---------+-----------+ | Date | Asset | Value | +-------+---------+-----------+ |1/1/07 |Building | $1000 | |1/2/01 |Computer | $ 500 | |2/1/07 | Fax | $ 100 | +-------+--------+------------+ Result Table I would Like; +-------+---------------+ | Month | Total Asset | +-------+---------------+ | 1 | $1500 | | 2 … |
| | hi..good day to all i have a table: Question atttributes: SurveyID(FK),QuestionID(PK),QuestionNum,Question and QuestionTypeID if i have a dropdown list specifying the list of QuestionNum in my ASPX page and a delete button besides the list, how can i delete one QuestionNum? after delete, how can i shift the Question Number … |
 | Hello everyone! [COLOR=#000000]I ‘m new to SQL Server 2000... [/COLOR] [COLOR=#000000]My industrial supervisor wants me to study about the best practices for database maintenance. I’m not sure about the content of my project. Could anyone give me some guidelines…? [/COLOR] [COLOR=#000000]Thank you[/COLOR] |
| | Hi I am new to SQL and I am trying to connect to mssql server via vb.net with a code someone else has done. I am not sure why it won't connect. part of the code is below: _DBConnection = New SqlConnection '(ConnectionString) _DBConnection.ConnectionString = "Server=MASTEC;Database=CHH_Cardboard_DA_new;User ID=sa;Password=xxxx;Trusted_Connection=False" _DBConnection.Open() when I … |
| | Hi Everybody, I am a newb in SQL Server 2000. I have a genuine question. Actually what is the use of this sql server, just to store information/datas of small size??? that is: Name: Anish Age:22 Sex: Male in this format?? Maybe this question arises in my mind due to … |
| | Hi, I need to export data from two seperate tables in database to the same sheet in excel. ie, the data from the tables should appear one below the other in the same sheet of excel. Could any one tell me how this can be made possible.Also could any one …  |
| | I cant call : [111.111.111.1].Database.dbo.fn_test(@test) (Not working !) but i can call : Database.dbo.fn_test(@test) why ? and if no way to call this, can i populate in a function a TABLE variable using a Stored Procedure to do this ? CREATE FUNCTION fn_test(@idcode int,@idoper int) RETURNS TABLE AS RETURN (EXEC … |
| | I don't think I necessarily have a virus but I thought if anyone could point me in the right direction someone here could. I have an Acer AL1912 with a Nvdia GFORCEMX440 graphic card (I think I spelled that right) I know the PC came with a built in video … |
| | I have an Acer AL1912 with a Nvdia GFORCEMX440 graphic card (I think I spelled that right) I know the PC came with a built in video display on the motherboard but its been bypassed in favor of this one. Unfortunately most times when I boot the display is way … |
| | Hi All, I have a question and I hope you guys can help me out. If you have worked with php-mysql, you might have noticed that there is a featured to encrypt a password while inserting it in the database using the password() function. I am looking for a similar …  |
| | hi friends........ I have created a database in a web server.... i have the server ip address .... and also i have the control pannel acces fot for tat particular server.... but how i will acces tat particular location using my sql server please help me...... |
| | Hi all i have 2 DBs: Energy & Users [U]Users:[/U] -id (pk) -nick [U]Energy:[/U] -id (pk) -title -userid (fk) -dateposted Description of workflow: there are a number of titles in "Energy", and each user has more than 1 titles. I would like to display Users's Nick, and LATEST TITLE (which … |
| | hai all i am undertaking a project of sending sms to mobile phone using sql server 2005,pls guide me how to do that,[COLOR=red]this is urgent please:'( [/COLOR] |
 | I'm on windows Media center, Acer Apsire 5610 laptop. [URL]http://www.daniweb.com/techtalkforums/post351945.html#post351945[/URL] /\ ranadonly shutting off/specs of laptop now since last thursday( i think) i've got the "Invalid License ID" pop up for "monitor" whenever i log on. (attached image) logged ontoday and boom restarted with no warning. Scanned files on start … |
| | hi.. i've created a table named :Survey [code]CREATE TABLE [dbo].[Survey] ( [CustomerID] [int] NOT NULL , [SurveyID] [int] IDENTITY (1, 1) NOT NULL , [SurveyTitle] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [SurveyDescription] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [DateCreated] AS (getdate()) , [coverletter] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL … |
| | i want to connect to a sql server db using a sql login from VB.NET. the problem is that i cannot fill my dataset when i login using the sql login. However, the code works perfectly well from a windows login. ALSO i can login well using the sql server … |
| | hi.. i'm having a table called "Survey". Whenever user create survey, it will store the date and time the survey was created. [code] CREATE TABLE [dbo].[Survey] ( [CustomerID] [int] NOT NULL , [SurveyID] [int] IDENTITY (1, 1) NOT NULL , [SurveyTitle] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [SurveyDescription] [varchar] … |
| | Hello, hopefully you can please help me. I've been tasked to upgrade an old system and there's many different versions of VB code that uses MDAC to talk to MSSql. Version 1 of the program is: [code] Public cnxEventLog As New ADODB.Connection (defined globally) <code in a procedure follows> If … |
| | I have a populated table and would like to store a link in a field. I am populating an html table from the table and want the value of the field to be a clickable link....is this possible? :-/  |
The End.