You might encounter the error “Conversion failed when converting from a character string to uniqueidemtifier” while working in an SQL server. This error is because you are trying to convert a string value to uniqueidemtifier in SQL but the conversation fails because a string is… Read More »Resolve: Conversion failed when converting from a character string to uniqueidemtifier
A lot of times we come across issues when our disk space is consumed and we need to move our database MDF & LDF files from their default location. In an earlier version of SQL Server, you have to use Detach and Attach method in… Read More »Move SQL Server MDF and LDF Files location
A lot of times we come across issues comparing dates in SQL. There are a few scenarios below Compare dates in the DateTime Column Select * from EMP WHERE datetime_column >= ‘20221220 00:00:00.000’ AND datetime_column < ‘20221221 00:00:00.000’ Compare Day Year Month separately in DateTime… Read More »Compare dates in SQL