9,022 Topics
hi all, Very new this forum. i am using MSSQL 2005 and i want to create a backup script for a table [create and insert statements] without using mssql datapublishing wizard 2005. is it possible?? how can i do it Best Regard
Hello All, I am deleting a database but I am not seeing any entry in server logs or in event viewer. and same thing is happens when I am deatching a database. Can any body tell me the way through which I can know when a particualr database was deleted …
hello someone there could have met a similar problem. please help me out Am using this commant to save data to an sql server database. me.validate() me.bindingsource.endedit() me.tableadapter.update(me.dataset.datatable) but when i click the save button on my winform it brings an error "System.Data.DBConcurrencyException: ConcurrencyViolation: The UpdateCommand affected 0 of the …
First, I consider myself a novice in Mssql. I've recently began the revision of a website that uses MS Sql Server 2000. In a effort to set up a working environment on my pc, I asked to get a copy of the sql server database. The response was something like …
I have undertaken a website revision project after not programming for about 6 years. I am beginning to set up a work environment on my pc, and have questions about the software being used verses what could be the ideal software. My background is that I am familiar with classic …
plzz anyone tell me does vs.net 2005 supports sql server 2000 coz iam not being able to connect it
I'm assuming not many people on this forum use SMS, but just in case; I'm trying to install SMS 2003 on a Dell server with W2k Pro Server OS, SP4, with MSSQL7sp3. The server is on a NT4 domain. The server was our old SMSv2 server, which I have removed …
hi I'm doing online reservation hotel using vb.net with sql server2000.i have some problem with checking room availability i tried lot of sql query but doesn't get what i want. the customer choose the arrive date and the enddat from the calendar after that it should disply the available room …
hai , i am trying to do online railway reservation project. In that project.if we give the source and destination station .it should give the number of tickets available,class name ,train name and time & in that form itself we have a reservation link.if any one reserved, the number of …
Hi, I have time stored as an integer in sql server. The time is separated into fields of hour, minute and am/pm. I need to output the data and sort the time, but of course, 12 is coming after 1. Is there a way to sort my hour integers in …
Hi. Can anyone help me with this? If I have, for example, a MSSQL database named 'COUNTRIES' and an existing table in the database named 'COMPANIES', can anyone let me know how I can add an additional field name 'PEOPLE' with a string datatype (for example) to this existing table …
select convert(decimal(5,2),(7058/7482)*100 ,0) is showing .00 value in sql server 2000. Why ? How to retrive value with decimal part, plz. guide me. Thanks & Regards Girish
Hi! I have a web application in ASP.net 2.0. within it i want to corporate a report that will list all the customers together with the products they have bought in a sub group. Thereafter i need to find the subtotals of all th ecustomers within the same reports. The …
How can I call an ini file for connecting SQL server using VB.NET2003 :confused::-/
I am using Microsoft Visual Web development 2005 and I need to make a connectionString.
Hi Friends! I stuck somewhere while developing my ERP application on VB.Net here i require to create a table in SQL Database from my Button Click event, for example ( there are 1 text box and a button on a form, we need to enter the name of a table …
I have some java code that is pulling from SQL some data, which is filling a groupbox with Medicare ICD-9-CM billable codes. The user can click the Category, then select the codeset then the third box fills in the sub codes and description for them to make the final selection …
The program I use is housed in a SQL Database. What I am trying to do is term Members based on meeting 2 guidelines (PCP and Insurance). WHat I want to do is term a group of members that have the same PCP and Insurance plan. This data is broken …
Hi guys, The question I need to answer is [quote]This query is about patients who got the same illness on the same day. For each pair of such patients, display one row showing the illness code, the date of onset, and the patient number of each person involved, e.g. FLU …
I have the arrays EMP (EMP_ID(PK), Name, PROJ_ID(FK)) PROJECT (PROJ_ID(PK), name) SALARY (SAL_ID(PK), date, amount, EMP_ID(FK)) I have done the appropriate relations and i want to take something like this: wesuppose that EMP name is George and the project is storage then i take something like this: George storage 22/2/2007 …
Hello guys, I'm having hard time to insert/create a code for one projects component. The issue is how could i call a stored procedure and how could i execute it.
Hi I am currently doing a project, part of which involves reading peoples information into a Database, the table in question being member_table which includes a 'Date of Birth' field. I have no problem doing this as all the information I want to assign to this table including DOB is …
Hullo daniwebbers!! I have created a little cd database at home on my home network. And I want my machine to act as the server. I want the other pcs, i.e my sister's and mom's which are connected to my network to access it, and be able to change and …
Hi all, i just dont understand why i get this error : Parse error: syntax error, unexpected T_STRING in C:\Program Files\wamp\www\working3\admincp\pages\mainconfig.php on line 11 I have google it alot and i just find that its probably becouse ur missing a ;, But i cant find the place. I have tested …
hi can we deploy setup of [B][COLOR="Red"]sql server express edition[/COLOR][/B] along with our own apllication? does any licensing issues come into picture? because express edition is freeware, but when i install it on my client machine then it is asking to accept License agreement. if it is free then why …
[code]Set rstDeps = CurrentDb.OpenRecordset("SELECT Members.OrgID, Members.ID, Members.Member, Members.PrimaryRep, Members.MembershipType " _ & "FROM Members " _ & "WHERE (Members.Member=True AND Members.OrgID=" & !OrgID & " AND Members.MembershipType='" & !MembershipType & "');")[/code] This is my query in VBA in MSAccess. I just want the number of people that fall into those …
can any one explain me about connecting data reports,ms sql and vb6.0
hi, Is MS SQL server 2005 Express Edition is freeware??? anything(webpage/link/material) that gives support to above statement will be most welcome..... thanx and regards. chaitanya.
Can anyone help me with an 'IF' statement that will prevent saving a duplicate record in MSSQL
hye there...anyone would let me noe what is the proper data type for display time in sql server 2005??? sumthing it can display 8.00pm-10.00pm...any suggestion? thanks
Hello, I want to use C# to select a random number from MS Access database table. <SELECT TOP 1 userID FROM users ORDER BY NEWID()> seem to work only with SQL Server.
Hi all, I am using Borland C++ to develope one application. I need to call a stored procedure (that will take 2 parameters and will return a string) from my C++ application I am using mssql2005 express as database . How can use TStoredProc/TADOStoredProc/TSqlStoredProc ??? which one is useful here …
Hi guys, My name is Kassem Baalbaki and I have joined this nice forum yesterday. I 'm Lebanese and currently working in KSA as System Developer in a hospital called SMCH (Specialized Medical Center Hospital). I have been using computers for 15 years but developing for 4 years only. Eventhough …
hi everyone. I have a web application on ServerN that needs to access data from SQL Server 2000 db on ServerD over the Internet. However, for security purposes, ServerD is not allowed Internet access. Therefore, there is a ServerM on same LAN as ServerD. ServerM has Internet access; and can …
Im getting invalid coulmn index...any suggestions?...thanx in advance [code=java] public static int[] getListSummary(UserDataVO userData) throws Exception { Connection connection = null; PreparedStatement pstmt = null; ResultSet resultSet = null; int[] listSummary = {0,0}; int leadCount = 0; try { connection = DataBaseConnectionManager.getConnection(); if (connection != null) { if (userData.isAgentType()) { …
dear to all, i want to make my database name as a dynamic one which i'll make it as as a parameter value in a stored procedure. pls help me of what the codes should be. any hint or something. i've tried: declare @data varchar(10) set @data = dbName USE …
Hi, i am new to .net technologies. i want to startwith a database conn. how to connect with sql server database with my asp.net default page. please explan. samy
There is a problem to connect to the server from a remote client through enterprise manager or query analyzer, the two systems ar in a netwok, but no domain is there. There is a connectivity between the computers but connection cant made through SQL Server error is connction refusedm, server …
hey every one please i want to know how can i search about name i use vb.net & SQL server 2000
I have stored procedure in MS SQL and I want to deliver value from form (value of textbox) in MS ACCESS. CREATE PROCEDURE sp_DeleteOwing @OwingID int AS INSERT INTO Arhive SELECT MemberID, ArticalID, OwingDate, GETDATE() FROM Owings WHERE OwingsID = @OwingID DELETE Owings WHERE OwingsID = @OwingID GO I tryed …
Hi all, I currently have a view in my database that pulls certain data from a table. The issue I run into is sometimes this table can be empty, and so I have an empty view. I have been unsuccessful at using an IF statement inside of my view. Is …
I want to stop users from being able to save a duplicate record in my Access database. I thought of using RecordsAffected, but I can't figure out how to get it to work. [code] SelectSearchString = "SELECT * FROM Breakdown WHERE BFrom = " & txtFrom.Text ' & " AND …
Dear friends, Fine and hope the same with you all. I am here with one more new problem which I might be able to solve with your suggestions as we have did earlier. Problem: I have a requirement from my client where I need to give update or edit privileges …
I saw the follwing coding in the forum.. But i dont know how to execute in the Turbo C compiler.. Or else we need to use seperate connectivity coding for Turbo C compiler???? Can i know the include files (Header files) for the coding given below.. ------------------------------------------------------------------------------------------------- HENV hEnv = …
I have two tables A and B. I want to update rows in Table A depending on the back up data stored in Table B. [code]Table A = most current table of data Table B = 5 day old back up of table A[/code] Structure of both Table A and …
I have stored procedure in MS SQL and I want to deliver value from form (value of textbox) in MS ACCESS. CREATE PROCEDURE sp_DeleteOwing @OwingID int AS INSERT INTO Arhive SELECT MemberID, ArticalID, OwingDate, GETDATE() FROM Owings WHERE OwingsID = @OwingID DELETE Owings WHERE OwingsID = @OwingID GO I tryed …
I have to write a view that will return all invoices, but with the contact person of the last invoice issued for the same product. It is hard to explain so I will try to show on example: Table1: "Invoice" Table2: "Invoice_row" Table3: "Contacts" Each Invoice record contains Contact_id field …
I am currently working on a project and need to allow the user to create tabs. This I have managed to do although the solution (to copy from another hidden tab). The problem I have is that I need the tabs being displayed to change between records (something that does …
I want to create new table in Access database during the runtime of my VB code. I am developing a "Library Management System" using VB6. At first i have used SQL statement to do the job. But it worked for once & then it stopped working. No error message was …
I have database in MS SQL Server 2000 and I want to connect to this database from empty database in MS Access because I want to build user interface to that database and also call procedure and functions in VBA. Can someone tell me how to do this or tell …
The End.