SQL Tables,Temporary Tables,Table Variables
Dec01

SQL Tables,Temporary Tables,Table Variables

Welcome to CodeSpread! SQL provides a variety of Tables. Lets summarize each one of them. Permanent Tables: Why do we require it? It is required for data persistence across the database. Once tables are created and filled with the data, this data is available for all the stored procedures and any DML statements can be run on them. Example: Create a Student table having id,name as attributes. Create table Student (Id int, Name...

Read More

How to create database with SQL express bundled with Visual Studio?

Yes, Visual studio comes bundled with a copy of SQL express edition which gets installed during visual studio installation. These steps are required to create database with SQL express bundled with Visual Studio. So guys, I request you all to please perform these steps while reading this article. View Server Explorer Add a Server Server Details Create Database Database details Choose Add Connection Add Connection Connection Properties...

Read More