[microsoft:sql-server] Forum Topics

Hi friends, My problem is i am unable to find out records within a specified date. I am describing my programme detail i have a column in ms access table name [B]travel[/B] column naem doj data type [B]date/time[/B] format short date ' dd/mm/yyyy in visual basic i took two datepicker …

Hello All, I am needing to develop an SSIS package that reads a large text file into an SQL Server table, then formats 2 different output text files. I think that is the easy part as my client wishes to run this from a VB 2005 front-end by clicking on …

Hi, i have on my computer (vista) the IIS7 installed, and for regular sites it works, meaning that i simply do a project in VS and then copy the files to the wwwroot directory, and am able to open them in my browser. However i have a project where you …

Hi all I am going to graduate in December 08. I want to be a SQL Server Database administrator and developer. I want to appear in certification exams before December. So that I could get a job immediately after graduation. But I am not sure about several things. Please answer …

how do i create join views in MS SQL and in mySQL. in mySQL it is almost impossible any one with an idea

In one of my application I am getting (through OTL using ODBC drivers) the following information from the SQL Server 2005 for each table - Column Name - Datatype of each column - Primary key information and after getting this information I create a table with the same schema information …

hie out there im having problems binding records form an sql database to the text boxes on the form.i want to be able to navigate through the records. PLIZ HELP FAST AND I APPRECIATE YO EFFOCTS.

i want to add column in a table through following SP [code=sql]create procedure sp_addCol @tablename varchar (50) as DECLARE @tsql_TZ varchar (200) SET @tsql_TZ = 'ALTER TABLE [ '+@tablename+'] ADD timezone varchar (5)' EXEC(@tsql_TZ)[/code] whenever i try to execute this through EXEC sp_addcol 'MGV10SEP_MNPC_MNLD' ' it shows me the error …

Hi everyone can someone pls help me with my data. I have an sql table(Test) in this form Student_No Grade_code Test_N0 Mark 20427103 DS302 1 60 20427103 DS302 2 65 20427103 DS302 3 60 20427103 DS302 4 70 20427103 DS302 15 69 and my stored procedure Select * from Test …

I'm working with MS SQL Server 2005. I am trying to add two columns together, and I have more or less succeeded. However, it obviously adds the entirety of each column, rather than calculating for each row. I can't just include each column in the original SELECT statement, because it …

hi all, i want to know how to work with gridview in asp.net as i am using Sql srver 2005 database. i want to know what are the methods in a gridview that we use to display the data in various formats. Can anybody help me in this . Regards, …

Hi everyone this is Eric here, can someine pls show me how to load data from SQL Database to the cristal Report i m using , I have this storedprocedure that retriever data from database [code] USE [Isando] GO /****** Object: StoredProcedure [dbo].[getMod] Script Date: 09/15/2008 23:11:05 ******/ SET ANSI_NULLS …

hi... im finding an error in the following statement... here department is my database name... n deptid n deptname is the name of the fields on the form... when i run the form it shows "No value given for one or more parameters." [code]sql = "INSERT INTO Department(Department_ID,Department_name)VALUES(deptid,Text2)"[/code] please help …

Hi Guys I hope you can help share some light on my problem. Basically, I have a MS Access table...ID, firstname, surname, Address1, Address2 etc What I want to do is Select all from table but only show one record where more than one person lives at that address .. …

I desperately need help with this database stuff as I have no clue what to do or where to begin. Business Description Red Rocket Deliveries has a fleet of vehicles which costs them a lot of money to run and maintain. Most of relevant information is currently recorded, but it …

Can anyone please help me.........I am at a loss. I am trying to install sql 2005 server on a windows 2003 server and am getting an installation error. The error states that there was an unexpected failure during setup wizard, and to review setup log. [B]In the log there is …

hi everyone, iam using vs.net2005 and sqlserver 2000.i want [B]connection string [/B] to connect to local sql server.the connections strings which i used in vs.net2003 isnot working here.so plzzzzzzzzzzz help me as soon as possible. thankuuuuuuu

I have recently issued nearly 2000 ID mifare cards to all the new students who recently started at the college at which I work. Accidentally, the software that printed the cards reversed the LSB of the UID of each card which means I have a useless database of codes. I …

