Search This Blog

I.T. Notes

Fellowship of Technology... http://www.bbtechnologies.co.uk https://www.linkedin.com/in/muhammetatalay https://bbtechnologies.co.uk https://github.com/TheMaty https://muhammetatalay.blogspot.com

Posts

Showing posts with the label Get only Date from Current Date

Show All

get only date from Current Date in SQL

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

- August 11, 2011

Hi, CONVERT(DATE,GETDATE()) cheers, P.S:Please do not hesitate to share your comments.

Hi

How may I help you?
Type your question below

Labels

.net Framework and .net Standard are in same Visual Studio Project
"the requested formId is not a valid form to display for this user" in Dynamics CRM 2016
0x80040237
0x8004A106
1 to N
80042802
A surprise from Microsoft Visual Studio 2010 to the C++ developers
access to SQL Server from Oracle Sql Developer Tool
Access to the temp directory is denied in Internet Information Server 7
activating Business Process Flow with C#

ActiveX
add exception class
add params to DISP_FUNCTION_ID
Add Web Resource BizTalk 2006
Adding Web resource to custom solution in Dynamics 365 CE
Apple's Visionary
Archiving
aspx
Assembly Microsoft.Dynamics.Service.Plugins.dll can not be loaded. Dynamics CRM 9.0 onpremise
Asynchronous Service
Attempted to read or write protected memory
Auto complete
Auto fill or Auto Suggestion for Textbox in Dynamics CRM from
Axapta 2009
aynchronous method calls in Windows Service
Azure
Azure Active Directory Domain Services
Azure Pipelines agents
Azure Point-to-site
Azure virtual network gateway
backup SQL Server Database Windows PowerShell
Bearer Token
Blogspot
bot
Business Process Flow creation with C#
C#
Calendar for SSRS reports is stuck "loading" in Dynamics 365 CRM/CE on-premise
call Image type Web Resource from Microsoft Dynamics CRM 2011 from javascript or HTML
can not create courceName in LogName
can not deploy PlugIn through CRM Development Toolkit
Cannot locate resource .xaml
cariage return in Office Word document
chatbot
Chatbot step by step instruction
chm file
Claim Based authentication
Cleansing
CodeToRunElevated
Com InterOp Error
command batch
Connections MSCRM 2011
Connections SDK Microsoft CRM 2011
context object by crmsvcutil.exe
copy
could not load file or assembly
Could not write to output file -- 'The directory name is invalid
Create Constraint Microsoft CRM SDK
Create Event Log in C#
Create File in VBScript
Create Relation
Create Resource Group Microsoft CRM 2011 SDK
CreateSite
Credentials
Credentials and Tokens in Microsoft CRM 2011
CRM 3.0
CRM 30
CRM approaches for Web Ontology
CRM Developer Toolkit in Dynamics 365 CRM
CRM Explorer is now invisible.
CrmServiceHelper for Dynamics 365 Customer Engagament
Current Date in SQL Server
Cursor
Custom Controls
Custom Lookup
custom screenshot
Custome Snipping tool
Date
DBCC SQLPERF
de-fragmentation
Default Property
DEFINE_GUID C++
defragmentation sql statement
Dennis Ritchie
Design Time Form Error
DevOps
Dies at 56
digital architecture
Digital Transformation
disable Credential
DISP_FUNCTION_ID in ActiveX build in VC++
Distributor Agent error
Docker Desktop for Windows
Dynamic classes
Dynamics 365
Dynamics 365 CE on-premise
Dynamics 365 CRM on-premise
Dynamics 365 CRM Onpremise Version 9.x throws error for Calendar Control
Dynamics 365 Solution Template for Visual Studio 2019 Community Edition
Dynamics 365 Solution Template for Visual Studio 2019
Dynamics AX
Dynamics CRM 2011 installation error
Dynamics CRM 2013
Dynamics CRM 2016 Maintenance
Dynamics CRM 365 Developer Tools
Dynamics CRM multiple Domains
Dynamics CRM online
Dynamics CRM timeout
Dynamics CRM with Gmail
editable
Entity Framework
Entity Relationship
Error
error C2065 undeclared identifier in atlconv.h
error C2065: 'CW2A' : undeclared identifier
Error Code : 126
Error code : 80042802
Error executing a batch of commands
Error executing a batch of commands Retrying individual commands
error LNK2001: unresolved external symbol Visual Studio 2010
Error using COLE2T C++
Evaluate Credential
EventLog
EventLog.CreateEventSource Error
Events
EventViewer Class
EventViewer Error
Execute query in VBScript
Executing user
export apppool
export IIS configruation from Commad prompt
export IIS configuration
export iis web site
export Rewrite Rule
Expose HTML Input events for Dynamics 365 online and PowerApps
Father of C and UNIX
FETCH NEXT
FetchXML
File Server with node.js and Express web framework
FilterLookup in CRM 2011 with Javascript
find any text in Stored Procedures
Forgot Windows 7 Password
Forgot Windows XP Password
Functions
get column's value from LinkedEntities
Get only Date from Current Date
Get PickList value with SELECT CRM 2011
get rows as column in sql server
google chrome
Governance
hash value expired
hInstance
Hiren Boot CD with USB boot
HookManager
Hotmail or other authentication vendors like oAuth...
icon Navigation Bar
identity ranges for the subscription problem
IDL File
IIS 7...
import exported data
import huge data
Import IIS configuration
Import iis web site
ImportSolutionRequest
in correct format
index fragmentation
insert resource to resource group Microsoft CRM 2011
Install Microsoft CRM 4.0 Data Migration Manager
installation
Installation and Configuration guide of Nuget Server
Installation Dynamics CRM 365 on-premise
Installation of Microsoft Visual C++ Runtime failed. Exit code: 5100. Result: Asia
Integration
IntelliSense unavailable for C++/CLI
Interactive blog
Isolated Operating System
ISV code aborted the operation
Jobs
JSON Web Token
JWT
Kerberos Authentication
Kill a program in VBScript
Language Understanding Intelligent Service
Language Understanding Intelligent Service Step by step
Late Bindind
Linked Entities
log4net as windows service problem
log4net configuration sample for File appender.
log4net usage
LUIS
make Dynamics CRM smarter with Chatbot
mandatory) based on given rule(s) in Dynamics CRM by utilising JSON object
Mapping Entities
massive changes on field appearance (visible
Massive Workflow Runs Cancellation automatically
Maximum Received Package
Memory based Test Execution in Dynmaics CRM for PlugIns
Merge Replication
MERGE REPLICATION SQL SERVER
Message property name 'Target' is not valid on message Create. ErrorCode: -2147204757
methods load
MFC
Micosoft CRM timeout
Microsoft Bot Framework
Microsoft Bot Framework Emulator
Microsoft Compiled HTML Help files
Microsoft CRM 2011
Microsoft CRM 30
Microsoft CRM 4.0
Microsoft CRM 40 Max Rows 5000
Microsoft Custom Connector
Microsoft Dynamics CRM Data Migration Manager
Microsoft Flow
Microsoft Power Apps Portal
Microsoft Power Automate
Microsoft Visual C++ runtime
Microsoft Visual Studio 2010
Microsoft Visual Studio Error
Microsoft Workflow Runs Cancellation
Microsoft.Crm.Tools.FaxConnectorService.FaxSinkServiceException
MIDL2020
Migration
Mouse Pointer
MSCRM 30
MSCRM_DataSource
MSCRM_DataSource cannot be found.
MSCRM30
MSCRMFaxRouterService
Multi Framework Targeting
Multi Selection
Multiple Entity
MVC
N to N
n to n query in Microsoft CRM 2011
Navigation to the webpage was canceled‏
new repository in local
node.js code samples
Norton Ghost
Not For Replication Property
Nuget for Visual Studio 2017
Nuget for Visual tudio 2017
Nuget in Windows Server 2016
Null
On-Premises data gateway
Operation Type
Ophcrack
Oracle
Oracle 11g SQL Developer can not find Java Virtual Machine in 64 bit Operating Systems
Oracle SQl Server 2008
OWIN
Passes Away At Age 70
PCF
PIVOT in SQL Server
PowerApps
PowerApps Component Framework
Projects QUBES Secure Operating System
properties
publish package to local Nuget.Server via command prompt in Windows Server"
publish web site to 64 bit system
QnA Maker
QueryBase Microsoft CRM 2011
React Native code samples
Reflection
Regulation for Data in Dynamics 365 Deliveries.
replace new line
Replication
ReportViewer
restore windows 7
restore windows vista
Retrieve
Retrying individual commands
return params in DISP_FUNCTION_ID
Role comparision
role member
Rows Count on Tables in selected database
ScaleGroupOrganizationMaintenanceJobs
schedule job
SCOM
screen shoter
Screen Width or Height
SDK
Search text in Stored Procedure
Semantic Web
Serialize and Deserialize in C# with generics
Set Visual Studio Project with ATL Support
SetWindowsHookEx
Share Point Server
Snipping Tool
Sometimes you may suffer from copy from word (html table or any other text resource) and paste to the excel which results distribute single rows into consecutive sheet sequence.
SQL developer Tool
SQL Integrity
SQL Server
SQL Server 2005
SQL Server 2005 Replication
SQL Server 2005 Rows Count
SQL Server 2008 Setup requires .NET Framework 3.5 SP1 to be installed.
Sql Server 2008 x32 installation error
Sql Server 2008 x64 installation error
SQL Server Performance
sqlldr in Oracle
SSRS report error
Step by step Installation and Configuration
step by step intruction guide
Steve Jobs
Stored Procedure
String
Subscribing Windows Server to the Azure Active Directory Tenant
System.Runtime.InteropServices.COMException 80040202
Technical Design Document
Teradata Exception in SQL Reporting Server
The collection is read-only
The path is not of a legal form
The specified module could not be found
This is often an indication that other memory is corrupt
Thread Id
Timeout
TimeoutException
Timer
track your job applications
Transaction Base Manupulation in Stored Procedure
Try Catch in Stored Procedure
two speed architecture
Two State Monitor Script in SCOM
typescript code samples
Ubuntu on Windows
Unable to get property {Entity Name} of undefined or null reference Dynamics CRM WebApi
unistall Oracle 11g from Windows 7 x32 x64
Unit Test for Dynamics 365 CRM / CE PlugIns and Workflows.
Universal USB Install
Update and Assign records in Microsoft CRM 2011
upgrade RHEL from 7.2 to 7.4 - install unzip rpm - unzip zip file - upgrade RHEL from ISO file
upload files to the github
User Control
user creation error
user current setting in Microsoft CRM
VBA.Weekday
Visual C++ 5.0 Professional Edition
visual studio .net must be installed before you can install the Microsoft Dynamics CRM Developer Toolkit
Visual Studio 2005 projects compatibility problem
Visual Studio 2008 building error
Visual Studio 2008 projects compatibility problem
Wael Hamze
waitstats
WCF
Web Request from Sandbox mode in Dynamics CRM
Web Site
WebAPI
Windows 2008 Server
Windows 7
Windows 7 compatible problem
Windows Communication Foundation
Windows Management Instrument Tester
Windows Presentation Foundation
Windows Server 2003 SBS
Windows Subsystem for Linux
Windows Subsystem for Linux WSL 2
windows Vista
x64 bit
XMLAttribute
XMLElement for mapping object with XML tags
XMLSerializer
XRM CI Framework

Show more Show less