6,934 Topics
 | |
| | Hi All Developer, I am waiting for Query that will Converting full date into AM/PM with Time. only. in Sql Server. For Example: 2010-06-24 16:00:00.000 will be giving result -->04:00 PM 2010-09-24 01:00:00.000 will be giving result -->01:00 AM Wait For your Reply. Thanks. Dhimmar |
| | I just wanted to know the following things if u can just help me. I made a website in Visual Studio 2008 and used the database provided by the VS [I dont know which version is this]. That website runs successfully on the machine having visual studio[As in that i … |
| | --You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #10' at line 1--- [code] <html> <body> <form action="login.php" method="post"> <div> <table width="100%"> <tr> <td><img src="Logofinalcopy.gif"></td> </tr> <tr> <td bgcolor="aqua"><h2>Login</h2></td> </tr></table> <table align="right" …  |
| | I want to know how to transfer between two server a data table without using the SPROC for link them.  |
| | Hi There, I am using a sql query to show a row to users. The Problem is in the database there are single as well as duplicate records. My 1st code is – Works good if user has no duplicate records; [CODE] SELECT contacts.forenames, contacts.surname, addresses.postcode, contacts.contact_number FROM contacts LEFT … |
| | Hi everybody.. i've created one SSRS in that i've connected to the database having four fields.. now want i want is to calculate the salary page by page and at the last grand total.. i've kept one extra column in table and kept one running field and made it as … |
| | hi All, I am new to this and first time doing this kind of work. i have created a web site in visual studio 2008 with database provided by the visual studio. Now i have that database but i have to deploy that website and use database as sql server … |
| | I'm totally new to this, as will be evident, and I can't figure out the syntax for what should be the most basic code. I'm just trying to get a piece of data from a SQL database and store it in a variable. From various book and websites, I cobbled … |
| | this should connect my datacontext to the new connection string but for some reason it does not work not sure is there a better was to do this. This is a WCF service also. [CODE] dim db as new theradatacontext Public Function connect_db(ByVal server As String) As Boolean Implements IKattservice.connect_db … |
| | Hi, I am working on querying a specific value from my xml file. Below is what I have so far. When running the entire script I get the error "Incorrect syntax near 'varchar'". Thanks -- Declarations needed to run sp_xml_preparedocument. This will create XML image. Declare @idoc int Declare @doc … |
| | my code is inserting the wrong date into my database my insert statement is: [code=vb] "insert into claims (claim_id, claim_amount, claim_date,claim_desc, emp_id) values (" & CInt(clm_id) & "," CInt(clm_amt) & "," & Date.Today & ", '" & CStr(clm_desc) & "', " & CInt(emp_id) & ")"; [/code] in the table itself …  |
| | hi, Am having a problem Inserting into SQL 2008 database using stored procedure from a php webpage. My Stored Procedure is: [code=text] Create PROCEDURE [dbo].[udp_AddContact_Insert] @Contact_ID int, @Client_ID int, @STD varchar(10), @Tel varchar(20), @Mobile varchar(20), @EmailAddress varchar(100), @FirstName varchar(20), @LastName varchar(20), @Title_ID int, @Position_ID int, @User_ID int, @SourceURL varchar(1000), @PositionText … |
| | can anyone tell me whether i can access databases using c++ i want to connect to ms sql in in c++ program. i hve to create tables in MSSQL using data available in c++ program. very urgent thanks geeta |
| | hello guys i have a question bout my sql. I create a system in vb.net using my sql database but the problem when i create a report using microsoft report viewer it does not detect mysql database whether i create a new connection..what is the problem??.. |
| | I have no problem connecting to database, and the form is okay i guess. ¿Do anybody see the problem in here? It keeps returning me ERROR! PHP code: [code=php] <?php mysql_connect("$host", "$mysql_user", "$mysql_pass")or die("Error connecting."); mysql_select_db(users)or die("Can't access to database."); if($id) { $sql = 'UPDATE members SET '; $sql .= … |
| | For an ER diagram, I have to: 1. Produce a set of relations. Indicate all primary and foreign keys. 2. For each relation give the minimal basis for all FDs on the relation, and state whether the relation is in 3NF or BCNF and why. I am fine with doing … |
 | Hi There! I'm Seeking for a Function by which I can Execute mySQL Queries for any table. |
| | Hi all, I am trying to get a SQL Server statement to work for a class I am taking on MS SQL Server. Here is what I am supposed to do; 1) Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record …  |
| | Hi, I'm trying to create a Web Form in C# - the form has a username and password textbox. The user enters there username and password which I want the program to check if it exists in the SQL database. I'm trying to create a login.cs class and then run … |
| | Good evening, I'm trying to generate an xml file based upon the result of an SQL query. I'm making some good progress so far but there is 2 problems I can seem to solve. My php code is the following: [CODE]<?php require ("Connection.php"); $db_handle = mysql_connect($server, $user_name, $password); //load the … |
| | HI, pls help me in this.. How to import Excel Sheet data into SQL Server 2008.? i use Excel 2010. SQL Server 2008. how to import data? thanks in advance. jack |
| | Hi all, I'm currently working on a holidays database where i need to retrieve the latest offers and display them. I've managed to get that working fine. However what i want to be able to do is kinda like a SELECT DISTINCT to only show 1 destination, and have the … |
| | Hi There, I do have 2 tables; Contacts table, Communications table Contacts table rows are; contact_number, forename, surname Communications table rows are; contact_number, number (number is used for emails) What I have is a little form to check/find out the contact number by filling; surname forename and email. Once they … |
| | Hi All, I am working on a booking system for vacation rental properties. I have two (simplified) tables properties and propertyAvailability: properties:- propID propName propertyAvailability:- propID dayOfTheYear availabilityStatus Rather than use dates for the bookings I convert everything to dayOfTheYear (using ColdFusion) and each DOTY for each property has a … |
| | Hi, i just want to ask why this error mean? InvalidOperationException was unhandled by user code The provider could not determine the String value. For example, the row was just created, the default for the String column was not available, and the consumer had not yet set a new String … |
| | So I have one page that basically reads the entries I have from my table and out puts them with a link around the date so that when clicked your supposed to be able to delete it. Problem is when I click the link nothing happens. Heres the code for …  |
| | So I'm trying to have a relatively simple script. I want to just have one entry in the SQL table and when new information is entered just overwrite that same entry. For the table I have the primary key as the variable ID. I'm not sure how to just extract …  |
| | There is an a problem on declaring variables on MYSQL stored procedure.The code I used I used is shown below. [CODE]DELIMITER $$ CREATE /*[DEFINER = { user | CURRENT_USER }]*/ PROCEDURE `emp`.`third_SP`() /*LANGUAGE SQL | [NOT] DETERMINISTIC | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES … |
| | The title is pretty much self-explanatory. I need to create a simple asp.net web app which will read a delimited text file and then update an existing SQL table with the content of the file. The program does not even have to display any results really.. Just to update the … |
| | I am currently wanting to know how to find out two different dates from a list of dates for each customer. I can find out the first date for each customer but I need to know their 6 month and 1 year visit. But the problem is not all the …  |
| | hi all, I am very new to rdbms. I am using window7 os. how can i use sql in my system (sql *plus oracle). please help me where i can download this and all the pre-requisites for using it in my laptop. thanks in advance. |
| | Hello, I've been working on this for three days now and I can't seem to get my listbox to populate...please help. I'm connecting to an sql database. Where am I going wrong? [code] Dim cmd As New SqlCommand("SELECT DISTINCT natureport FROM rates ORDER BY natureport", conn) Dim da As SqlDataReader … |
| | Hi everyone, I'm a bit of a noob on the forum so please correct me if this is posted in the wrong area/or post is incorrect. I'm currently working on a new website ([URL="http://www.worldwidemixtapes.com"]http://www.worldwidemixtapes.com[/URL]) and currently stuck on the "sort by" section at the top of the page. What I'm … |
| | Hi, I have the following problem: I want to update the column "UPDATE_VALUE" of table A with values from the column "SOURCE_VALUE" from another table B. Both tables have a timestamp column, and the value that should be updated in table A should be the one of the row of … |
| | hey, i want to create trigger on delete operation of table say t1...and i want to delete entries from another table say t2 which are related to removed entry in t1....so i tried to create another trigger on delete operation of t2 to store entries from t2.. here is the …  |
| | Hello, i have created two tables account1 and log_table and tried to create trigger as follows:: create or replace trigger acc_history after update of balance ON account1 for each row begin insert into log_table values(:old.c_name,:old.balance,:old.acc_no,:new.balance,timestamp); end; but its giving errors such as:: SQL> show errors; Errors for TRIGGER ACC_HISTORY: LINE/COL … |
| | Hi I am using a list view to view the data between two selected dates i have two ways: 1. [code] "select * from mytable where mydate between '" + fromdate + "' and '" + todate + "'"; [/code] 2. [code] "select * from mytable where mydate >= '" … |
| | i have this code but it cant work in my hosting usualy the error is : The following errors were reported: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''comments' ( 'id' int … |
| | sir,i i have two date columns today_date and doj_date.both of them are varchar data type.now i want to update today_date='01/06/2010' to '01/04/2010' where doj_date='01/04/2010'.that means only the month column. ihave used the following code update installment_scheme_customer set substring(today_date,4,2)='04' where substring(today_date,4,2)='06' and substring(doj_date,4,2)='04' . but it is showing error like this … |
| | Set up my database through the wizard and copied the connection string it presented to me. But am having problems connecting to the actual DB. Error quoted below. Am I missing out on something? [CODE] Private Sub btnDB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDB.Click Dim strConnect As … |
 | I have a project that can potentially use a SQL server as a host for it's data. When a user starts the application for the first time, a wizard walks them through selecting how to store their data. If a user selects the SQL option and indicates that the database … |
| | My problem is that when this executes the results come up as a query in the text box and not the result. Is there a way that this can be converted? The idea is to select a name within the combobox and this should update the 3 textboxes with the … |
| | i'm new in database . now need to work on it . if somebody has good MS SQL ref book or link, pls let me know. any teaching website or something would appreciate. Many thanks |
| | I got a sql injection hack that put this after each description in my database. <script src="http://b.adserv.cn/E/J.JS"></script><script src="http://b.rtbn2.cn/E/J.JS"></script> any idea how to remove it without deleting the descrition? Here is what I have HIM PORTRAIT SHIRT<script src="http://b.adserv.cn/E/J.JS"></script><script src="http://b.rtbn2.cn/E/J.JS"></script> Here is what I need HIM PORTRAIT SHIRT 3000 items / rows … |
| | Hi There, I do have an sql query to update and insert row into database which I use it within a form. Problem is ; This sql query works good in one form but in other one it does not at all(same query different form), looks like it is blocked … |
| | I recently discovered the power of Linq To SQL and decided to implement it into a control that I am working on right now. So far it is making life much easier but I have ran into a small stumbling block here and need the experts assistance. I have a … |
| | How Would i connect my C programe With SQL PLUS ???????/ IS there any header file i hv 2 study???? or any other solution??? i want 2 make a program which is user friendly who dont know the SQL bt by this programe they can easily manage the database..... plz …  |
| | I have a table in SQL Server with the following structure: DateRated, Parameter, Rating, UserID Sample Data DateRated Parameter Rating UserID 10/01/2010 Flexibility Good User101 10/01/2010 Efficiency Average User101 10/01/2010 Value For Money Below Average User101 I want to create a query that will make it like this: DateRated Flexibility … |
| | hello guys...I want to learn the above mentioned topic. Can you suggesst some book or forum to learn this?? thanx  |
| | Have you ever forgot or lost your SQL Server sa password? Did you hava any ideals to reset your lost sa password? Or choosed to reinstall MS SQL Server on your PC again? I once forgot my SQL sa password and I reinstalled SQL Server at last, because I failed … |
The End.