hiiiiiiiii evryone, plz help me out.i want to delete a record but not able to do so.plz check the code and rectify the mistake.it is giving some unknown error.thnqqq [code=csharp] private void button1_Click(object sender, EventArgs e) { int i; String sqlvar =("Delete from emp where empno=" + textBox1.text); string conn1 …

I have setup the following table:- [code] IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TlHold') DROP TABLE THold GO CREATE TABLE THold ( pid int NOT NULL IDENTITY(1,1), TS NUMERIC(2,2) NOT NULL, TR NUMERIC(2,2) NOT NULL, TB NUMERIC(2,2) NOT NULL, TP NUMERIC(2,2) NOT NULL, TP2 NUMERIC(2,2) NOT NULL, filler1 …

i am asp.net beginner , i need to upload file to sql server 2005 and also download file. what are the code to use and where i put the code . plz ...

Hi, I'm new here, and still a noob in sql. This is my query [code=sql] SELECT Payments.ClientID, Payments.CreditorID, Clients.FirstName, Clients.LastName, Clients.SSN, Clients.Address1, Clients.Address2, Clients.City, Clients.State, Clients.ZIP, Clients.HomePhone, Clients.WorkPhone, Clients.OtherPhone, SUM(Payments.Amount) FROM Payments INNER JOIN Clients ON Payments.ClientID = Clients.ClientID WHERE (Payments.CreditorID = 1015 or Payments.CreditorID= 1014) GROUP BY Payments.CreditorID, Payments.ClientID, …

i have a webpage running where it goes to an SQL Server and displays the data that's returned from it. however, the users can select to see some data or a lot of data. in the ' a lot of data ' version they are going to get 10,000 records. …

Help me with the code or tutorial on how to connect vb .net with sql. dbase. thank you

Hi! :) Im developing an application with visual basic 6.0 for front end and MS SQL 2000 for backend. I've been trying to create a data grid but the error above keep showing up. I wonder what's wrong with the code (since it was system generated I tought it would …

I am receiving an error stating that there was an unexpected failure during setup wizard and to review setup log when trying to download sql server 2005 from microsoft eopen on a windows 2003 server. In the log there if reference to Failed to find property "watsonFailedActionErrorCode" {"SetupStateScope","",""} in cache …

I want to upload data from flat(.txt,.doc and excel sheet) file into sql server database2000.and i want to upload that data using web portal.can any one please help me.........

I set up a server with SQL 2005 Standard and another server with SQL Reporting Services. Now my boss wants to upgrade to SQL 2005 Enterprise Edition. What would be the procedure for this upgrade and any caveats or problems that might arise, not only with SQL 2005 Std to …

Hi I wonder how to write a query where given record meets at list n criteria from given criteria? For example i have a table PERSON like this: Name Height (short, medium, tall) HairColor (brown, blonde, black) EyesColor (blue, green, brown) I want to fine people who meet at least …

I am trying to install Microsoft Accounting 2008 Express, which requires installing SQL Server Express 2005. I have a Vista Home Premium machine and it's giving me fits trying to get SQL Server (any flavor) installed. I've tried every tweak I can find online, but all to no avail. I've …

Hi friends, I am unable to fetch out correct result on date base. I am writing following code for fetching all records of a table between two dates. db.execute"select * from travel where doj between '"& doj.text &"' AND '"& doj1.text &"';" but above query can't give record between specified …

I have a GridView, bound to a SqlDataSource. The SqlDataSource points to a table with seveeral fields, including an Activity Date field and a Name field. By default I want it to display every entry in the table, but I want to be able to dynamically filter it with three …

How do you use sql 2008 express edition with html to create a website. I'm using a domain service through yahoo to build the website. I want to make it a multi page site with video and audio.

hi, :p i am trying to achieve a registration page in JSP. i am using tag library to do this. c tag library and Sql tag library. [CODE] <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> <c:if test="${param.submitted}"> <c:if test="${empty param.name}" var="noname" /> <c:if test="${empty param.pw}" var="nopw" /> …

I m writting a project i want to save finger print image in sqlserver but io.filemode.open is error occured, how can i solve for this, help me '///////////////coding [code=vbnet] Dim sqlConn As New SqlClient.SqlConnection(ConnectionString) sqlConn.Open() Dim sqlComm As New SqlClient.SqlCommand("SELECT * From InkPaperData", sqlConn) Dim SaveAdapter As SqlClient.SqlDataAdapter '(" Select …

Can anyone help me on this I recently installed MS SQL 2005 Developer on my PC (XP Pro)and that works oK. I installed another on my Notebook (Vista Ultimate) and somehow got connected to my PC Database. But that is cool. At least I know I can connect to my …

Hello I am new in this. Just installed MS SQL 2005 on my notebook for learning purpose. I found that though using the default instance, it keeps giving me a logon screen which I am having problems loging in with Server Name: JMZCONS-PC Error Number: 18456 Severity: 14 State: 1 …

i tried to add a database file to an exsiting Website project. i get this error. "connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly." installed products are visual studio 2008 sp1 sql server 2008 however creating a data connection to a database attached with …

Hi all, I need a help in MS SQL Express query. I have a table named "tblTotalCust" and the fields are: [Date] date, [ServedTime] date, [TotalCustomer] int. Example data: [Date] [ServedTime] [TotalCustomer] 8/9/2008 12:00:00AM 8/9/2008 9:23:00AM 12 8/9/2008 12:00:00AM 8/9/2008 9:27:00 AM 7 8/9/2008 12:00:00AM 8/9/2008 9:37:00AM 9 8/9/2008 12:00:00AM …

I have a little problem... I use a MS database in my program.... I want to enable the user to backup the database that I use to a specific location that they choose.... Any suggestions? Because I'm lost.....

Hi, i have a problem with SQL, im verry new to it and in the beginner guides and tutorial you can't learn anything of the special tricks. I have developed a Access db, and i need to use the INSERT INTO statement to insert the current record id of a …

Hi Friends, can some body help me in designing the below scenario: MY QUESTION IS HOW WOULD THIS INTERFACE LOOK LIKE? Objective: To design an interface for the following scenario. See attached image for visualization. Scenario: 1. There is an Application X (May be a VB or Java application) and …

I have a datetime column in a T-SQL table that I need to sort desc. However, when I do this the NULL values for that field will show up at the bottom. I need them to be at the top of the list, while still having everything else sorted in …

Hi i've got a problem. I keep getting this awesome error "[Build Error] [Project1.exe] Error 1" I copied this source code from [url]http://www.daniweb.com/forums/thread56924.html[/url] I just can't seem to get it to work. can someone pls help [CODE]#include <windows.h> #include <stdio.h> #include <string.h> #include <odbcinst.h> #include <sql.h> #include <sqlext.h> #include <sqltypes.h> …

Hi, I have a question. Am aiming to install sql 2005 in one server and connect my applications which are put into another server to it. My applications are built in .NET2003 with .NET framework 1.1. Now I know that to install SQL2005 I need .NET framework 2.0.My question is, …

Help - I am fairly new at MS SQL, but understand the concepts and have looked at the code in MS Access many times. But here's my problem: I need to create a complex query across multiple tables within the same database, but I'm just not sure how to do …

We have a need to see if data exists in a field based on an ID and Date. The data we have exists in a table as follows: ID DATE ISSUE 903 01/15/08 3,2,1,,,,1, 903 01/15/08 3,,1,,,,,1, 903 01/16/08 ,,,,,,,,1,, 903 01/16/08 ,,5,,,,4,,, 903 01/15/08 ,,,,,,,,, 904 01/15/08 ,,,,,,,,, 904 …

Hi I've used Access to model a new database that now needs to be created in SQL Server Express. Wow - that's alot of data types! Can someone tell me what the SQL version of the Access Memo data type is? Thanks _________________ [url=http://www.freefixit.net/monitoring-parental-control-software-advice/]Parental control software[/url] [url=http://www.loans.cc]free parental control software[/url]

hello frds, Does it is possible to fire query directly xml file which contain a sqlserver database table. I don't want help from any other database for query. If any idea pls give way. thank in advance.

Hello, i'm very new here in these forums. I'm making a webpage for registration for my online game's server. My problem is in the registering part, i've got the query to register the new user on the database, but first i need to check if the name of the account …