14 blogs found
Hello guys in this tutorial , we will learn the first step of using sql server. We will see how we can create database and perform crud operation using sql queries.
Setting up database on plesk server
Database Backup .bak
1418 (HY000) at line 10185: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)
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
The GROUP_CONCAT() function was built specifically for the purpose of concatenating a query’s result set into a list separated by either a comma or a delimiter of your choice.
How to create a read-only MySQL user
How to Connect to a Database with MySQL Workbench
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.