Useful tips for everyday
How can store long text in SQL Server? If you want to store large amounts of text in a SQL database, then you want to…
How do I restore my Bacpac file? Steps to Import/Restore BACPAC file Open SQL Server management studio, connect to SQL instances where you want to…
How do I fix Error 40 in SQL Server? Make sure that TCP/IP is enabled. To make it enable follow the steps: Click on Configuration…
How copy database from another database in SQL Server? Launch the Copy Database Wizard in SQL Server Management Studio from Object Explorer and expand Databases.…
How do I compare two column values? Compare Two Columns and Highlight Matches Select the entire data set. Click the Home tab. In the Styles…
How to calculate file size for SQL Server? Get a list of database files with size for all databases in SQL Server: 1 sys.master_files DMV…
How to insert values in table in MySQL? VALUES (VALUE_1,VALUE_2,..) In syntax, First, you must specify the name of the table. After that, in parenthesis,…
Which clause is used while creation of foreign key? A foreign key is a column or group of columns in one table that contains values…
How can I get all data from a table in SQL? 5 Answers Run SELECT information_schema. TABLES. TABLE_NAME FROM information_schema. TABLES where table_schema=’db_name’ Create a…
What is the difference between cast and convert function? 1. CAST and CONVERT are two SQL functions used by programmers to convert one data type…