[sql-server] Forum Topics

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'm trying to create a table but I keep getting errors: Here are the errors: mysql> source Tables3.sql; Database changed ERROR 1064 (42000): 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 ')' at …

Hi, i have develop an window application using **VB.NET** and** SQL SERVER2008R2**.I have Sql server2008R2 installed on my system containing sql database file.I have my connectionstring in app.config file as:- <appSettings> <add key="mycon" value="Data Source=My-pc;Initial Catalog=MovieCatalog;User ID=sa;Password=pwd123" /> <add key="ClientSettingsProvider.ServiceUri" value="" /> </appSettings> Now what i want to do is …

i am not able to connect to the sql server on my system. SqlConnection^ connection=gcnew SqlConnection(); connection->ConnectionString ="Data Source=blueboy\sqlexpress;Initial Catalog=DCV_DB;Integrated Security=SSPI;Pooling=False"; i got the string from database properties.(i have attached the same in this post) sql service is running. tcp ports are enables too.

how i can import data from access database to my database in sql server , with a check for ducplicate each time i move data i need the code in vb.net any help ?

[code] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click connetionString = ("server=192.9.200.82;database=eKalyan;user id=invite;password=invite") MessageBox.Show("connection established") sql = ("select newuniqueid,newteh_code,newpcate_cd,newplano, pen_nm,rel_cd,pen_fnm,ccate_cd,pan_code,pvillage,ppo_cd,spo_cd,start_qtr,last_qtr,bundle_typ,bundle_no,mo_srno,pen_amt,pen_comm,status,operatorcode from ekalyan.welpen") cnn = New SqlConnection(connetionString) Try cnn.Open() cmdd = New SqlCommand(sql, cnn) cmdd.ExecuteNonQuery() cnn.Close() MsgBox(" ExecuteNonQuery in SqlCommand executed !!") Catch ex As Exception MsgBox("cannot …

Hey all, I am trying to update submissions from my SQL database from an edit page via an edit link in line with the submission which captures the ID of the database entry. When I click the edit link a new page opens and it has a form to update …

I m getting the following error when trying to add a .mdf file and .log file to my account on somee.com ERROR--> "You don't have the permission to open this file, contact the file owner or a administrator to obtain permission". I need to get my database on the server …

<?php $host = "localhost"; $user = "root"; $pass = ""; $databaseName = "foresight"; $tableName = "userinfo"; $con = mysql_connect($host,$user,$pass); $dbs = mysql_select_db($databaseName, $con); $result = mysql_query("SELECT * FROM $tableName where flag != 1"); //query $email = mysql_fetch_row($result); //fetch result mysql_close( $con ); ?> <?php $connection = mysql_connect("192.232.240.245","root","causealmedus-1608"); if (!$connection) { …

Hi all , can you pls say how i able to send the email notification alert with the datas getting from Sql server 2008 using windows service . - Thanks in advance

I am about to make website, where explain my skills (if any), kind of portfolio. I'd like to make two seperate choices in menu, one for the client-side work (HTML, CSS, JS) and one for the server-side work (PHP, SQL) seperately. I thought of word "Coding" for client-side work. But …

Hi everybody!! I'm starting with asp.net and i would like to try my code online.. can you advise me some free hosting for asp.net with the possibility to use sql server? Thanks

How can I perform SQL Server backup recovery task? Please recommend solution for my query.

I want to store my databases only on RAM. I see that in MySQL server I can choose the "MEMORY" engine and the table with be stored only in the RAM. How about MS SQL Server? How can that be done there? Thank you

I've developed an application in vb 2010 and my back-end is sql server 2008. What are all the softwares i need to install in the client machine ?

i am creating a form in vb.net, the aim is to be able to insert data to the sql server from the form interface. the form's textboxes fields include Name, DateofBirth, Address, Telephone, PostalCode, Nationality, DateofRegistration Sex (ComboBox), plus two buttons names, Submit and Cancel. kindly assist with a code …

I am am experience Mainframe programmer, but new to SQL-Server & learning vb.net so I realise that this is probably very basic ... I have a DataTable called MailTypes which contains 2 Columns, the ID & the Name. I have a DataTable called Leagues which contains a lot of Columns, …

i installed PHP version5.4.3 SQL server 2008 IIS7 SQLSRV version3.0 Drupal 7 SQLSTATE[42S02]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'watchdog'. This error occurs right after the following during Drupal 7.26 installation (shown in the error report). It hangs at the start of Install Profile: Installation tasksChoose profile(done)Choose language(done)Verify …

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 …

Hi there, i need hel whit this one : i'm learning how to develop MVC but evry time that i wand to create a data base whit visual studio express 2013 i get the classic connection to DefaultConnection : Data Source=(LocalDb)\v11.0;AttachDbFilename=C:\FRANCESCO\Project\OdeToFood\OdeToFood\OdeToFood\App_Data\OdeToFoodDb.mdf;Initial Catalog=OdeToFoodDb;Integrated Security=True Ho can i set as a connection …

I have text file (attached image) i need to loop and get the values (with ellipse shape )into sql table the text file record usually started with (----)

i am given task to analyze and modify pre written large queries within small time, so please help me understanding it with times as ( SELECT t1.EmplID , t3.EmplName , min(t1.RecTime) AS InTime , max(t2.RecTime) AS [TimeOut] , t1.RecDate AS [DateVisited] FROM AtdRecord t1 INNER JOIN AtdRecord t2 ON t1.EmplID …

how to connect sql server 2000 database with multiple connections I got a sample database DB1 and DB2, the DB1 I have table A, and I got a table on DB2 B, between A and B table no direct relation thanks for the enlightenment

i almost spent 3 hours on EXISTS operation, used in SQL especially with subqueries, i got its purpose :) that's ok but what i don't get is that WHY TO USE IT ? e.g. couldn't understand this example: *TABLE STORES* storeName----Sales-------Txn_date *TABLE GEOGRAPHY* regionName----storeName SELECT SUM(Sales) FROM Store_Information WHERE EXISTS …

we should create a program that could run through two computers and the computers should be able to access 1 database for record sharing. how can we make that? we already made the system. the problem is, how can we implement this in a networked way? thanks in advance. :)

Hi Guys, I have a requirements to backtrack 2 days if the date fall as Monday. Why? We dont have any transaction from Sunday to Monday at 6:00AM that's why need to backtrack 2 days. i want to share with you my query. if you have any additional idea to …

Hi freinds i have developed a sync service by using MS sync SDK. It was working fine few days before but its not working. It does not showing any error in log. Please friends let me know if you are having useful suggestios to make the thing working. Thanks in …

Hi, I'm having some issues trying to figure out the way to find the percentage of parents with children inside my database. There is a table where all the parents are stored called XY and there is a table where all the children are listed called table Children. How would …

Ok so what i want to do is break up a string after the lenght of the string is = to 160, then i want to add a line break..but all this needs to be done in the Select...can anyone help me with this thankx in advance select case len(COD_P2_Q1) …

Hello ım writing a program that it will work with sql database. i loaded a database which name is b.sql. but i need to connection string abouth user name , pasword and where is the location of database.