How do i convert a varchar field into the datetime data type? the reason i need this lies in the requirement that in the earlier data base the column that is holding the date value is having the data type as varchar. and in the new design the column data type is datetime. How i transfer old Data to new column without loss .from the older design to the newer and got stuck with this datetime convertion issue. do let me know the best possible solution.iam using sql server 2000
following are the sample date Format that is there in the older table for the date.
Hi everyone, i was creating a stand alone application i.e. a project using Visual Studio 2005 with C#.NET. After creating six different GUI which links to each other, and also created datatable for each and everyone of the GUI. I started encountered problems interacting to each database.For instance on this application, i want my first page which required the Username and password before connecting to the next page. I want this username and password to be part of data inserted in the database table or else error message should display. Just like signing to codeproject account. And again, i want to assign one person as an administrator who will be given people access to the said application.
Secondly,after the necessary update on this application, i want my result to be displaying at the front-end i.e. after connecting a screen to the management pc.
I would be much more appreciate your concern about this, if anyone could help me out. I shall be waiting for your solution on this.
I may not posed the question in a manner by which I could get a decent search response, so here I am.
I am trying to figure out a way to connect a table to an ODBC datasource on my PC. To illustrate, in Access you can "Link" or "Import" data from an ODBC Source. I am wondering if you can do the same with SQL Server 2007.
Hi all ,
I am using ssrs2005.
I am trying to generate a report which list employee leave detail ie
Empcode , name , no of leave taken , balance leave. Now user want to see detail information of employee when he click on empcode .
Is it possible using ssrs2005.
I tried with subreport. How can I make subreport to be visible when he select particular employee code
I would keep it simple and make two reports, and have your main one navigate to the detail report.
Add another report to the same project, and make sure you have a parameter for empcode.
In the first report (the main one), go to the properties for the empcode textbox. Under the Navigation tab, choose "Jump to report", then choose the detail report in the combo box. Click the "Parameters..." button and have empcode equal to "=ReportItems!empcode.Value" (I'm assuming that the textbox for empcode is called empcode).
When a user clicks on the empcode the detail report will show with the value that they clicked.
The last I knew, Oracle didn't have an identity column. Are you talking about resetting an Oracle Sequence? If so, here's an excerpt from the Oracle documentation:
To restart the sequence at a different number, you must drop and re-create it.
If you change the INCREMENT BY value before the first invocation of NEXTVAL, some sequence numbers will be skipped. Therefore, if you want to retain the original START WITH value, you must drop the sequence and re-create it with the original START WITH value and the new INCREMENT BY value.
Oracle Database performs some validations. For example, a new MAXVALUE cannot be imposed that is less than the current sequence number.
I have an install of SQL2005 in my server machine and I want to configure it so that I can connect to the server instance from another box via SQL Server Management Studio (SSMS). The following article is meant to provide me with a straigtforward step by step guide of doing this. http://www.codeproject.com/KB/database/SQL_Server_2005_remote.aspx[^]
Although I've followed the instructions, I still can't connect remotely (I can connect using SSMS on the server machine, which means the problem is not with the service). Anyone can point me to some other resource? Could it be some other configuration outside of SQL?
Both machines are connected directly to the router (which is connected to the internet, not that it's relevant to the question at hand)
Thanks in advance.
Every nation state's armed forces call themselves 'Defence',
makes me wonder why there are conflicts in the world.
Hai to all,
I have already installed sqlserver 2000 in my windowsXP.Now i hae installed vs2003 and vs2005.
Presently working on vs2003 framework1.1 with sqlserver 2000.
I want to upgrade from vs2003 to vs2005 with sqlserver2005.
So is there any problem occrs if i install sqlserver2005 when sqlserver2000 already existed.
Tell me which type precautions i have to take before installation.
I want both versions of .net and sqlserver.
I have a textbox called "textBox6.text" in a C# Windows Application in Visual Studio, and i want that the text entered by the user in the textbox should be added to the "PURPOSE" field in a table "TABLE2_HDB1" in Oracle database "HDB1" on clicking a "submit" button.
the coding for submit button is as follows:-
private void button1_Click(object sender, EventArgs e)
OleDbConnection cn = null;
OleDbCommand cmd = null;
OracleStmt = "insert into TABLE2_HDB1(PURPOSE) values(@PURPOSE)";
ConString = " Provider=MSDAORA;Data Source=HDb1;User Id=SYSTEM
cn = new OleDbConnection(ConString);
cmd = new OleDbCommand(OracleStmt, cn);
cmd.Parameters.Add(new OleDbParameter("@PURPOSE", OleDbType.VarChar , 20));
cmd.Parameters["@PURPOSE"].Value = textBox6.Text;
textBox8 .Text = "record inserted successfully";
catch (Exception ex)
textBox8 .Text = ex.Message;
on executing this code u get the error :-
My Sql Server 2000 Table 'Feedback' structure is look like this.....Code, Q1, Q2, Q3 and records are like...
Code Q1 Q2 Q3
1 Good Good Average
2 Poor Average Average
3 Good Excellent Average
4 Excellent Good Good
I need to write a single query, which will give result look like.
Excellent Good Average Poor
Q1 1 2 0 1
Q2 1 2 1 0
Q3 0 1 3 0
Actually, this table is used to get the feedback from the users. User has given their feedback by selecting options. I need the details that how many persons answered Excellent for Question1 (Q1), Question2 (Q2), etc...As well as How many answered Good for Q1,Q2,Q3, etc....I need this format. Please help me.
I have written the following query in SQL Server but did not work saying error with the word PIVOT but worked with MS-Access
but I cannot create a table with the select statement.I want the Pivot Table to go in a table but the INTO [Table] doesn't work.
Following is the query
TRANSFORM Sum(Cap) AS AvgOfCap;
SELECT JobWorker FROM Cap GROUP BY JobWorker order by JobWorker PIVOT TimePeriod;