I am sure this is a beginners question, but I need to convert .0000 (smallmoney) to .00 in SQL statement to display in label controls ( since I have 3 labels that display the column, it wld probably be easier to convert in SQL than to convert each label control.)
View 3 RepliesIn SQL ......
"reading_i" is smallmoney
"reading_f" is smallmoney
CAST(ABS((reading_i - reading_f)) AS VARCHAR)
I want four decimal places alwaysfor example
reading_i = 3.123
reading_f = 1.23
I want 1.8930 (always four decimal places)
How can convert DTS package from SQL Server 2000 to SQL Server 2005
View 2 Repliesi desgin web site with sqlexpress 2008 now i want to convert it to sql standard enterprise i can or not? if it posible how i can convert my database from sqlexpress limit to sql server standard unlimit
View 4 RepliesI have a problem, I have created a website that is run on local host database is make in 2005 sql server
now i am using sql 2008 and visual studio 2010 , I attach the sql 2005 mdf file in sql 2008 server and run it working correctly when we host it then it is not working
problem gives "NT NETWORK SERVICE FAILED "
how we can convert the sql 2005 mdf file to sql 2008 file.
insert the csv file fields into sql server database..how will do it.what will be the code for that...
View 5 RepliesHow to Convert Excel file to XML in the below order.
-
<Rootsection>
-
<section id="test">
-
<entry id="test1">
<ara>1</ara>
<eng>2</eng>
</entry>
-
<entry id="test2">
<ara>1</ara>
<eng>2</eng>
</entry>
</section>
-
<section id="test1">
<entry id="test3">
<ara>1</ara>
<eng>2</eng>
</entry>
<entry id="test4">
<ara>1</ara>
<eng>2</eng>
</entry>
</section>
</Rootsection>
convert the query in pic #3.
pic #1 is where the user will put the 3 fields.
pic #2 is the involved tables and data that we already tried, it works, but only through sql, how can we make the formula where datagrid will show the results.
1. http://i1188.photobucket.com/albums/z403/hell91131/8udh1nd12e2.png
2. http://i1188.photobucket.com/albums/z403/hell91131/wqrfefcwerfewf.png
3. http://i1188.photobucket.com/albums/z403/hell91131/qewrfewfewrgferge.png
I've created an application using ASP.NET with Access DB, now I found somee.com who support only SQL Server DBs, so Now I must convert my Access DB to SQL Server DB.
Is there any tool who can do the trick ?
This is some code I'm using in my web application :
Public Shared Function conecter() As OleDbConnection
Dim MyConnexion As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & System.AppDomain.CurrentDomain.BaseDirectory & "/Learning.mdb")
MyConnexion.Open()
Return MyConnexion
End Function
Public Shared Function lecture(ByVal requete As String) As OleDbDataReader
Dim Mycommand As OleDbCommand = conecter().CreateCommand()
Mycommand.CommandText = requete
Dim myReader As OleDbDataReader = Mycommand.ExecuteReader()
Return myReader
End Function
In this case, If I convert my database I must change the OleDbConnexion and other things or I can just leave them like that ?
Does anyone know how to convert a DATETIME COLUMN to TICKS in SQL Server?
View 1 RepliesI have a string in code behind like this
string html = "<asp:CheckBox ID="CheckBox1" runat="server" />";
So how to insert it into aspx page and when the page is rendering, it convert my string as i write it own in the webpag
I have a column (data type timestamp) in SQL Server 2008.Now I want to show this timestamp value in ASP.Net C# app as string. Is there any way to do that?I tried it using regular data fetching in ASP.Net but it produced System.byte[] as output rather than actual value. In SQL Server Management Studio values are represented as 0x000000000000B3C0
View 2 Repliesi have a select statement below. The result of r1- @r1 may be positive or negative.
i want it to always result as positive, so it is a negative number then it to show the same number as positive. can i do this?
e.g.
r1 = 7, @r1 = 4
r1 - @r1 = 3
but
if r1 = 5, @r1 = 6
r1 = @r1 = -1, but i want this to be 1, because i am trying to work out the difference between the two numbers.
can this be done within a select statement? my select statement is:
SELECT imageurl, (r1 - @r1) AS difference
I have an array list on my server side that i want to use on my client side as an array how can i do this.
View 1 Repliesi want to convert to today date into two slots
From = {1/4/2011 00:00:00}
To = {1/4/2011 23:59:59}
i able to do this using that code
[Code].....
i have a salary table that have data like this ID EmpNo mYear Net Salary 29 3 January 2010 29217 1210 3 February 2010 29217 2052 3 March 2010 29217 3102 3 April 2010 29447 4153 3 May 2010 29447 6376 3 July 2010 28803 7231 3 August 2010 28281 7893 3 September 2010 29303 5207 3 June 2010 29197 8874 3 October 2010 29303 10076 3 November 2010 31276 11318 3 December 2010 31216 12503 3 January 2011 31266 13880 3 February 2011 31266 13414 1613 January 2011 19445 12043 1613 December 2010 19445 10563 1613 November 2010 19445 9364 1613 October 2010 18150 6163 1613 June 2010 10075 8433 1613 September 2010 18150 5154 1613 May 2010 18806 But i want to create a view like this ID EmpNo ThisMonth Previous Month mYear ThisNetSalary PreviousNetSalary Net Salary 29 3 January 2010 December 2009 January 2010 29217 0 29217 1210 3 February 2010 January 2010 February 2010 29217 29217 29217 2052 3 March 2010 February 2010 March 2010 29217 29217 29217 3102 3 April 2010 March 2010 April 2010 29447 29217 29447 4153 3 May 2010 April 2010 May 2010 29447 29447 29447 5207 3 June 2010 May 2010 June 2010 29197 29447 29197 6376 3 July 2010 June 2010 July 2010 28803 29197 28803 7231 3 August 2010 July 2010 August 2010 28281 28803 28281 7893 3 September 2010 August 2010 September 2010 29303 28281 29303 8874 3 October 2010 September 2010 October 2010 29303 29303 29303 10076 3 November 2010 October 2010 November 2010 31276 29303 31276 11318 3 December 2010 November 2010 December 2010 31216 31276 31216 12503 3 January 2011 December 2010 January 2011 31266 31216 31266 13880 3 February 2011 January 2011 February 2011 31266 31266 31266 13881 3 March 2011 February 2011 March 2011 0 31266 0 5154 1613 May 2010 April 2010 May 2010 18806 0 18806 6163 1613 June 2010 May 2010 June 2010 10075 18806 10075 8433 1613 September 2010 August 2010 September 2010 18150 10075 18150 9364 1613 October 2010 September 2010 October 2010 18150 18150 18150 10563 1613 November 2010 October 2010 November 2010 19445 18150 19445 12043 1613 December 2010 November 2010 December 2010 19445 19445 19445 13414 1613 January 2011 December 2010 January 2011 19445 19445 19445 13415 1613 February 2011 January 2011 February 2011 0 19445 0.
View 4 Repliesnote MONTH AND DATES stored in single or double digits as they occur. Unfortunately DATE TIME is stored in NVARCHAR Data type column as 2/9/2010, 22/10/2010 etc. Following UK Date here. It is required to pull the data to COUNT No. of Expired. Obviously below one fails.
[Code]....
I'm trying to pass values in a SessionState from one page to another and then post them to a SQL database. When I click on the submit button on my submit page, I get this error:
Failed to convert parameter value from a String to a DateTime.
Here is my submit page:
[Code]....
I've verified that all of the input matches what I'm looking for on the SQL side.
Any code snippet or third party utilities to do this? Anything built into .NET libraries?
View 3 RepliesBefore hosting into server how can i convert into dll to host into server.
View 1 Repliesusing sql server 2005. I have a field containing a date that is stored in a table as nchar(8) with values being like (sample):
19890305
and I'm trying to write a query where this will be returned as mm/dd/yy, ex:
03/05/1989
does anyone know the sql syntax to do this?
How to i convert the data type in the address field? i keep getting an error
here is my code:
[Code]....
I have an application that uses a time date picker control to display a date from a sql (sql 2000) table. Casting from the table to the control works fine, but writing a selected date from the control back to the database does not, I was under the impression that a datatype 'date' in VB would be compatible with SQL datetime datatime, and obviously it is from sql to vb as the date is correctly displayed in the control reading from the table. How do I need to convert the value from the date time picker control to write into sql ?
View 2 Replieshow i canconvert number to word in sql server
like 100.255 = one handerd and 255
like financial bill
I just installed the SmallBusiness Starter kit from MSDN. I believe the starter kit by default points to MDF and LDF files in App_Data folder but I would like to use my SQL server instead. Could you please provide me with instructions on how to convert these two files in actuate tables in SQL server?
View 5 Replies