How to Insert a DateTime Value into an Oracle Table
May 6, 2016 · This article explains how to insert a DATE with or without a time into an Oracle table using the INSERT statement.
Import Data from a Text or CSV file into SQL Server
Nov 10, 2011 · I was recently in need of importing data from a CSV (Comma Separated File) to a table in SQL Server 2008. After searching in Google for a little while, I found this blog entry from Pinal …
Create and Populate Date Dimension for Data Warehouse - CodeProject
Sep 5, 2013 · This article shows how to create and populate date dimension for data warehouse.
Handling BULK Data insert from CSV to SQL Server - CodeProject
From this article, developers will get some useful guidelines on bulk data insertion in SQL Server.
Using Table-Valued Functions in SQL Server - CodeProject
Mar 11, 2011 · The easiest way to start creating a table valued function (well, actually any function or procedure) is to use SQL Server Management Studio and start creating an anonymous T-SQL block.
Sargable query in SQL server. - CodeProject
Oct 13, 2014 · Index scan: Here SQL server scan/reads all the record of the table to return the required rows. It is slow. But for table with small amount of data, where it is needed to fetch all record this …
Excel Macro to Generate Database Insert Script - CodeProject
Jul 13, 2019 · It is easy to make those changes in Excel for those who don't know SQL Server. For example, your Business Analyst or client gave you a set of configurations/master data which directly …
SqlServer & EF7: Using datetime vs datetime2 date type
Jun 9, 2023 · A newer version of SqlServer data type “datetime2” has better accuracy and no rounding problem. Usage of .NET Entity Framework just contributes to confusion during work with SqlServer …
Simplifying Dynamic SQL Queries with Dapper - CodeProject
Dec 9, 2023 · The library provides two builders for building SQL queries: Builder - for building static, dynamic and complex SQL queries Fluent Builder - for building dynamic SQL queries using fluent …
Simple ADO.NET Database Read, Insert, Update and Delete using C#.
May 31, 2001 · Again we will use a simple SQL statement. Deleting data. Using SQL. These operations will be performed against a Microsoft Access 2000 database, however SQL or other ADO data …