Converting Numbers to Words in SQL Server
Creating a function in SQL Server to convert numbers to words can be quite useful, especially for generating checks, invoices, or reports. Here’s a step-by-step guide and a sample SQL…
Continue readingCreating a function in SQL Server to convert numbers to words can be quite useful, especially for generating checks, invoices, or reports. Here’s a step-by-step guide and a sample SQL…
Continue readingYou can use the DBCC SHRINKDATABASE or DBCC SHRINKFILE command to shrink the database or specific data files. However, be cautious when using these commands, as shrinking can cause fragmentation…
Continue readingIn SQL Server, you can find the data(value) from all tables if your database has a lot of tables, data, and columns. It is difficult to find them. SQL Server…
Continue readingIf you need to insert random numbers mixed with strings into your table in SQL Server insert them one by one with few records, it’s ok. But if you need…
Continue readingHi, Everyone. With SQL Server, when you want to split strings and insert them as two columns. So how to do it? Okay for this article, you can split strings…
Continue readingWith SQL Server, when you want to create a date scheduled for the month or year, you maybe add them one by one to the table. But this article, you…
Continue readingWith SQL Server Configuration Manager in Windows 10, if you cannot find it on the Windows search. So for finding it you can go to a path in the Windows…
Continue reading