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    
post Jan 18 2020, 08:58 PM

Posts: 968
Joined: 21-September 14
From: Tampa, 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, Oracle & PostgreSQL db's.
Go to the top of the page
2 Pages V < 1 2

Custom Search

RSSSearch   Top   Lo-Fi    25th May 2020 - 06:18 PM