[microsoft:sql-server] Forum Topics

Hi, I am running this line of code to insert some data into table. I am using select case on one of the data. When I run it, this error was generated: "Syntax error (missing operator) in query expression 'CASE dbo_tblFinanceApp.UPADisclosed WHEN 0 THEN 'Undisclosed' WHEN -1 THEN 'Disclosed' END' …

This is my first foray into the world of programming. I'm doing a practice project for the consulting firm I work for, and my current objective is to make my submission page textboxes insert the user input into specific tables in my database. Later I'll need to retrieve the data, …

Hello, How to save values of each and every controls to SQL database using CreateUserWizard?

hello all, i really hope you can help me. im trying to get a list of customers which are in my database to show up in a combo box but with the code i currently have, it only shows the last record that was entered [CODE]rs.MoveLast With Me.Combo1 .Clear Do …

I dont know how to link my table to the database yet i already finished connecting to the application itself. i have four fields on the form as well in the database table. that is 1.word 2.lug_trans 3.Eng_trans 4.meaning the same fields appear in the database tables. i have to …

Hi, I created a new Virtual Directory in Windows Server 2003 . But when i click Browse I'm getting this error: [B] System.Data.SqlClient.SqlException: Invalid object name 'tempdb.dbo.ASPStateTempApplications'. [/B] Can someone please help me to solve this issue. Regards, Pavan Kumar

i have a form that edits contents in a database. everything is correct to my point of view but when i try to update a path of an image it gives me an error telling me System.Data.OleDb.OleDbException was unhandled Message="Incorrect syntax near 'C:'." Source="Microsoft OLE DB Provider for SQL Server" …

