2,736 Topics
| |
i want to copy data from an access database to a sql database 2008 through coding in vb.net any help ? NB : I WANT ALSO TO CHECK FOR DUPLICATES EACH I SELECT FROM ACCESS TO COPY IN SQL | |
# Heading Here # how to store the coordinates (points) of a line as x0,y0 ,x1,y1 .....xn,yn in database MS SQL. coding is in c# using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace WindowsFormsApplication6 { { List<Point> points = new List<Point>(); … | |
Not sure where else to put this, I apologise in advance if its in the wrong place. I'm trying to migrate a program from one server to the next without having to completely re-edit every configuration file. To do this, I need to enable the sql SA account, which I … | |
Good day, I need some advise. I have two database servers(primary & secondary) and both has installed the MS SQL Server 2008 r2. The idea is, the secondary server should setup as standby in case the primary servers down. How do I set it up? thanks in advance. | |
I have a bunch of insert querys running and some of them fail with a duplciate entry. I want to see a log where it says "Error: Duplicate key" and that tells me the EXACT INSERT query that fails so I can see what keys are duplicated. Thanks | |
I'm working on an application for a joint-stock company. A joint-stock company is a business entity which is owned by shareholders. Each shareholder owns the portion of the company in proportion to his or her ownership of the company's shares (certificates of ownership). This allows for the unequal ownership of … | |
hi there, i am getting this error while activity monitoring on sql server 2008 R2(SP2) and at the same time all the users application (i.e arround 200 users window user application) connected to the database in this server gets Hang and again starts functioning properly after 1 or 2 mins … | |
Hello, I have my password column with varchar(50) datatype. now i have created a new column NewPassword binary(16). I want to convert password varchar data to binary(16) format in NewPassword column. How can i do it? Thanks. | |
Hi guys i want to make database for payroll only but i dont know how to make structure for this suppose i want to calculate payroll every month for employees as following basic salary bonus overtime absence deduction meaning salary = basic salary +bonus+overtime-absence-deduction How i make database (ERD)Diagram for … | |
COMBINATION_ACIL contains column: id (primary) prodcode [group] alias lastupdate updateby and here is the steps when i import xml to sql DECLARE @COMBINATION_ACIL AS xml SET @COMBINATION_ACIL = ' <Product> <product> <PRODCODE>CADB</PRODCODE> <GROUP>CADB</GROUP> <ALIAS>ADB</ALIAS> </product> <product> <PRODCODE>CI50</PRODCODE> <GROUP>CI50</GROUP> <ALIAS>I50</ALIAS> </product> <product> <PRODCODE>CI80</PRODCODE> <GROUP>CI80</GROUP> <ALIAS>I80</ALIAS> </product> <product> <PRODCODE>HOSBA</PRODCODE> <GROUP>HOSB</GROUP> <ALIAS>HOSBA</ALIAS> </product> … | |
I' ve converted mssql database to mysql database (locally). I ve created a free subdomain and found a free webhoster on 000webhost.com. I m trying to import my mysql database onto the server using phpmyadmin interface but am unable to do this. I get the following error-->#1044 - Access denied … | |
Greetings, I'm having a table that I need to retrieve its data in a specific order based on a column value(s). I need to retrieve first all rows that have the value 0 in that column in ascending order (default order) then rows that have value(s) greater than 0 in … | |
I made an online application to store employees information in MS SQL,I used Disconnected model and I made my class for "DataSet configuration" and call method in it in The "Form_Load" event. This is the class public static string constr = ConfigurationManager.ConnectionStrings["cnn1"].ConnectionString; public static DataSet GetDataSet(string stored_name, string table_name, params … | |
How can I perform SQL Server backup recovery task? Please recommend solution for my query. | |
Hi I am using MSSQL ODBC Connetion for my project in PHP. I have created login form with PHP and MSSQL with ODBC Function. Can any one please help how to use SESSION to carry on to next page without get function. | |
Hallo, I get stuck when installing SQL Server 2012 : Services Account Name Password SQL Server Agent SQL Server Database Enginee SQL Server Analysis Services SQL Server Browser This Sharepoint Server connected to DCSHARE1 (Domain Controller) The problem is I do not know what to fill for Account Name & … | |
Hi, I need to save the inserted password on MSSQL as md5 encrypted one. Basicaly when the user inserts the password on the textbox, it must be encrypted before storing it on the MSSQL Database. How can I do that? This was made from DreamWeaver CS6. Thank you the code: … | |
Hello Im trying to display a label when my program starts, to check the server status.. For example if the user is successfully connected to the server it should say on the label "Connected" and if not the label should say "Not Connected" , my Database is located on a … | |
We have 2 Tables, One is Primary Table and another one is a Transaction Table. Both Tables are identical. We have to insert or update the record in Primary Table, based on Transaction Table. If a record is found identical on primary keys for Primary and Transaction Table, we would … | |
I wrote my first trigger and it giving error UES TRY GO CREATE TRIGGER cust_update ON TRY FOR UPDATE AS IF UPDATE (custno) BEGIN TRANSACTION RAISERROR('CUST NO CANNOT BE UPDATED',10,1) ROLLBACK TRANSACTION END Any idea ` | |
What is the meaning that Database management systems allow access to and storage of data independently of the interal representation of the data? what is meaning of independently of the interal representation of the data? | |
I have been attempting to crack this nut for several hours now but I cannot figure out what combination of query code is required to achieve the exact results I am looking for. I have two tables: Music and Playlists The fields for Music: ID (Primary), Track_Name, File_Path, Date_Added, Artist, … | |
Why is stored procedure is better than executing a sql query. What is meant by exeution plan | |
Hi all, I have a Windows 7 64 bit client that is running a 32 bit of software and so needs a 32 bit ODBC connection to the database. I of course ignored the Administrative Tools > ODBC manager because that will open the 64 bit and instead went to … | |
Hi Experts I don't have the least idea on how to rank (desc) the following sample ExamScores by CourseID , grouping by Level. Some help needed. gbhs Newbie Level StudentID CourseID CourseName ExamScore ScoreRank A 101 1 Math 11 A 101 2 French 3 A 101 3 English 7 A … | |
![e06bda938bd3817cedb4e3d69265b84c](/attachments/large/3/e06bda938bd3817cedb4e3d69265b84c.jpg "e06bda938bd3817cedb4e3d69265b84c") ![e06bda938bd3817cedb4e3d69265b84c](/attachments/large/3/e06bda938bd3817cedb4e3d69265b84c.jpg "e06bda938bd3817cedb4e3d69265b84c") ![e06bda938bd3817cedb4e3d69265b84c](/attachments/small/3/e06bda938bd3817cedb4e3d69265b84c.jpg "align-left") Hi, I have a below table of Content CUSTOMER ID QUESTIONS ANSWER 1 FirstName John 1 LastName William 1 Country India 1 Zip Code 60000 2 FirstName xxxx 2 LastName yyyy 2 Country US 2 Zip Code 123456 3 OrgName ABC Pvt Ltd 3 … | |
Hi.. i want to get all columns from tbl_class where course_id of tbl_course is equal to course_id of tbl_class more over course_id of tbl_course should be thw one who has semester = 5 brife structure of tables are: tbl_class >class_id >course_id >class_room tbl_course >course_id >semester i have design this kind … | |
i have written this query to show total working time and overtime of an employee on particular date (if he has came) otherwise it doesn't show record for a person if his INTIME and TIMEOUT are empty but i don't want this now, i want if for a particular date … | |
I need to add un hour to my date, how can i do??? This my code CASE WHEN candidat_rendezvous_date IS NOT NULL THEN 'candidat_rendezvous_date + 1Hour' END Thanks for your help |
The End.