6,934 Topics
 | |
| | Hi all i have been dancing around this problem for a couple of weeks now and have not got any closer. Description: i have created a crystal report in SQL5 and exported it fine but now i have gone to open it in visual studio 2008 and it does not … |
| | Hi I want to convert Sql Server Database to Access Database , I have one database and it has different tables and view also. please help me how to do this ? |
| | Hi............ How can i pass and access the array variable in Stored Procedures  |
| | Hello all, I’m getting one strange error on my web. The web was developed with spring and has a tomcat pool connection configured for Oracle DB. After upload the web content into the server, when restarting the server and trying to open the web page, first time display error: [ICODE] … |
| | I'm having a really hard time trying to figure out how to make the following search: "Find the sellers specialized in selling cars of the year (They can only sell cars produced during a specific year, example 2010). The tables I have are: Seller: {[U]Seller_Id[/U], Name, City_Residence} Business: {[U]Car_Id,Seller_Id[/U],Year_car_Produced, Business_Date, … |
| | Hi there, how can i create an executable so that anybody can install in their own computer? I want to create from visual studio C#. please give me a tutorial or something, i did some but it didn't work properly please help guide in this thanx  |
 | Hi, I need a little help importing an XML file into sqlserver 2008. I followed this example [url]http://www.sql-server-performance.com/articles/dba/Loading_XML_data_into_SQL_Server_2008_p1.aspx[/url] (make sure you goto the rest of the pages in the article!) , generated the schema etc., but I can't get the import to do what I need. I was able to … |
