Remove time by datetime in SQL Server

SELECT DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0)

Comments

Post a Comment

Popular posts from this blog

HOW TO Use the NumericUpDown Control

HOW TO Use the NumericUpDown Control  Great help taken from  http://www.asp.net/ajaxlibrary/HOW%20TO%20Use%20the%20NumericUpDown%20Control.ashx NumericUpDown Demonstration NumericUpDown Description NumericUpDown is an ASP.NET AJAX extender that can be attached to an ASP.NET TextBox control to add "up" and "down" buttons that increment and decrement the value in the TextBox. The increment and decrement can be simple +1/-1 arithmetic, they can cycle through a provided list of values (like the months of the year), or they can call a Web Service to determine the next value. Page authors can also provide custom images to be used instead of the default up/down button graphics. Video - How Do I: Use the ASP.NET AJAX NumericUpDown Control? NumericUpDown Client Code Sample view plain copy to clipboard print ? < script   runat = "server" >        [System.Web.Services.W...
Read more

How to show help text in page on mouse move

Add this code in aspx.page ------------------------------------------  <a href="#" style="cursor: pointer;" onmousemove="ShowPicture('ChannelsHelpImageStyle1',1)"                                             onmouseout="ShowPicture('ChannelsHelpImageStyle1',0)">                                             <asp:Image ID="proofimg" runat="server" ImageUrl="~/App_Themes/IT/Photo/LanguageSkills_03.png" />                         ...
Read more

How to Do a Remote Shutdown for a PC on a LAN

Image
Steps 1 Open the command prompt.  This may be done by clicking on the "Start" button, and selecting "Run". Ad 2 Type in  cmd  and press Enter. 3 Type in  shutdown -m \\computername , replacing "computername" with the name of the computer you wish to shutdown or the computer's IP address. 4 Experiment with the shutdown command's switches. -r  will force a restart, disabling any services or user interaction from interrupting it. -c  "comment" will force a comment to appear on the system being shutdown. -t xx  will force a timeout for "xx" seconds. For example,  -t 60  would perform a shutdown after a 60-second timeout. -a  will abort the shutdown. A full command example:  shutdown -m \\myserver -r -c "This system will shutdown in 60 seconds" -t 60 5 Try another method: Type  shutdown -i  in the run window. Click the "Add" box and type the name of the computer ...
Read more