UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> SQL Get Date From A String Or Long Integer, SQL Server 2012    
 
   
FrankRuperto
post Jan 18 2020, 08:58 PM
Post#21



Posts: 649
Joined: 21-September 14
From: (MilitaryBrat) Tampa Bay, Florida, USA


I don't think you can remove dbo because that's the schema name and a table always has to belong to a schema. You cant have a table with no schema, but since dbo is the default schema name, if the user schema name is also dbo (by default), then you can omit using the dbo prefix and just use the function name. You can also just use [tblName] instead of [dbo].[tblName]. You could also rename the table's schema name with ALTER SCHEMA to match the user schema name if its not the default dbo name.
This post has been edited by FrankRuperto: Jan 18 2020, 09:29 PM

--------------------
Currently supporting pawnbrokers that use my store management system developed with Access 2010 on Windows7. Experienced with Informix and Oracle DB's.
Go to the top of the page
 
2 Pages V < 1 2


Custom Search


RSSSearch   Top   Lo-Fi    21st February 2020 - 10:16 PM