3,481 Topics
 | |
| | Hi I would like to save one table's data to another table. The code that I have wrote is this: [code] con.Open(); string copyData = "INSERT INTO Changes(IP,ServerName,[Type of Server])SELECT IP,Server,Name FROM Server"; cmd = new SqlCommand(copyData, con); int returnValue = cmd.ExecuteNonQuery(); con.Close(); [/code] and it seemed working but when … |
| | Please Make For Us All Codes As File Text "*.txt" To Downloads or As Projects To Downloads Thank You For All Codes tarek-aec *** Thank You *** |
| | I am not able to establish remote connections to SQL Server 2008 enterprise edition. I have followed and implemented a lot of tutorials available. These are the things i have done: 1. enabled TCP/IP connections in SQL configuration manager. 2. added a rule to allow inbound connections at port 1433. … |
| | Hi, Im a sql novice and need some advise from all you gurus. My current environment has me running an application that uses Sql Express 2008. We have just moved into our second office and need this application to run in both offices (preferably off the same database). Old Office … |
| | Hello all Please help me as soon as possible i have one file named patients.ibd file of mysql and allready have table named patients in my schema Please hepl me how to upload data from patients.ibd to patients table please help ASAP thank you in advance  |
| | Dear all , i want to transfer the sqlserver2008 database to sap business one database/? It is possible? |
| | i m working on certain project ,i created some tables in database sql server 2005 .and it created smoothly. for examples users table .so it append it with dbo.users .till there there was no problem i can easily access its object (table,storeed procedure) .but after few days it appended table … |
| | Hi, I have two tables where both contain the ID number and Date. The first table will always have a date and the second table will never have a date. Basically I want the query to bring back a result set that if the ID is in table 1, then … |
| | Hello all, I am new to MYSQL programming, although i have been working with MSSQL for a while now. I am using delphi on a project and the query below does not return any results, just cant find what is wrong with it Select Airwaybill, SDate, BLAccount, RCountry, PackageCodeDesc, TotalWeight, … |
| | I am trying to implement merge replication locally before using it for web synchronization. My question is "Is it necessary to have two separate instances to try merge replication?" I have been through many web pages and tutorials but couldnt find a definitive answer. and if it required then is … |
 | Hi geeks, I really need your help. I want to query in a table in MS SQL using a data in another table. This might give you an idea on what I am talking about. This is the query I've constructed : "SELECT TABLE1.FIELD1,TABLE1.FIELD2 FROM TABLE1, TABLE2 WHERE TABLE1.FIELD3 = … |
