Tag: SQL Server

Webinar – SQL Server on Linux Next Steps

Microsoft SQL Server Team is hosting a webinar on the topic “SQL Server on Linux Next Steps on 31st January , 2017 at 9pm PST. This Webinar covers the following– The latest updates to SQL …

SQL Server’s ISNULL() equivalent in PostgreSQL

SQL Server provides an function ISNULL if the value placed in the 2nd parameter if the first parameter passed to the function ISNULL is null. For example , SELECT ISNULL(Designation,’ ‘) from Employee This will …

WAITFOR TIME in SQL Server

If you want to pause the execution of the code block until a specific time is reached , you can try using the WAITFOR TIME statement in SQL Server. For example , you want the …

WAITFOR DELAY in SQL Server

If you want to pause the execution of the code block for a specific amount of time , you can try using the WAITFOR DELAY statement in SQL Server. For example , you want to …

Wildcard Search in SQL Query

There are times when you don’t have a specific value to find but you might have to use the general pattern and want to get the records that match that pattern. You can use the …