What is RDBMS

What is RDBMS? RDBMS stands for relational database Management System. RDBMS is that the basis for SQL, and for all information systems like MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access. A relational database management system (RDBMS) could be a management system (DBMS) that’s supported the relative model as introduced by E. F. […]

Continue Reading →
 

SQL Create DataBase

SQL Create DataBase The CREATE DATABASE Statement is used to create a database in SQL. After creating a database, we can create some other database objects like  (tables, views, procedures etc.) into it. The user should have admin privileges for creating database.: SQL CREATE DATABASE Syntex: CREATE DATABASE database_name   CREATE DATABASE Example: If you […]

Continue Reading →
 

Difference between truncate and delete in sql

TRUNCATE When you TRUNCATE a table less information is logged.  This means the TRUNCATE statement executes very fast; however, it does so at the expense of not logging each row deleted. This means, that you need to be very careful when using the command (actually be careful with DELETE as well!). Truncate Syntax TRUNCATE TABLE UserMaster Truncate […]

Continue Reading →
 

Difference between function and procedure in sql

Functions and stored procedures are set of SQL statements that can be called by name. They have many similarities like they take arguments, used to perform required tasks and have same programming style and structure. But we are more interested in differences to grab the knowledge about power they held against each other. So here […]

Continue Reading →
 

Difference between varchar and nvarchar in sql.

Hi i am explaining the major difference between the VARCHAR and NVARCHAR Data Type in Sql Server: Varchar Non-Unicode Variable Length character data type. Example: DECLARE @Name AS VARCHAR(50) =‘PAWAN SHUKLA’ SELECT @Name It takes 1 byte per character Example: DECLARE @Name AS VARCHAR(50) = ‘PAWAN SHUKLA’ SELECT @Name AS Name, DATALENGTH(@Name) AS Length Result: […]

Continue Reading →