| | I have a table with one record per certification a user has. So, user SMITH can have multiple records, one for DMV another for CPT and another for ICD. SMITH has three certificates but can have up to 20. The desire is to have a second table with one record … |
 | Can anyone shed any light on my errors? I got these after transferring some data around what might cause these errors? [CODE]HDB:{call sp_logitemexchange_insert(179,24,0,0,255,6,37742,1,2,1,2,0,8,0,0,0,0,0,0,0,65535,65535,0,?)} DB:01000, NativeError:3621, [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated. DB:{call log_serverstate(2,150,0,0)} DB:01000, NativeError:3621, [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.[/CODE] Thanks...  |
| | Hey there, I was wondering if I could get some guidance on how I could go about handling this problem. I'm creating a simple version control system database. The tables look like the following: [CODE]CREATE TABLE Users ( [UserID] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, FirstName VARCHAR(32) NOT NULL, MiddleInitial … |
| | Hi I am running a PHP-based intranet site where the main page has to refresh its view every minute in order to show the most up-to-date information from an MSSQL database. At any one time there are only about 20 entries that need to be shown, but the main database … |
| | Hi, As i was experimenting stored procedure's TRY-CATCH with RAISERROR, came across this issue. Would like some opinion on this. Microsoft sites documented as follows: SQL Error 0 - 10: caught in the TRY-Block, i.e. will not reach CATCH-block. SQL Error 11 - 19: caught in CATCH-Block SQL Error 20 … |
 | Hi Guys I have an application that developed using ASP.net.There is cancel option,user can select number of item code and cancel it,but there is isssue.The issue is once user select more than 200 item code to cancel then it generate the error messsage.Error message is "Time Expird or server is …  |
| | hi.. i'm trying to retrieve the data from database using ssis package.. database name is employee which contains 48 tables and it is around 20GB of memory.. it is a production database.. now what i want is to retrieve the data for each four hours.. i.e i want to execute … |
| | Hello, I am trying to do the student evaluation and stuck in this problem. Each student evaluates himself and all his friends in the same class. I have a sample table below. On the query, I tried to join the table to itself to get a new column calls "StudentID-Change" … |
| | Hello, I am newbie at ASP.net. I got stuck at a point that hopefully you can help me. I use mssql as database and fetch all my records and images from there by using <asp:SqlDataSource>. I also use [CODE]<asp:Repeater>[/CODE] to show data at every iteration. After fetching data from database, … |
| | is there any function in PHP that can access my MsSQL Server...??? Note : All my Script was in Store Procedure |
| | For example, my query is something like: [CODE] SELECT fullName = firstName + ' ' + middleName + ' ' + lastName, streetAddress = address1 FROM Person [/CODE] How would I be able to reference fullName directly without having to type out first+middle+last again? If I just added "WHERE fullName … |
| | Hi there, I was really hoping I could find a person which could help me with my server setup to get it fully working for ASP.NET web applications under Win 7 Untimate (32bit). I'm trying hard to setup but I still can't get into the database file. I want to … |
| | I have a table with roughly 50,000 records. Each record has 25 or so columns. One of which is a phone number column. Some of these records, while most not not the same in any other way (a few are identical), have the same phone number. Id like to delte … |
| | Hello, I need help transforming a current script into on that can loop through some data for me. As you can see I currently have the ItemName and Address commented out "-- Set @ItemName = '95B046125' Set @Address = '195 WELLESLEY ST E'" and then I have to uncomment it … |
| | hi , i have a field in a table with the datatype as datetime. i wrote a query to get that feild but the thing is i want only the date to be displayed, how can i do that, currently the date and the time is being is displayed, how … |
| | Hi All, I am new to sql and also this is my first post in this THREAD, Inline with this I am going to improve knowledge on sql, so below is my query which i desperately needed and don't know it is possible or not? I've Two table Table1: ProblemGroup … |
| | Hi everyone... this is my first post... so I would be quite descriptive I am working on a Web App which is a Helpdesk Solution and is based on PHP and interacts with MySQL, MSSQL, Oracle, Postgres SQL... we also support Linux based and Windows based installation... There is quite … |
| | I have an xml file, structure like so: [CODE] <people> <person.1> <fname>brian</fname> <lname>smith</lname> </person.1> <person.11> <fname>joe</fname> <lname>carey</lname> </person.11> </people> [/CODE] I am using openxml to read this file and insert names (and other person information) into a table. [CODE] DECLARE @person xml, @idoc int EXEC sp_xml_preparedocument @idoc OUTPUT, @person INSERT … |
| | Hi I'm trying to query the following tables to find out the Resource Companyname and Project Title for any Recruiters who have worked on more than/less than 6 projects within a specified period. These are the tables: dbo.tblResources ResourceID Company Name dbo.tblRecruiters RecruiterID ResourceID dbo.tblProjects ProjectID Datecreated dbo.tblProfiles ProfileID ProjectID … |
| | Hi everyone... I am developing this student management system which has one form that saves student data( including student image). Now w.r.t saving student image I want that the user should insert image from the folder where he has saved student images. On the save button the image path of … |
| | Ok, so I've been looking all over the web to try and solve my problem... I have an SQL 2005 database on a web server which displays information to customers via an asp.net web site which also offers interaction with the data. I also have a Windows .Net application which … |
| | is there any code that is the same as the distinct function of mysql to mssql? thanks in advance..^^ |
| | Hello Is there a querry to convert a whole column into MD5 but i only need the first 19 characters of the MD5 thanks |
| | Hello Dani Webbers, So I've been given this old-as-hell database, it was designed in 1993 under pick, and it isn't at all normalized, in a good effort I've migrated all the data into MSSQL 2008 server and I have some several to several relations between tables, on of these relations … |
| | As the title goes how can i transfer a table from one DB to another but first i need to delete the table1 from DB1 coz table2 from DB2 has the same name as table1... |
| | hi there, i have a question in giving access to separate table to users. i have a database call Admin and in that there are some tables that the one user should not aloowed in viewing, how can i restric that user in avoing looking at that table i am … |
| | Hi everyone, I have one problem that i couldn't solve. I'm developing a Web Application. Everyday many user's logg in and work... So, they logg in to my web app. through their MSSQL username and userpassword. HERE, I want MSSQL to deny access when they open their mssql and logg … |
| | |
| | How to save listview data to database? Not work code: [CODE]private void Insertbutton_Click(object sender, EventArgs e) { string strConnection = "Data Source=OCH-ERDENE\\SQLEXPRESS;Initial Catalog=Database;Integrated Security=True; Pooling=False"; SQLiteConnection conn = new SQLiteConnection(strConnection); conn.Open(); for (int cnt = 0; cnt <= lsvXML.Items.Count; cnt++) { string query = "INSERT INTO DataObject VALUES('" + lsvXML.Items[cnt].Text … |
| | could you help me guys to translate this code from PHP MySQL to PHP ODBC. i'm having a hard time to run this page using the PHP ODBC which uses MSSQL connection. any help would be very much appreciated.. thanks in advance ^^ [CODE] <?php $return_arr = array(); $sql = … |
| | This looks pretty simple on the face of it but I can't get my head around it. I have two tables that I'm querying: dbo.tblrespondents RespondentID FirstName Surname dbo.tblrespondentschildren RespondentsChildID RespondentID ChildFirstName ChildSurname ChildDOB ChildSex I am trying to find which Respondents who have only sons - one must be …  |
| | hi, M'soft sites documented that [CODE]RECEIVE TOP (n) FROM Target[/CODE] should fetch the n number of message from the specified queue. I am having problem with this, and do not know why because not much resource is available pertaining this. Tried finding for an answer on Klaus Aschenbrenner's book, failed. … |
| | Table name = Contacts. Table attributes = first_name,last_name,email_address,other_email,address,phone,notes. I want to retrieve without repetition(DISTINCT) first_name and address. But, when retrieving these 2 data, i want all the other data(notes,last_name,etc..) associated to this the DISTINCT data to show. Is there any SQL data for this kind of situation? |
| | hi, i have a problem in login in to the MS SQL server 2008, i installed the MS SQL with the authentivcation mode as Mixed mode and and for the SQL server administrator i added the current user and for the password i gave a different password, which is not … |
| | Hi all, i'am having a problem with my sql database.I'm able to insert and retrieve data.but i couldn't able to view the data in my sql interface.all the columns are empty.so where the data being stored ? why it is not appear to the sql interface ? |
| | hi there, i have a question in connection my application to ms sql 2008. i wrote a desktop application in visual studio 2008 in the C# language. and i have installed the MS SQl 2008 DBMS software. and when i try to connect to the MS SQL in Mixed mode … |
| | Hi Everyone, I got a problem while creating a views in sql server 2005. In my database there are several tables which are accounts_transaction bill_info member_bill member_info relationship is exist between “member_info and accounts_transaction, member_info and member_bill, bill_info and member_bill” but there is not any relationship between bill_info and accounts_transaction. … |
| | I am using sql server 2008 but i just want create reports usin sql statements just sql without any other application like Visual studio is posible?? |
| | Hello, I'm using SQLBulkCopy to import data from a text file. There is a lot of data involved and I would really rather not import it row by row. There seems to be a problem with fields containing both numbers and text. (for example, a phone number '555-1212'). All fields … |
The End.