Monday , December 11 2017
Home / DataBase / SQL SERVER (page 3)

SQL SERVER

How to Increase the SSMS Results Grid Font Size?

How to Increase the SSMS Results Grid Font Size? If we want to increase  font size for query editor we can easily increase  by using ctrl+mousewheel button. and if we want increase result window grid size then we can also easily increase its font size by using below steps 1.This is …

Read More »

Sql Server Data Types

sql_datatypes

Sql Server Data Types: 1.Numeric Datatypes : Data Type Maximum Size Explanation BIT Integer that can be 0, 1, or NULL. TINYINT 0 to 255 SMALLINT -32768 to 32767 INT -2,147,483,648 to 2,147,483,647 BIGINT -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 DECIMAL(m,d) m defaults to 18, if not specified. d defaults to 0, if not …

Read More »

Sql Server Important Queries

sql_queries

Sql Server Important Queries: 1.View All Tables in a Particular Database: [crayon-5a2e85a2bf071432825403/] For example if you want to know all table names which contains Sales [crayon-5a2e85a2bf080786609468/] 2.View All Triggers in a Particular Database: [crayon-5a2e85a2bf086696229460/] 3.View Any object definition: [crayon-5a2e85a2bf08d035013930/] in the place of Name we can give either table name …

Read More »

How to know when database Restored in sql server

sqldb_restore

How to know when database Restored in sql server: In some situation we want to know from which location and in which time database was restored.at that time we will use below query [crayon-5a2e85a2c0055109823327/] It will return below output: Thanks for reading this article if you like this article please …

Read More »

How to know object information in sql server

sql module

How to know object information in sql server: Suppose we are working on a supporting project or Application Maintenance and we are new to that application and we don’t have the full knowledge on that database, in that situation some times we need to work on below things we need to …

Read More »

When SQL Server Uses Indexes:

When SQL Server Uses Indexes: Sql sever uses indexes of a table provided the select or update or delete statement contained “where” condition in them and more over the where condition column must be a indexed column. If the select statement contain an “order by” clause also indexes will use. …

Read More »

Indexes in Sql Server one by one

studyclues_sqlserver_indexes

Indexes in Sql Server one by one:- Indexes: Indexes are created to Improve performance of data accessing or data retrieval Index Improves performance of “select” operation. Types of Indexes: 1.simple Index 2.composite Index 3.Unique Index 4.Clustered Index 5.Non Clustered Index Sample Tables: Table 1:EMPLOYEE [crayon-5a2e85a2c0ed9526177251/] 1.Simple Index:- If the Index …

Read More »

Set Operators in Sql Server (one by one)

SET OPERATORS

Set Operators in Sql Server (one by one): SQL server provides the following set operators which combines results from two or more Queries into a single result set. Those are: 1.Union 2.union All 3.Intersect 4.Except To combine the results of two queries we need to follow the below basic rules …

Read More »

SUB QUERIES

Subqueries

Subqueries:- 1.A query inside another query is known as subquery. 2.First inner query is executed then result of inner query is input for outer query. 3.Outer can be insert/update/delete/select 4.inner query must be always select. Types of Subqueries:- 1.single row subquery 2.Multirow Subquery 3.Co-related Subquery [crayon-5a2e85a2c2018467090232/] Sample Tables: Table 1:EMPLOYEE …

Read More »
Page 3 of 6
1 2 3 4 5 6