Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
sql_server 217
t-sql 211
tsql 116
sqlserver 96
BRH 78
#SQLServer 66
#TSQL 56
SQL Server 34
function 11
SSMS 9

Archive · View All
August 2007 17
August 2010 8
June 2012 7
June 2011 7
November 2007 7
August 2012 6
May 2012 6
November 2011 6
August 2011 6
October 2011 6

Madhivanan's TSQL Blog

SQL Server's equivalent of MS Access functions - Part I

Jan 10 2011 3:39AM by Madhivanan   

Sometimes when you want to migrate from MS Accesss to SQL Server, you need to rewrite the queries compatible to SQL Server. As you know the basic systax is same but the functions used in Access should be replaced with their equivalent in SQL Server.

Here are some Access functions and their equivalent in SQL Server

----------------------------------------------------------------------------
ACCESS				SQL Server
----------------------------------------------------------------------------
Instr				Charindex
Mid				Substring
Chr				Char
LCase				Lower
UCase				UPPER
StrConv				Lower for value 1, 
				UPPER for value 2, 
				Initcap for value 3
& (concatenation)   		+ 
Trim				ltrim(rtrim())
Format				Convert
IIF				CASE WHEN
Switch				CASE WHEN
INT				CAST(col as INT) or CONVERT(INT,col)
Fix				CAST(col as INT) or CONVERT(INT,col)
Val				Extract numbers

Initcap function http://www.beyondrelational.com/blogs/madhivanan/archive/2010/07/19/initcap-function.aspx
Extract numbers http://www.beyondrelational.com/blogs/madhivanan/archive/2007/12/18/extract-only-numbers-from-a-string.aspx

Read Part II also

Tags: t-sql, sql_server, sqlserver, tsql, BRH, #TSQL, function, #SQLServer, Access,


Madhivanan
3 · 40% · 12958
2
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"SQL Server's equivalent of MS Access functions - Part I" rated 5 out of 5 by 2 readers
SQL Server's equivalent of MS Access functions - Part I , 5.0 out of 5 based on 2 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]