Category: SQL Server

How to get the date part from the date time in SQL Server ?

If you are on SQL Server 2008 and higher version and want to get the date part of the datetime data in SQL Server , you can use the CONVERT method as shown in this post. How to get the date part from the date time in SQL Server ? If you want to get the current date leaving out the time from the datetime…

SQL Server Error Code – 4008 the data types varchar(max), nvarchar(ma

In this blog post, you’ll learn more about the SQL Server Error Code 4008 and the error message description that is shown SQL Server Error Code 4008 SQL Server Error Description for the Code :4008 The data types varchar(max), nvarchar(max), varbinary(max), and XML cannot be used in the compute clause by client driver versions earlier than SQL Server 2005.  Please resubmit the query using a…

SQL Server Error Code – 917 an upgrade script batch failed to execut

In this blog post, you’ll learn more about the SQL Server Error Code 917 and the error message description that is shown SQL Server Error Code 917 SQL Server Error Description for the Code :917 An upgrade script batch failed to execute for database ?%.*ls? due to compilation error. Check the previous error message for the line which caused compilation to fail.