Dealing with Dates: Data Types and String Conversions (SQL Server)
Posted on
3,318 Points
5:18
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
0 Comments
Suggested Videos
| Title | Views | Activity |
|---|---|---|
| Set Up Backup with Maintenance Plans (SQL Server) | 507 | |
| SQL - Inserting Data | 187 | |
| Query data with no SQL code (7) | 23 | |
| Query data with no SQL code (10) | 36 |
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.
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.
Suggested Courses
Next Video:SQL - Updating and Deleting Data