I've been struggling with this for a while. It's not so much a "problem" as it is an approach. I've been working on my client/server socket program and I've reached the point in my planning (which isn't very far in) where I really need to think about how the server …

Hi everyone, I have a huge problem with importing data into Microsoft SQL server 2008. First of all I have created the database with the foreign keys etc. And now I want to import data. I have used BULK method i.e. [CODE]BULK INSERT tablename FROM 'c:\tablename.txt' WITH ( FIELDTERMINATOR = …

create table #TempRouting( id int, routetype char(4), routesequence int) insert into #TempRouting (id,routetype) values (1,'MON') insert into #TempRouting (id,routetype) values (1,'MON') insert into #TempRouting (id,routetype) values (2,'MON') insert into #TempRouting (id,routetype) values (3,'MON') insert into #TempRouting (id,routetype) values (4,'MON') insert into #TempRouting (id,routetype) values (5,'MON') insert into #TempRouting (id,routetype) values …

Please great people help me look into this from scratch. i have field definition like this: Column Name Data Type StaffID nvarchar(20) Title Varchar(20) FirstName varchar(50) SecondName varchar(50) Gender nvarcher(20) ClassTeaching nvarcher(20) PhoneNumber nvarcher(50) Level nvercher(20) Salary money Passport image Here is vb code below, and when i run it …

hi i have a datagrid view that is filled with fields from a database. until filling this datagridview it is alright. in this form i have a button delete and a textbox. when i press this button it takes the number in the field which will be the primary key …

Hello guys. I need information abaut of java conetion SQL sever 2008. Thanks

I am writing a database and need to post a value in a lable to a sql field. the sql datatype is set to money. when posting i have CMD.Parameters.addwithValue("@Claim", LBCLAIM.text) when posting i gett an error cannot convert a char vaule to money. the char vaule has incorrect syntax. …

I have a stored procedure that retrieves customer data from one table and calls 2 UDFs to perform a calculation on data obtained from joined tables for accounting data. The calculation needs to be performed for every row based on matching criteria of previous records. The query returns very few …

[CODE] import java.sql.Statement; import java.sql.Connection; import java.sql.SQLException; import java.sql.DriverManager; import java.sql.ResultSet; class db { public static void main(String arg[]) { Statement statementObj=null; Connection connectionObj=null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); connectionObj=DriverManager.getConnection("jdbc:odbc:sensorData","",""); statementObj=connectionObj.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); System.out.println("do not worry ho ga yr ho ga"); statementObj.executeUpdate("INSERT INTO hardwareData (Time, Date, humidity, Temp, DiesalLevel) VALUES('1','12','3','s','a')"); connectionObj.close(); } catch(ClassNotFoundException …

Hi. I'v created a program with a Ms SQL database, registration form and login form. Everything was working well so i detached the database and added it to my program as an existing item before so as to deploy the program. But now i recieve an error when i try …

I am using Access 2010 and have 2 tables: ORGANIZATIONS [id], [categoryID], [requirements], [address], [city], [state], [zip], [web], [person], [title], [phone], [fax], [email], [paperwork], [brochures], and [dateModified] LIST [ID] and [list] The data types are either text, number, attachment, memo, hyperlink, or date I have a form with a listbox …

Hi, I have the following data in a excel csv file: Date,Time,TempOut 3/17/2011,00:30,73.3 However, if I load it using: [CODE]ExclConn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + dir + ";" + "Extended Properties=\"text;HDR=Yes;FMT=Delimited\"";[/CODE] Then: [CODE]string Data = "SELECT * FROM [" + FileName + "]"; OleDbDataAdapter dtadpt = new OleDbDataAdapter(Data, ExclConn); …

I'm trying to run the following code but get a casting error. How can I rewrite my code to achive the same ? [CODE] boolResult= (bool?)dataReader["BOOL_FLAG"] ?? true; intResult= (int?)dataReader["INT_VALUE"] ?? 0;[/CODE] Thanks

I have 2 tables, MPW1400 LeaseRecNo PropNo BldgNo UnitNo LeaseStartDate MPW1482 LeaseRecNo EffectiveDate AnnualAmount CertNo My Objective is to get the total of 'AnnualAmount' Where MPW1400.LeaseRecNo = MPW1482.LeaseRecNo and CertNo = '1' Example: MPW1400 ------------------------------------------------------- LeaseRecNo | PropNo | BldgNo | UnitNo | LeaseStartDate ------------------------------------------------------- 12345 | RG52 | 24 …

I have a view that pulls in a field, the feild has data in the following format. A1-an987389 B21-At081l0 AA1-ath01882 how would i get the infoamtion before the "-" IE A1 B21 AA1 the size of the data before the "-" can be anything from 1 up 5 charcters i …

Hi, I have replication configured on a SQL 2008 Database. The tables involved are something like this; [INDENT]tbl.Product ProductID Int ProductName NVarchar(max) ImageID Int FK_Product_Image FOREIGN KEY(ImageID) REFERENCES tbl.Image (ImageID) tbl.Image ImageID Int Image Image[/INDENT] tbl.Product is part of a Transactional publication with updatable subscriptions. tbl.Image is part of a …

I have a program that works access 2003 and i convert tables to sql Server 2005, but the problem is that program works only on the server but does not work on client .the internal network is workgroup and system is Windows XP . what can i do to get …

Hello, I have a situation where data in a field contains CrLf characters. Code has been in place for a couple of years and many records have been affected. The question is: Should I add code to catch the CrLf characters at the field level? Should I add code to …

Hi, I currently have a table with three columns: inscription-no , photo-no , photo-url. An example of the table would be [CODE] inscription-no photo-no photo-url 8376677 1 /photos/123453.jpg 8376677 2 /photos/dfsdfg.jpg 8376677 3 /photos/w2w3ed.jpg 8376677 4 /photos/2g2r2s.jpg 2345679 1 /photos/3d43f4.jpg 2345679 2 /photos/6h3hdj.jpg 2345679 3 /photos/dfgdsw.jpg [/CODE] now I want …

Hello All, I have a very simple search cursor that is selecting from a table a list of names in order to query a database. It was working fine until I encountered a name with an apostraphe in it. O'Brien for instance. The search cursor is very basic. [CODE] inCur …

Hi, My team is developing a new version of a server software that must support several clients via a web service interface. This software was written in C# and published on IIS. It also uses a Microsoft SQL Server database. The problem is that our client has requested that we …

I'm having a hard time to return a string value. I usually do this by passing an int, which works just fine. Now, I need to pass a string but couldn't. Is this possible? Or int is only type that SQL can return?

hi guys i have developed a simple application to insert data in to a SQL DB and get data from same DB using stored procedure. ( 1 table ,2 SP's ) so now i want to run this application on my friends computers to. so how to transplant my simple …

Hi all, Can someone tell me if this is a delphi bug? I am using a Controls.TDate to store a date and using the SysUtils.EncodeDate function to set the value. [code] Invoice.DateReceived := EncodeDate(2011, 03, 16); [/code] When I store it in a MS SQL database field, it is adding …

Hi , i'm new to vb.net. i wish to concatenate date and time from 2 different datetimepicker after concatenated I want it to be save in sql database format which is yyyy-MM-dd HH:mm:ss I'm doing half way and my query is like below. Dim insertCmd As New SqlCommand(Sqlstr, connection) insertCmd.Parameters.Add("@School_Subject", …

Hi, I am changing the sql database to database access (.mdb). The problem is when i run my application using sql connection its work well and all the tables are updated but when i use mdb connection it update some of the tables and few other table it does not …

Hi guys, I want to create a use sql membership for my website but am recieving this error when trying to create a database 'Generating user instances in SQL server is disabled'. I have even run the command (exec sp_configure 'user instances enabled') but I still get the error. Please …

I got an error saying "There is already an open DataReader associated with this Command which must be closed first". I have only used datareader once while using the same connection for my dataset. Would that make some conflict? Need help.

I use following code to get all existing sql servers. [CODE] using Microsoft.SqlServer.Management.Smo; DataTable dt = SmoApplication.EnumAvailableSqlServers(false); if (dt.Rows.Count > 0) { cmb_servers.Items.Clear(); foreach (DataRow dr in dt.Rows) { cmb_servers.Items.Add(dr["Name"]); } }[/CODE] In first attempt it's not loading any servers at all but in second it is. I know it's …

I'm using Visual Studio .net 2008 to build my Crystal Reports. I have a simple table that shows training records of people. Training takes 5 days to complete, and each day has a record in a SQL database. I can display all the data, but want only to show the …

Hi All I am having a problem that's driving me crazy. I've just moved a .Net 2 website to run on .Net 4. The conversion went without any problems and everyting runs well on my development machine in both its raw and built forms. But... when I move the site …

Hi, I have create an application in vb.net and ms sql 2005 as database storage. How do i create an installer that can be included in a CD. What i mean is if i want to install it in the virgin PC the Installer CD would be able to run …

Hi i have a program in which i want the main form to get information either from the login form or from the sign up form depending on which one is used. Here is the code below. The information does not seem to appear although there is no error. Please …

I have a combo box with a list of my customers, when a user selects a customer i have the customer code populate a label called LBcustomer. here is how i populate my combo box [CODE] Dim connString As String = "Data Source=" & ServerV & ";Initial Catalog=" & databaseV …

I have a datetimepicker which reads a date as dd-mm-yyyy. the sql im using(sql server 2008) is only reading mm-dd-yyyy. i am having a problem with changing the format of how the date is saved. i put a catch to the code and this came up System.Data.OleDb.OleDbException: Conversion failed when …

Okay, So I'm currently working on my A2 computing project, and I am having slight difficulties updating and saving the data in my database when it is entered on a form in VB. I cannot find any reason why it wouldn't work, but if someone could suggest a better way …

I have declared the datatyp of 'p_date' as datetime I have also used DateTextBox_CalenderExtender on textbox.(from Ajax ToolKit) [CODE] DateTime datetime=new DateTime(); datetime=convert.ToDateTime(DateTextBox.text); InsertIntoMrNo(mrNoTextBox.Text, datetime, postIdTextBox.Text); public void InsertIntoMrNo(string mrno, DateTime mrdate, string postid) { connection =ConfigurationManager.AppSettings["ConnectionString"]; sqlConnectionObj = new SqlConnection(connection); insertQuery = @"INSERT INTO mrno (mr_no,p_date,post_id) VALUES('" + mrno+"', …

i want to create inset and update for following files after inserted updated Find1, varchar(499) Find2, varchar(499) Find3, varchar(499) i wnat to crate trigger if find1 and find2 are inseted ,unpdated then show message in find3 and not updated or inserted reset previous value

any one know how to create trigger for update one column if column have value = 'cityname' then raise error or print error if value is null the don't do any thing

I was required to have my ID number, which is the primary column of my table, to be formatted with date. Instead of having just a number incremented by 1 (identity(1,1)), I need to have something like 318111 that means March 18, 2011 and the last digit is incremented by …

hi to all, I created following table create table book(id integer, author varchar(20)) In this, each book may have 1 or more authors. My question is that, how can insert more value to author column like as follows. id author 1 pooja merry james 2 robert stephen Thanks & regerds, …

Hi all I have 2 tables TblHP and TblDP how is the query to select price on certain TblGood_Kode which is before certain date tia denny TblHP No_Inv Date TblCustomer_Kode (as foreign key to TblCustomer) //--------------- TblDP TblHP_No_Inv (as foreign key to TblHP) price TblGood_Kode (as foreign key to TblGood)

Hi to all, I created following table and its view. [blue]create table employee(id integer, name varchar(20), age integer) create view Vemployee as select id, name from employee.[/blue] now I want to rename a view, so I wrote a query like [blue]rename view Vemployee to Pemployee[/blue] But, it shows error about …