sql-server-cewebmatrixsql-server-ce-4
Using GetUTCDate in SQL Server CE 4
Consider a SQL Server CE 4 table with a non-nullable column: FooDate. The goal is to have the current UTC datetime as the default.
The function is not recognized by SQL Server Compact. Name of function GetUTCDate.
The function GetDate() works as expected as a default to a datetime column in SQL Server Compact 4.
Is GetUTCDate() supported in SQL Server CE 4 at all?
Solution
SQL Server CE supports a limited subset of T-SQL functions. GetUTCDate() is not one of them.
- Why can't I use an alias in a DELETE statement?
- SQL Server Compact error: Unable to load DLL 'sqlceme35.dll'. The specified module could not be found
- Reverse boolean (bit) value in SQL CE select statement
- Need INFORMATION_SCHEMA MetaData
- UpdateException when using SQL Server Compact with Entity Framework
- The selected object(s) use an unsupported database provider
- How to decipher/interpret the contents of a file as shown in a Hex editor?
- Cannot find namespace 'System.Data.SqlServerCe'
- Linq dbml interchangeable between SQL Editions
- What to select in catalog in platform builder to include SQL CE in image for windows CE
- How to use Scaffold-DbContext in .NET Core for SQL Server Compact (*.sdf File) database
- UPDATE on two INNER JOINed tables in SQL Server Compact 4
- Updating local SQL Server databases with ClickOnce Deployment
- Recommendations for detecting updates to prerequisites in Click once app
- How to copy database schema to enother database using SQL Server Compact in C#?
- SQL Compact 4 - Full-text search?
- How to convert SDF file database to SqlServer Database
- How to convert DateTime of type DateTimeKind.Unspecified to DateTime.Kind.Utc in C# (.NET)
- How to check if SQL column datatype is int and change if the condition is true
- Can't get sql server compact 3.5 / 4 to work with ASP .NET MVC 2
- How to subselect in where statement?
- Windows Phone Series: Local SQL Server Mobile/Compact information
- Using Entity Framework with an SQL Compact Private Installation
- Getting the information of a mobile device by connecting to it
- How do I set Identity seed on an ID column using Entity Framework 4 code first with SQL Compact 4?
- Open .sdf file in Visual Studio 2022
- how to open *.sdf files?
- Using Entity Framework with Sql Server Compact Edition without App.Config additions
- How to avoid writing same code for different types
- Using SQL Server Compact 4.0 with Windows Mobile 6.0 and ASP.NET 3.5