Q. What are temporary tables? when to use them? Ans. Temporary tables are used to store any data on a temporary basis. in Tempdb. ...
Register Now Click On
Read More Tutorials Click On
Post Page Advertisement [Top]
Q1. WHICH OF THE SYSTEM DATABASES IS LOADED FIRST? Ans. RESOURCE Q2. WHAT IS THE SIZE OF TDS PACKETS? Ans. 4096 BYTES Q3. ...
The database is a physical collection of files. Grouped into file groups. The database is logically a collection of tables. Groupe...
What is Store procedure in SQL server :- Stored procedures are database objects used to store any type of T-SQL statements. Advant...
What is Trigger and Types of trigger TRIGGERS : DATABASE OBJECTS USED TO STORE ANY TYPE OF T-SQL STATEMENT. THE STATEMENTS ARE...
Difference between delete and truncate in sql create table tblstudents ( std_id int, stdname varchar(30), age tinyint,...
How many types of system database:- SYSTEM DATABASES: Once we install SQL Server, a set of FIVE system databases are AUTO created...
install sql server 2012 step by step Step 1: Open installation media in new window then right click on setup file to run the setup f...