| | SQL 2008 database disappeared after canceling copy Hi All, We have an SQL 2008 database of around 12GB. I was trying to create a copy of the database through the Microsoft SQL Management Server Studio. The server is in production mode, and it was taking too long to copy, and …  |
| | [CODE] Create table Cameras (CameraID varchar (35), CheckOutDate varchar(10), ReturnDate varchar(10), primary key(CameraID), foreign key(CameraId) references History(CameraID)); Create table Borrowers (PsuID int not null, BorrowerName varchar(30), Email varchar(50), Telephone varchar(12), ReasonUse varchar(200), primary key(PsuID), foreign key(PsuID) references History(PsuID)); Create table History (PsuID int not null, CameraID varchar (35), BorrowedFrequency int, … |
| | I want to get the list of items from a database as a Java resultset. When I use the following SQL statement it works perfectly fine [CODE]SELECT First_Name FROM dbo.Names where First_Name LIKE 'A%';[/CODE] However when I pass it as a parameter, it does not work I have tried a … |
| | I can find a lot of information about the concepts of normalization, but I don't really see documentation for how to actually bring a table, for example, from first normal form to second normal form. I'm using SQLite through Python to automate some data processing, and I have three input … |
| | [CODE]select PREMISEADDRESS1 from PREMISE PREM inner join STATUS ST on PREM.LOCATIONID = ST.LOCATIONID inner join SUPPLIES SUP on ST.STOPID = SUP.STOPID where SUP.ITEMID [COLOR="Red"]=[/COLOR] (select count(ITEMID)[COLOR="Red"] > [/COLOR]10) from SUPPLIES) [/CODE] Hello, I do not use SQL all that often but I would like to view all of the premisesaddresses …  |
| | Buddy , i have problem in to combine sql with c++ plzzz any one help for this issue hurry friends i have a library project to combine it with database. hellppppppppppp meeeeeeeeeeeeeeeee............. |
| | i found this code to upload a file into a sql database using the asp.net fileupload object (or vb) i found it here [url]http://forums.asp.net/p/1480079/3451771.aspx[/url] i think it works, but i am a learning noob and have a question...where does my dbase info go in the code? [CODE] 1. If FleUpload.HasFile …  |
| | java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.[CODE] String id= t1.getText(); int c1=Integer.parseInt(rc1.getText()); /* rc1 is a radiobutton */ statementobj.executeUpdate("Update tablename(fieldvalue) values('"+c1+"')where ID='"+id+"'"); [/CODE] |
| | Hi guys, I've started learning SQL after spending several years in the industry. I've got a table defined ... [code] CREATE TABLE [dbo].[Computer]( [Id] [int] NOT NULL, [Name] [nchar](10) NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS …  |
| | Hi. I've been looking for a code, and found something, edited it a little bit and came up with nothing, so here's the original version of it: [CODE] <?php $dbLink = new mysqli('localhost', 'usr', 'pwd', 'dbName'); if(mysqli_connect_errno()) { die('Failed to connect to MySQL: ' . mysqli_connect_error()); } $sql = "SELECT … |
| | How can I use SQL Statements in VB 6 with DataEnvironment. I have a DataEnvironment called Table(DataEnvironment2.Dsr) and a report named rptStudMastOne(rptStudMastOne.Dsr). I am planning to use the SQL Statement " SELECT * FROM Student WHERE StdSSN = txtStdSSN " and it will show in the report the record that …  |
| | hi i'm having a problem regarding sql deleteCommand.. can someone please help me solve this problem coz it takes a lot of time for me to figure it out.. here's my code [CODE] Private Sub btnDeleteBC_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDeleteBC.Click If MessageBox.Show("Do you really want … |
| | I'm having trouble getting some data from a combobox. I have a series of comboboxes that populate as you make selections from the boxes. Each combobox is using data that is pulled from a SQL database into a dataset. This all works. When I get to the last box, I … |
| | I found this great article, [url]http://www.singingeels.com/Articles/Understanding_SQL_Many_to_Many_Relationships.aspx[/url], and really helps me a lot. But there's a method that I don't know how to do especially that i find myself still a newbie. From the said article, there's a method that " the customer service rep would enter a record into the … |
| | Hi, I am vee and I am trying to create a Natural Language search engine based on LSI. I am stuck up and I would be really glad if I could use some help. I have a two-dimensional array which is full of numbers. I want to transfer the contents … |
 | i find it difficult to add mssql dbs to asp.net website when i am using vs2008. here i intend working locally. please let someone help me.  |
 | I tried asking this at the MSDN website and didn't get an answer at all...I was hoping someone here could help. If I indicate that SQL Server Express is to be a pre-requisite for my application, how does the installer interpret this? For example: If end user A already has … |
| | Sup guys, I got another "little" thing here , i am trying to create a preprocessor macros for SQL language , so when the compiler run into things like SQL key words : for example : COLUMN(title) TYPE(string), COLUMN(author) TYPE(string), COLUMN(copies) TYPE(int), it automatically will generate appropriate C++ code ( … |
| | Hi Experts, I have a windows service running every minute and has many database operations to perform. It runs perfectly for many days, sometimes it suddenly stops and throws this exception. Later when we start to debug it, the exceptions goes off, but if we don't debug, the exception continues … |
| | $sql = "UPDATE USERS SET password='changed password' WHERE login = steve"; header( 'Location: [url]http://steveworld.000space.com/prof.php[/url]' ); this is my code, im trying to allow users to change their passwords at anytime, I put in a set text and it still doesnt work, it is very agitating! |
| | [FONT=Courier New]I have been told that views in MS SQL aren’t very good to use. Let’s say that you have a view X with 2 columns Car and Color that looks like this Car Color ----- ------ Alfa Yellow Volvo Yellow Volvo Blue Ford Yellow Ford Blue If you then …  |
| | Hello everyone! I'm wondering if there is a way to assign the values of a column in SQL as the key name in a multidimensional array. Here is what I have, my database looks like this: Table Name = SJCFPCB date | totalin | cdulep | icu | ----------------------------------- 2011-01-27 … |
| | Hey everyone! Im hoping to find someone that can help me with a problem that I cant seem to resolve and it's driving me crazy! Basically I am trying to create a child management system for a nurse using vb.net and SQL as my backend db The application consists of … |
| | Hello, I'm new to vb.net. I have successfully run a simple sql query in vb.net and basically wanted to know how I can export the results from the query to a .txt file? All I really know is that I should be using StreamWriter. Does anyone have suggestions for sending, … |
| | Hi All, I have a problem and I dont understand what's happening, because my method usually works. I am querying a bunch of records from a database given a foreign key id. See code as follows [CODE] $castQuery = "SELECT * FROM cast WHERE production_id = '$newID' "; $cresult = … |
| | in my application i show database table in a datagridview , now i want to modify and change some records and save this changes on database , how can i do this ? thanks |
| | I have SQL Server 2008 Developer installed in my machine. The thing is that I have this database backup with version 10.50.1600, SQL Server Developer 2008 SP2 has version 10.00.4000. Well, I know there is not an easy workaround or conversion, so I thought well, what If I installed the … |
| | I can't insert values into a table using a stored procedure because the fields are of data type MONEY. First, is the data type CURRENCY the same as data type MONEY? Right now, I am currently using the integer value of adCurrency for the data type parameter of the createparameter … |
| | hi.. i'm using ssrs 2008 enterprice edition.. i want to send a report as email.. to my gmail address.. i want to schedule a report so that it can deliver daily to my gmail address.. how to send the report to my gmail address.. i dont know anything about smtp … |
| | I have a form set up and on that form is a DataGridView, on that DataGridView I would like to display all of a customer's transactions. I am having a problem where the debugger is throwing me a "Syntax error in JOIN operation." and I can't proceed. [CODE] ' Select … |
| | Hi there, I have a question in EncryptByPassPhrase. I am trying to encrypt the source column in the database table PForm. When I run the code it sasys, “Failed to convert parameter value from a String to a Byte[].” the SourcePath column in the database is varBinary(256) type. What is … |
| | i'm trying to make a login form connected to an sql server database. my data base has records like this: fname - lname - minit each name in a separate column, and i wanted to use the name as the login username, so in the dataset designer i made a … |
| | Hello! I just want to ask how can I save the value of my first column of my listview to sql? I'm using OLEDB by the way. Thank you very much! God Bless. :D |
 | [CODE]Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\reg.php on line 3 [/CODE] it just comes up with that and this is the only code i have [CODE]<?php session_start(); mssql_connect("Philip-Pc\DRAGONICA", "sa", "123456"); ?>[/CODE] any ideas? |
 | I am using VB 2008 and have a datetime picker. I wam trying to use this value in an INSERT command to load in to a table but I just can't get it to work. I debug it out which shows something along the lines of "24/03/2010" but it just … |
| | Could anyone point me into the right direction on how to make a C# SQL Datalogin? |
 | Hi Everyone, I have a form with multiple tabs that allows the user to insert data into a customer table. The ID is an Identity column. After a row is inserted into the database I would like to retrieve the ID number for that row that was just inserted into … |
| | When i'm trying to create a new SQL Server Database in VB.NET 2005 through Server Explorer i'm getting following error (no matter what authentication i select): [COLOR="Red"]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the … |
| | Hi! I am creating an entrance examination and what I want to do is get all the questions which belong to the same Year Level (e.g.first year) from a table and display the first question into a rich text box and when the next button is clicked, the second row … |
| | What is difference between SQL,MYSQL, and MS-SQL? |
| | I have a small company Database that tracks our repair orders. I have a query that I would like to execute based on criteria that the user inputs. I am new to VBA so most of my code is based on google research. I took a technique of wrapping my … |
| | Daer Freinds Kindly help me about generating crystal report through LINQ TO SQL query |
| | I am trying to have a search bar where user will input a string ($var) which after i will search that sting in the field named: "itemname". i will search all the different tables in the database and create a new temporary database named: searchtable. seachtable should contain all the … |
The End.