SELECT REPLACE(CONVERT(VARCHAR, CONVERT(MONEY, TotalArea), 1), '.00', '')
FROM table
Saturday, December 14, 2019
thousands separator for a column
Wednesday, December 4, 2019
MSQL password reset cmd
C:\WINDOWS\system32>Osql -S [computer_name] -E
1> EXEC sp_password NULL, ’123456’, ’sa’
Monday, December 2, 2019
FileUpload Control in Update Panel using ASP.NET AJAX
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server"><title>Untitled Page</title>
</head>
<body><form id="form1" runat="server"><asp:ScriptManager ID="ScriptManager1" runat="server" /><div><table width="50%" cellpadding="2" cellspacing="0"><tr><td><asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="conditional"><ContentTemplate><asp:FileUpload ID="FileUpload1" runat="server" /><asp:Button ID="Upload" runat="server" Text="Upload" OnClick="Upload_Click" /><br /><asp:Image ID="NormalImage" runat="server" /></ContentTemplate><Triggers><asp:PostBackTrigger ControlID="Upload" /></Triggers></asp:UpdatePanel></td></tr></table></div></form>
</body>
</html>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server"><title>Untitled Page</title>
</head>
<body><form id="form1" runat="server"><asp:ScriptManager ID="ScriptManager1" runat="server" /><div><table width="50%" cellpadding="2" cellspacing="0"><tr><td><asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="conditional"><ContentTemplate><asp:FileUpload ID="FileUpload1" runat="server" /><asp:Button ID="Upload" runat="server" Text="Upload" OnClick="Upload_Click" /><br /><asp:Image ID="NormalImage" runat="server" /></ContentTemplate><Triggers><asp:PostBackTrigger ControlID="Upload" /></Triggers></asp:UpdatePanel></td></tr></table></div></form>
</body>
</html>
Subscribe to:
Posts (Atom)