Search results for query: *

hello i have a table called test. This is the table, test_id test_date test_description 1 1/1/2001 test1 2 2/1/2001 test2 3 3/1/2001 test3 I want to get the results like this, test_id 1 2 3 test_date 1/1/2001 2/1/2001...

hey all; i have a column "story" which is text datatype.It has some content in it. I would like to do this; update story_table set story=story + 'blah blah blah' where story_id in(1,2,3) i am getting an error of datatype error. How can i fix it?

hey all; i knew that sql server 2000 developer edition would work on xp home as an actual server so i bought it and set it up. When i try to connect to the server that i defined during the setup i get an error message saying "A connection could not be establisked to LOCAL&quot...

Hey all; can someone tell me what the problem is here? <%@ Page Language=&quot;C#&quot; %> <%@ Register TagPrefix=&quot;KUTI&quot; TagName=&quot;Login&quot; Src=&quot;Login.ascx&quot; %> <script runat=&quot;server&quot;> public abstract class Login : System.Web.UI.UserControl {...

i have a windows xp home edition pc at home.i would like to run sql server database on it and develop some applications. Can i be able to do that with sql server 2000 developer edition? thank you.

Hey all; I have a quick question. I have a column car_year as varchar. How can i run this query without changing the original datatype of column_car in actual table. select plate_number,VIN#,car_year where car_year>1998

Hi all; I have a column called news. In every row of this column there is a news approximately 150 chars long. Each of these rows contains the word &quot;exactly&quot;. I want to select 20 characters before &quot;exactly&quot;, the word &quot;exactly&quot; and 20 characters after...

Hi all; I have SQL Server 7.0 on my stand alone pc.When i want to work on SQL(creating databases,tables etc.) it automatically tries to connect to a server and it fails of course(cause i dont have any server attached to my pc).I cant do anything about it.Any suggestions? Thanks.

Hey all; I have a very simple question.I am using Access for database and now i put a password to it to make it secure. What is the syntax to implement this password in my asp pages so that database interactivity can be done?My existing code is ; Set...

I have a column like this; aaa bbb ccc ddd and i want to write it in a row like aaa,bbb,ccc,ddd how?

Hi ; I have 2 columns like these. a e b f c g d h and i would like to create a column like these a,e b,f c,g d,h Suggestions please.

Hi all; I have a problem with rollback a delete query.Here is what i wrote; BEGIN TRANSACTION trans1 delete from auto where auto_id=5 and this delete the record whose auto_id=5 The problem is when i wrote ; ROLLBACK TRANSACTION trans1 i get get an error message like &quot;there os no...

hey all; I have a statement like this BEGIN TRANSACTION trans1 insert into auto(auto_id,aout_name)values('2','Porsche') and after i run this ,i write ROLLBACK TRANSACTION trans1 and it rolls back succesfully. When i try to do the same thing with delete query like, BEGIN TRANSACTION trans2...