2,935 Topics

Member Avatar for
Member Avatar for BonaDrag

I have this code that works fine: [code=c] protected void ButtonImgTextToDB_Click(object sender, EventArgs e) { string ID = TextBoxStartPictID.Text; string Rubrik = TextBoxHeadLineStart.Text; string Text = TextBoxTextStart.Text; SqlConnection conn = new SqlConnection(config); conn.Open(); string sql = "UPDATE StartImage SET Headline ='" + Rubrik + "', Text ='" + Text + …

Member Avatar for BonaDrag
0
148
Member Avatar for flamer_x86

Hi, I'm newbie in IIS and MSSQL using php. I got problem connecting to my host and selecting database. Could you please help me how to connect using php. Mar,

Member Avatar for flamer_x86
0
129
Member Avatar for duke_swh

I have a table in SQL Server with the following structure: DateRated, Parameter, Rating, UserID Sample Data DateRated Parameter Rating UserID 10/01/2010 Flexibility Good User101 10/01/2010 Efficiency Average User101 10/01/2010 Value For Money Below Average User101 I want to create a query that will make it like this: DateRated Flexibility …

Member Avatar for duke_swh
0
245
Member Avatar for Shandelzare

Have you ever forgot or lost your SQL Server sa password? Did you hava any ideals to reset your lost sa password? Or choosed to reinstall MS SQL Server on your PC again? I once forgot my SQL sa password and I reinstalled SQL Server at last, because I failed …

Member Avatar for Shandelzare
0
251
Member Avatar for lgriess

I've been asked to create a new front end to our reports that were built using reporting services (SSRS). the front end is dynamic and changes by report, and it will prompt for the parameters of the report. Help me someone!! I don't even know where to begin developing this …

Member Avatar for drmckinnon
0
69
Member Avatar for dougancil

I have the following sql query: ET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE YourProcedure AS insert into msbtotal.dbo.newclients SELECT tcms_members.dbo.memberdata.* FROM tcms_members.dbo.memberdata left outer join msbtotal.dbo.memberdata on tcms_members.dbo.memberdata.id = msbtotal.dbo.memberdata.id where msbtotal.dbo.memberdata.id is null GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO What this does is …

0
63
Member Avatar for zbibliophile

This is my first SQL project. An Access database was converted to SQL Server 2005 Express using the DTS utility. The old AutoNumber fields were automatically converted to int identity not null fields. However, when attempting to INSERT a row, such as the following ASP code, [CODE]Conn.Execute("INSERT INTO tblAdmin3 (fldA3Username,fldA3TimeIn,fldA3Date) …

0
83
Member Avatar for Izzy123

Hi, I'm new to VS 2008. And as a uni project, we had to create a doctor surgery databases as a group. However, when one of my group member sent me part of her work and when I tried to open it in my VS 2008, I failed to open …

Member Avatar for Izzy123
0
224
Member Avatar for hensona

Problem I have is that the following code works only if the user tabs out of the field, (or moves the cursor to another field in the same form), if the cursor is still at the end of the date text, none of the error traps catch, but I get …

0
51
Member Avatar for chfunglukas

This is a sql datatype problem Hello I am a junior programmer and new member of this forum I want to ask a question I have these two columns in sql 2000 server trx_date char(8) trx_time char(6) And now, I imported this database to sql 2008 and want to copy …

Member Avatar for chfunglukas
0
93
Member Avatar for tammy2512

hello, I am facing a problem with the following code: select year(regdate) as [Year],month(regdate) as [Month], CONVERT(varchar(3),regdate,100)as inmonth, count(*) as incount, cast(sum(amt)as decimal(20,2))as insum, count(case when nbr <>' ' then amt else Null end) as incountpo, SUM(case when nbr <>' ' then (amt)else 0.00 end)as insumpo, --cast( (Insumpo / InSum …

Member Avatar for kplcjl
0
154
Member Avatar for kplcjl

OK SQL documentation sucks. I know that, I've known that for years, but it can be helpful and useful at times, so I use it. I thought I remembered correctly what "~" did, but looked it up anyway. I'm reading the usual @#$%, but getting the basic information (While thinking …

0
64
Member Avatar for jeevObe

i have create a registration form in asp.net & sql server..It's working good.. i generate ID for user when they click "sign Up" button..(the ID will appear in drop down list at form-ID not saved yet into database).. the problem is when several user register at same time and click …

Member Avatar for kplcjl
0
125
Member Avatar for dougancil

I have a SQL DTS job that runs nightly. What this is supposed to do is to copy from Database1 to Database2 and to overwrite anything that was in Database 2 previously. This was set up as an import/export job. The process runs nightly as it's supposed to but apparently …

0
73
Member Avatar for mirageline

Hi, my name is khalil and im hosting a online game which using mssql! in databases i got database called gamedb i have "account" as table in account table there is a column called GM so this column is my problem! when guy account got GM Column number 0 mean …

0
48
Member Avatar for Sinha's

Hello Experts, I have following tables: Table_1: C_ID Inst_No Paid_Dt 201 2 12/06/2010 [COLOR="Green"]202 2 13/06/2010[/COLOR] 203 3 12/06/2010 [COLOR="Green"]202 3 16/06/2010 [/COLOR] Table_2: C_ID Inst_No Today_Dt 201 2 12/06/2010 [COLOR="Green"]202 2 12/06/2010[/COLOR] 203 3 12/06/2010 [COLOR="Green"]202 3 16/06/2010[/COLOR] Now, from the above two tables I want to display only …

Member Avatar for Sinha's
0
178
Member Avatar for mathewmoozh

Hi, Iam using ms sql server.Iam using a hospital management system .I need to find the last visit of the patient,only the last visit date,How can i do that?I think that it is as same as the latest published text,one of my friend told me,But how can i do that? …

Member Avatar for mathewmoozh
0
106
Member Avatar for vikas05nitb

i am trying to install developer edition 2000 on xp, but after clicking the autorun file nothing happens, though two processes appear in windows task manager, these are 1) sqlstp.exe 2) setupsql.exe but both are using '0%' cpu use and taking some memory. i tried so many things..really fade up. …

Member Avatar for vikas05nitb
0
75
Member Avatar for alicepriya

how to insert username and password into database with connection in c# please give me reply sir

Member Avatar for sourceskill
0
112
Member Avatar for sourceskill

I have kind of the same question as Rambomst, except I need the query string to populate the values for the IN statement this is the code I have but it's not working and I'm stuck and am in DIRE need of an answer: <% Dim rsAuto__print For i=1 to …

0
49
Member Avatar for Rambomst

I am trying to make a query which will search for the ID's 5, 6 and 23(Those are just random numbers and could potentially be more). Rather than making a loop in my code to query each separate ID I was wondering if it was possible to query them all …

Member Avatar for sourceskill
0
97
Member Avatar for judithSampathwa

hey i need to know whether the below code is correct [CODE] string query = @"Select p.ID,p.Phase From Proposal as p, Negotiation as n,contract as c Where c.CID=con.CID and c.NID=n.NID and n.ID=p.ID and n.Phase=p.Phase (Select con.CID From Contract as con Where CStatus='Active')"; [/CODE] there is an error coming saying "Incorrect …

Member Avatar for pritaeas
0
95
Member Avatar for phil7771

Here is my code. INSERT INTO employees (1.Last_Name,2.First_Name,3.Title,4.Title_of_Courtesy5.,BD,6.Hire_Date,7.Address,8.City,9.State,10.Zip,11.Country,12.Extension,13.Notes,14. Reports_to,15.Photo); VALUES (1, 'Smith', 'Janet', 'Sales Manager', 'Mrs.', '12-30-1974', '08/05/2000', '123 My Street', 'canton', 'OH', '44720', 'USA', '4632', 'MBA from Ashland University', 'Andrew Fuller', 'No Photo Available Yet'); Here is error message...Msg 102, Level 15, State 1, Line 2 Incorrect syntax near …

Member Avatar for Piya27
0
124
Member Avatar for Sedanta

Hi Forum, I need a funtion to retrieve data from more then one Table. The tables are not related.Field names are the same in all tables. The table list I get from a view and i need to go through this list and pull out any records from the different …

0
50
Member Avatar for flamer_x86

I'm newbie in MSSQL, I would like to ask what web server should i use? Should i install IIS in my PC? I appreciate your suggestions... Thanks.. Mar....

Member Avatar for flamer_x86
0
62
Member Avatar for visweswaran28

Hi, Consider, that I have 5 fields, In which first four fields has same value and fifth one has different value. If I retrieve these records from table it should shows first 4 fields only once and fifth fields should be appended. How can I achieve. Eg: field #1 field …

Member Avatar for jbisono
0
107
Member Avatar for kianmiranda

hi please i need help with the query using the values from the combo box and the result will show on the data grid sp [CODE] ALTER procedure [dbo].[sp_GetReservistInfo_ByDesignation] @Platoon varchar (50), @Company varchar (50), @Batallion varchar (50), @Brigade varchar (50), @Division varchar (50), @FirstName varchar(50), @MiddleName varchar(50), @LastName varchar(50), …

0
74
Member Avatar for dhanapal86mca

Can Any one Explain me about Isolation level in mssql server

0
65
Member Avatar for towerrounder

Hi All, I have a query that returns rows from a message table. Im basically trying to get the latest MESSAGE_TYPE for the user based on when the message was sent (MESSAGEDATE) At the moment I have a query that gets me almost what I want. It returns something like …

Member Avatar for MeSampath
0
112
Member Avatar for mathewmoozh

In my-sql i used a variable c and in a situation i used like c-- to decrement the value of c but while executing i came to know that remaining code in the line get commented, how can i avoid that without using c=c-1;

Member Avatar for MeSampath
0
71

The End.