recently i appeared for an exam... below question was asked: You work as a database administrator. You need to install a new SQL Server 2005 instance on a newly installed Windows Server 20003 server named Server2. This new instance must have the same settings as the existing SQL Server 2005 instance on a server named Server1. The only two services that need to be installed are the SQL Server service and the SQL Server agent service. The default installation folder should be used for the new SLQ Server instance on Server2. You will be able to refer to Server1 to view the settings to use. You need to complete the installation wizard on Server2. What operations do i need to perform.... (i dnt hv much experience on sql i am a beginner.)

Sailaja

I don't want to give any fixed value in the insert command. I want the command to take the user input values entered from the UI and store those values in the database.

Sailaja

my problem has been solved. thank u so much... :rose:

Sailaja

thx pande... the code worked correctly if I give the date in single quotes but am not getting the current system time in it.. :( its displayed as: 8/14/2007 12:00:00 AM

Sailaja

hi navaneeth thx for ur reply. I had already written the code for sql connection and all. I am able to connect to sql, after connecting to sql only I am trying to insert the data but the that error msg is being displayed. plz let me know whether i had written the code correctly mentioned earlier?? and also plz send me some refernces if any for learning this....:(

Sailaja

Can anyone tell me how to take user input from an application and insert that into SQL database table. I am very new to asp.net. And had tried the below code: insert_cmd = string.Format("Insert into CreateTask(@Title,@AssignedTo,@AssignedDate,@EstimatedEfforts,@Priority)"); // Create new parameters for the SqlCommand object and // initialize them to the input-form field values. mycmd.Parameters.Add(new SqlParameter("@Title", SqlDbType.NText, 11)); mycmd.Parameters["@Title"].Value = inpTitle; The new parameters are created for the other fileds same as above. When I run this program the error displayed as: "The name 'inpTitle' does not exist in the current context"

Sailaja

Said could you plz tell me how to do that as i dnt know. i'm new to sql :(

Sailaja

I am inserting a row into database from asp.net. Below is the command i had given: insert_cmd = string.Format("Insert into CreateTask(AssignedTo,AssignedDate,EstimatedEfforts,Priority) values ('ABCD',14/08/2007,30,'Medium')"); The date i had given in the command is 14/08/2007, but when I check the table data in SQL server the date is displayed as ---- 1/1/1900 12:00:00 AM Please help me out... :(

Sailaja