I'm running an Access 2016 Front End and a SQL Server 2014 back end. I'm unable to Update Access Date fields in my project.
I can't seem to get Access and SQL to communicate when it comes to Dates. The project I'm working on …
![SQL]()
SQL
SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data....
Read more- 59K Content
- 7.7K Contributors
Expert Spotlight
Technical Director
Dynamic seasoned IT Professional with over 30 years experience. .Net and SQL Server expert
Leading Experts In
Troubleshooting Solution
Article
Dynamic Pivot Procedure for SQL Server
by Mark Wills
PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type …
PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type …
Video
Repair Corrupt SQL Database with Stellar Phoenix SQL Database Repair Software
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues…
Post
This is a cool tool to help visualize explain plans in …
This is a cool tool to help visualize explain plans in postgres: https://explain.depesz.com/
Post
So excited for SQL Server 2017. …
So excited for SQL Server 2017.
…
…
Post
Sequential or Random Rows in Microsoft Access Study my …
Sequential or Random Rows in Microsoft Access
Study my new articles on this topic…
Study my new articles on this topic…
Article
Union All Handling in SQL Server
The UNION ALL (or UNION) operator is used to combine different result sets. This article focuses on handling the UNION ALL operator in a better way.
Article
Transform Text copied from Excel Table into Real Table in SQL
After looking into a question at EE, a thought came to my mind that I considered would make a good article. "Transform Text copied from Excel Table into Real Table in SQL" as it is totally possible to do. Here's the result.
Article
How to Resolve DBCC CHECKDB Stuck in a Killed/Rollback State
This article discusses various scenarios that can end up in a DBCC CHECKDB process getting stuck in a Killed/Rollback state and how to resolve the problem.
Troubleshooting Solution
Adding different values from a table to find a specific sum value
There are times when I need to find a certain value out of a number of records. For example, assume …
Post
It's interesting to see where the SQL co-creator sees …
It's interesting to see where the SQL co-creator sees similarities between SQL and NoSQL. …
Article
A SQL Tidbit: Conditional Aggregates
As they say in love and is true in SQL: you can sum some Data some of the time, but you can't…
Troubleshooting Solution
Troubleshooting Solution
SQL Server - running a stored procedure to run a SELECT statement that's passed as a parameter
I'm building a learning tool. A the client app will send a Exec statement to run a stored procedure, …
Post
I haven't worked with SQL Server since 2001. Now I'm trying …
I haven't worked with SQL Server since 2001. Now I'm trying to configure SQL Server Reporting …
Article
Beware of Between
'Between' is such a common word we rarely think about it but in SQL it has a very specific …
Troubleshooting Solution
SQL - Select Same WeekDay from a Previous Year
Hi,
I would like to select the same WeekDay from a previous year.
For last year (e.g. comparing 2021 …
I would like to select the same WeekDay from a previous year.
For last year (e.g. comparing 2021 …
Troubleshooting Solution
update statistics of column store index
right now we are receiving a job failure message from an index statistics job:
and the statistics …
and the statistics …
Article
Who filled transaction log of SQL Server database?
This article guides you in finding the user, process and host, which produced too many transactions filling the transaction log and preventing you from shrinking it.
Troubleshooting Solution
Problem with Trigger insert
I am trying to get this trigger to insert the correct data. I seem to be losing the scope_identity …
Explore solutions and more
SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.