2014-12-11
2,106 reads
T-SQL
2014-12-10
2,211 reads
2014-12-08
1,833 reads
2014-12-05
1,965 reads
2014-12-03
2,077 reads
2014-11-27
2,264 reads
2014-11-26
2,086 reads
2014-11-21
2,031 reads
Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask
It is easy to import Excel data into database tables via TSQL, using OLEDB, either by the OPENROWSET function or linking to the spreadsheet as a server. The problem is that there are certain things that aren't obvious that you need to know about.
2014-11-21
11,773 reads
2014-11-20
2,214 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Kelapa Gading Raya HUB.Tlpn.0821•3111•185
BCA KCP Kelapa Gading Raya HUB.Tlpn.0821•3111•185 Jl. Boulevard Raya No.1 Blok L, Klp. Gading...
BCA KCU CIREBON HUB/CS 0821°697°7701
Jl. Yos Sudarso No.27, Lemahwungkuk, Kec. Lemahwungkuk, Kota Cirebon, Jawa Barat 45111
BCA KCU WISMA ASIA. Tlp/wa:0853-7373-7845
Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, Kota Bambu Sel., Kec. Palmerah, Kota...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers