Code Maker BD | code simply: sql

Showing posts with label sql. Show all posts

How to generate SQL database script ?

Here we try to show How to Generate a full SQL database script in new query editor window step by step. We use SQL Server 2017 here. We h...

1. Insert stored procedure : create proc sp_tbl_Employee_Insert ( @name nvarchar(50), @gender nvarchar(50), @salary nvarchar...

To create a new table we have to write the code below in our query editor window: use MyDB go CREATE TABLE [dbo].[tbl_Employee]( [i...

If we want to create a new database in sql server first of all we have to open (connect) our sql server management studio. After connecting...

SQL stand for structured query language. This is a relational database management system designed for use in corporate applications, both o...