9,022 Topics
Hi Everyone, Is there any in built debugger tool present in SQL Server for PL/SQL programs? Or can we configure a new debugger tool like SQL*Debug for Oracle? I need your help for this. waiting for your reply
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 …
This is my code.Here Instead of query string can i use view. plz reply me. Protected Sub btnchk_name_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnchk_name.Click Dim str As String = "select ID from table1 where ID = '" & txtid.Text & "'" Dim con As String = ConfigurationManager.AppSettings("preeconn") …
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 …
Hi There, I am very very new to C#. I need to create a Windows Service, which should check my sql server database for every 30 seconds, and it should do some calculations on some table and insert them in some other table. I have the C# code to do …
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 …
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 …
Is it possible to create a desktop icon (as in VB), for my application, so that users can access the form from their desktop to make complaints? I am using PHP with MS SQL. Please Help! Thanks in Advance!
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 …
hi all, recently ran into a really hard problem for me: i have an sql command with something like this SELECT xxxxx FROM xxxxxx WHERE filter LIKE '[A]' what i would like to do is substitute [ with [[] on the condition that it is after a LIKE and is …
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 …
Hey, I have a quick java question. I am building a Java application that uses an SQL database. I was wondering if it was possible to have this desktop application use the internet to connect to an SQL database setup on a remote server? This way the program data would …
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. …
I'm tring to display an encrypted number store in sql database I have a key store in my application.cfm. and they number in my database is encrypted. My display code looks like this [CODE]<cfloop query="Get_Orders"> <cfoutput> <tr> <td><div class="content_black">#Get_Orders.Credit_Card_Type# </div></td> <cfset key = #application.key#> <cfset Cardnum = '#Get_Orders.Credit_Card_Number#'> <cfset CardDec = …
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 …
I have a combobx on the form and i enter the value in the combobox and then click save button and the values get stored in the sql table.but i want to display all the values in the drop down of the combobox what ever i enter during the run …
Hi We have got a single instance of SQL Server 2005. The latest service pack 3 has been installed today. Since installing SQL Server two months ago we are finding that SQL Server times out if you try to delete records from any table that has more than 600,000 records. …
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 have one window application which accesing database continously on different server. After performing operation on some number of records, it alway throws an exception (application and databse on different server) : Exception : A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: …
I am trying to figure out how to do multi-threaded and asynchronous programming in VB.NET. I am trying to write an application which has a list of .sql files (some stored procedures, some regular t-sql code). These reside in a directory and get read in and processed. The idea is …
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 …
Hi Everyone, Im using ASP.NET and SQL Server. I have Insert , delete data working well. but if i update a particular record it just all the records are updated with the same value. for example if i have 3 records with 3 different values, if i display the second …
I've a form like newform1 and a table newtbl1... in form I've a unbound checkbox "chkbx1" and in the newtbl1 i have a field name chk_stat which is a checkbox (yes/no) now i want to link this chkbx1 with the chk_stat. mean when i check/uncheck checkbox1 same thing happen in …
I have a datatable (sqltable) and a datagrid (dgData) if the user click the datagrid header the grid changes sort order but when i try to get [CODE]Dim Row As DataRow Row = sqlTable.Rows(dgData.CurrentCell.RowIndex)[/CODE] or [CODE]Dim Row As DataRow = sqlTable.Rows(e.RowIndex)[/CODE] the row returned is not the row selected in …
hi, how to retrieve data from SQL database into a combobox in Visual basic 6
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 want to add one "Save Button" on web page.I am working on ".cgi" program and using "sql server 2000" database.Datas are retrieving from the database and displayed as on html page(datas are student records (i.e) marks,grade etc).In that displayed page,i want to add "save button".By clicking save,it should …
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 …
I am using apache2triad 1.5.4. I need to use MS SQL Server 2..5 database with my php application. How do i use it and how to configure it. Please let me know ASAP. Thanks
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 , …
Does anyone know if it is possible to save a document to a SQL 2000 database image field from a .NET web form running on Windows 2000 .NET 1.1 framework. I've seen plenty of code on the internet on how to do this in Visual Studio 2005 and .NET 2.0 …
Hi, I have a transaction with , lets say, 5 INSERT/UPDATE statements with some SELECT statements in between. I am using one connection for all the update/insert statements and another connection for SELECT statements from connection pool. Is there any problem doing do? Should I use the connection intended for …
hai friends, i am writing the code for file upload .the document file is stored on the sqlserver databse. i taken the one file upload control and button. in the sqlserver i create a table and a procedure and witten the code. but it gives error at show files method …
Hello, I am very new to Visual Basic and try to teach myself again after years and years of not using it. Learned very basic codes back in school but that was too long ago. So far I have wrote only ONE application. Basic input, calculate and output. Came out …
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?
I am trying to write a script (which i have done) that sends a meeting request out from Access to users outlook. When they accept it adds that meeting to their outlook. But if a user declines it deletes that meeting out of everybodys outlook. e.g. if I send a …
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 …
i am newbie to this could anyone show me how to retrieve the data from sql server and export the data to txt file? in vb.net windows application?? i want the same row and column of data retrieve from sql server to be insert and stored in the text file …
Can I loop through the output of 2 select statements from a stored procedure based on a "order by a date" that is in the 2 different databases. For example I want to [code=sql]select * from program where cust_no = '125'[/code] Program has a field "posted" Then [code=sql]select * from …
Hi i need help on how to create a query so that the result will be like in my attach screenshot
The End.