|
|
-
|
|
The unique identifier datatype is used to uniquely identify a row across various databases in the network. The value has 36 characters inclusive of digits from 0 to 9,alphabets from A to F and hypen. Suppose you have a string of 36 characters and want to know if it is really an uniqueidentifier. You......
|
|
-
|
|
This follows my other three posts at http://beyondrelational.com/blogs/madhivanan/archive/2011/05/03/sql-server-s-equivalent-of-oracle-functions-part-i.aspx http://beyondrelational.com/blogs/madhivanan/archive/2011/05/03/sql-server-s-equivalent-of-oracle-functions-part-ii.aspx http://beyondrelationa......
|
|
-
|
|
This follows my other two posts at http://beyondrelational.com/blogs/madhivanan/archive/2011/05/03/sql-server-s-equivalent-of-oracle-functions-part-i.aspx http://beyondrelational.com/blogs/madhivanan/archive/2011/05/03/sql-server-s-equivalent-of-oracle-functions-part-ii.aspx
ORACLE SQL Server
......
|
|
-
|
|
This follows my part I at http://beyondrelational.com/blogs/madhivanan/archive/2011/05/03/sql-server-s-equivalent-of-oracle-functions-part-i.aspx
ORACLE SQL Server
Decompose Cast or Convert (Ex cast(string as nvarchar(8000))
numtodsinterval select datename(dayofyear,DATE)-1,CONVERT(varchar(......
|
|
-
|
|
Often you may need to know what are the SQL Server's equivalent of ORACLE's function when you migrate your Database from ORACLE to Server.In this series of post, I will show you the SQL Server's equivalent of ORACLE functions.
ORACLE SQL Server
Decompose Cast or Convert (Ex cast(string as nvar......
|
|
-
|
|
You can change the datatype of the column with ALTER statement. You may think that it will never change the column values. But there are some cases where altering a datatype can cause changing the value of the column. Consider the following table
create table test(id int, dates varchar(100))
in......
|
|
-
|
|
SQL Server currently supports 37 different datatypes. But Many people may not know that there are some datatypes in SQL Server which are considered as Special datatypes. They are listed below
bit hierarchyid sql_variant sysname table timestamp Alias data types
They are knwon as special datatypes......
|
|
-
|
|
Sometimes you may be on need of knowing what the backup type of the backup file is. For example the backup file may be of full backup, transaction log, diffential database etc. If you want to know it before restoring a database you can use RESTORE HEADERONLY option
Assume that you have a backup fi......
|
|
-
|
|
One of the members in the SQL Server forum asked a question about querying the remote server without actually adding it as a Linked Server. One of the options to do this is to make use of the OPENDATASOURCE function
Assume that you have two servers Server1 and Server2. You want to query a table fro......
|
|
-
|
|
Alias name can be used in such cases like more than a table is used in the select statement, naming a derived column or table, etc. However the usage seems to be different among the RDBMSs. Consider the following examples which are valid in SQL Server
select t.* from table1 as t
select sum(t.a......
|
|