Hello guys, sometimes while working with sql server we often create tables with wrong columns names and we often need to rename those columns. So we will see how to rename table column in sql server.
Hello guys, sometimes while working with big databases in sql server we often need to find all tables where we have used specific columns. So we will see how to do that.
Hello guys, sometimes while working with big databases in sql server we often need to find all procedures where we have used a certain table.So we will see how to do that.
Converting commas or other delimiters to a Table or List in SQL Server
Multiple rows to one comma separated value in Sql Server
Hello guys, sometimes while working with sql server, we sometimes face the need of working with json data . For that purpose we have to be able to read json data in sql which is quite a difficult task, so we will see how to read json in sql server in simple steps.
Hello guys, in this article we will create script for creating database backups from sql database server. We will use powershell script batch file for this purpose.