[microsoft:sql-server] Forum Topics

Hello All, My name is Artie77 and I am an apiring geek....just wanted to say hello to the DaniWeb Community...I hope to one day be a major contributor to this forum and I hope that I can draw on your knowledge to become the best possible developer I can be …

Hi Below is my code. The code is running well if the column name specified below is not exist. [COLOR="Red"]Sql = "ALTER TABLE Update_PaymentDetails ADD ServiceCharge float NULL," _ & "TotalAmount float NULL,Commission1 float NULL," _ & "Commission2 float NULL,DealerCommission float NULL," _ & "PaymentToDealer float NULL,PaymentPay float NULL," _ …

I am using C# as front end and sql as back end. EX. table name employee feilds = empid,nm,add I want to search code 003 if it present in database it show me message that this data is present and search for last empid+1 as empid. other wise if code …

I Have a Just Simple Question. But It Made me Confuse. I have a DataTable Which has bind to textBoxes and Other Items. therfore when I made a change through txtBox or Other Items it reflect to dataTable. what I have to do is Saving updated Datatable to Sql Table. …

I have about 500 items in a database (MS SQL server 2008). These individual items have some other properties stored as tables. I am trying to display these items as html links on either a JSP/HTML page. I have a page with alphabets A....Z which are html links in themselves. …

hi, i m trying to make something like a login page with C# using VS 2010 and SQL server database. I am using the following code to get the password from the appropriate username but i get an error of Object reference not set to an instance of an object. …

Hi All, I have a log in form, I have had a couple of idea's. When a user logs in I want his/her name to print on the top of the main form with the current date, the data for the login form is collected from a sql database (not …

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 …

So i have tried basically 30 different methods of going about this all with different errors in every form and fashion. Basically all im trying to do is write to my database in some form or fashon. Im having no problems reading from it but i need to change some …

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

how to connect to The sql server 2005 express edition give me webconfig file with connection string to connect send me the complete file so that i'll try to understand the whole connection to the database thanking u

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 …

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 …

I am facing a minor challenge in my coding i am trying to generate reports from sql statements.however the method i was using ealier involves making a crystal report using the "Add new item".in the menu and using the wizard until you end up putting the table you want on …

how to Cancel amendments of a record in VS 2008 Windows application, using C sharp and SQL server 2008 Database... looking for line of codes for • Cancel amendments for a record • Cancel all amendments made to the table since the last save cheers

I am generating crystal reports using sql statements but now i am looking 4 code to allow me to refresh the crystal report. in other words remove the datra on the report and wait for another query

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 = …

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 = …

Hello all I am on a windows application form where people can log in and add status ... and it's all online via sql database. What i am looking for is a sql query that Insert into the table the current time. Not the user time because he might be …

i want to generate crystal report using vb6.0 using invoice table which have rate column and total should round up like 63.7 to 64.00 invoice table is in sqlserver 2005

Hi , i am suresh . new to this site, let me know whats the requirement of hardware for sql server

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 …

Hi All.. The year hasn't even started and I'm battling again. I want to import data into sql server 2005 through an excel 2003 file. I do this through the built in mechanism of sql server 2005. But I get the following error: - Executing (Error) Messages Error 0xc020901c: Data …

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 Experts ;) I'm having trouble exporting data to my database in sql server 2005. Can anyone help me perhaps? The data I want is located in text files (holds personnel time management data), so what I would like to do is import that data to sql server but the …

[ATTACH]18705[/ATTACH] Hi there. I'd like to ask for assistance from anybody out there that knows how to create database conceptual and physical. The problem I'm wanting to solve is I've got an interface in Visual Studio 2010 that populates from 2 tables named Orders and OrderDetails. Below are the fields: …

[code] Sub modify_inventory(ByVal frm As frminventory) Dim writesqltime As String Dim writesqldate As String Dim msg As String writesqldate = Format(CDate(sqldate), "MM/dd/yyyy") Dim cmd = New SqlClient.SqlCommand If active_frm.Name <> "frminventory" Then Exit Sub Else writesqldate = Format(CDate(sqldate), "MM/dd/yyyy") Dim j As Integer con = connect() con.Open() For j = …

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 …

i am developing winform application.there are three textbox named patient last name ,first name,DOB and on lost focus event of DOB I had a requirement to show pop up like menu .That pop up will show patient last name ,first name,DOB from patient table matching records from database based on …

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 …

Guyz i have this insert function that is supposed to help me insert data but somehow i dont know how to actullay call it and get it to insert data [CODE] Private Sub btnInsert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnInsert.Click DataAccess.InsertNewRecord(txtName.Text, txtSurname.Text, txtID.Text) End Sub [/CODE] [CODE] …

Hi. I want to backup and restore the database by using vb.net.I have a problem here. .This dialogue box appear. " [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'C:\Documents and Settings\S\My Documents\sales.Bak'. Operating system error 5(Access is denied.). [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally. " Can …

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 …

Hi All, I have a combo box in a form, I want to fill it with names I have stored in a database. I know I have to use the fill command, but I am not sure what code I need to use. I imagine I need to place this …

Hi everybody I wanted to retrieve data from sql server and save them in arrayList I use the following format [CODE] sql="select bookid,bookname from BookTable"; Sqlcommand cmd=new (sql,conn) // I define reader here while(reader.Read()) { list.Add(new book(reader[reder.GetName(0)],reader[reader.GetName(1)])); } [/CODE] in book class I build a constructor [CODE] public book(int id,String …

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" …

can l plz ask you something ... l hav a database with 4 tables i.e User(fname, lname,email and userid ------primary key{userid} ) Exam( examid, examname-------primary Key{userid}) Exam_user(examid, userid------primary key{examid}) Exam_category(categoryid, categoryname----prmary key{categoryid}) HOW CAN YOU WRITE AN SQL QUERY THAT ALLOWS U TO CREATE/retrieve A NEW TABLE WITH FIELDS;;;; (fname, …

in vb.net to store this query in dataset ..In Sql query I have a Employee Id M 1 M 31 M 41 M 58 M 6 M 60 M 67 S 10 S 118 S 133 S 143 S 151 S 155 S 157 S 158 S 25 S 28 …

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, …

Hi, I have this database based on this logic: There are projects in a company. In each project, different employees different roles. One employee could have different roles in a single project. Also, can work in different projects at the same time. Some projects could be added but role of …

How to find the minimum or maximum value across several columns in sql server

is there any function in PHP that can access my MsSQL Server...??? Note : All my Script was in Store Procedure

Morning all, I have the following code that gets a jpg image from sql which works fine. What i would now like to do is save this image as a file on my pc in a temp folder that i can use in a report. i would like to change …

Plz send me the complete code for convert xml file to sql database

Hello all I am on a windows application form where people can log in and add status ... and it's all online via sql database. What i am looking for is a sql query that Insert into the table the current time,so i can print on the application the time …