Date and Time Data Type in SQL Server 2008 In this post we will discuss about Date and Time Data Type in SQL Server 2008. SmallDateTime: Defines date with the time of the day in 24-hour clock format. Requires fixed 4-bytes to store data. It can have date between January 1, 1900 through June 6, 2079 and time between […]
Category: Sql Server
SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing
Globally Unique Identifiers (GUID) In SQL Server In this post we will learn about Globally Unique Identifiers (GUID) In SQL Server.Globally unique numbers(GUID) data type actually holds information that is designed to be created and viewed using the standard 32-digit hexadecimal format.To generate such a value, the NewId() function is called. Advantage: Unique across the server. Disadvantage: String values […]
Categories
What Is Linked Server?
What Is Linked Server? In this post i will let you know What Is Linked Server?.A linked server is simply a connection to an Object Linking and Embedding Database (OLEDB) data source.Technically, OLEDB is a Microsoft standard API for retrieving data from a wide variety of data.Linked server to enable the SQL Server Database Engine to […]
How To Insert Multiple Rows Using A Single Query Using Union All In this tutorial i will explain How To Insert Multiple Rows Using A Single Query Using Union All.We will insert multiple values through a single query using union all. Query: INSERT INTO Employee (Firstname ,Lastname ,Salary ,Department ) SELECT ‘Rajan’,’Singh’,5000,’ERP’ UNION ALL SELECT ‘Ram’,’Singh’,40000,’IT’ […]