Stats: 3,171,848 members, 7,882,968 topics. Date: Sunday, 07 July 2024 at 08:17 PM |
Nairaland Forum / Science/Technology / Programming / Convert Jet-sql To T-sql (1486 Views)
How To Convert Folder/file To Jpeg Format / Convert Code From Php To Vb.net / Help me convert this Vb6.0 code To Vb.net (2) (3) (4)
(1) (Reply)
Convert Jet-sql To T-sql by Sollyk(f): 5:38am On Sep 08, 2011 |
Please can someone help me to convert this JET-SQL to T-SQL SELECT IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])) AS [File As], IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name])) AS [Student Name], Students.* FROM Students ORDER BY IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])), IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name])); Please u can mail me d solution @ sollyk4u4real@yahoo.com Thanks |
(1) (Reply)
Sql For Joing 3 Tables In My Databse / The 3 New Javascript Apis You May Want To Follow / What Is The Difference Between Runtimeexception And Exception Classes?
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 7 |