(Sushila D. Patel) Inserting a null value to the DateTime Field in SQL Server is one of the most common issues giving various errors. Even if one enters null values the value in the database is some default value as 1/1/1900 12:00:00 AM.
Other News
T-SQL Enhancements in SQL Server 2005
In this tutorial you will learn about T-SQL Enhancements in SQL Server 2005 – Data Definition Language Statements, .NET framework integration, Full Text Search, Index transact SQL Statements, Security Transact SQL Enhancements, Service Broker T-SQL statements, Synonym Transact SQL Statements, Table
Your First Script Component (Sample Chapter)
(Donald Farmer) In Chapter 2, you learned about the three types of Data Flow components in SSIS: sources, transformations and destinations. This chapter will describe these different types and show you how to create your fi rst transformation component using VB.NET in the Script Component. Once yo
Security elite hash out encryption alternatives
(Charlie Hosner) At this week’s Cryptographic Hash Workshop in Washington, DC, the giants of the cryptography field met to discuss the problem of our disintegrating hash algorithms. Today, the security of the algorithms that protect our online banking and digital signature systems is crumbling, and
Language Integrated Query (LINQ)
(Danny Thorpe) Language Integrated Query (LINQ) is clearly the hot topic of PDC this year. Windows Vista dominated the keynotes and looked very pretty up there on the screen, but nothing gets developers salivating like language enhancements. What is LINQ, really, and what does it mean for Delphi?
Instrumenting Applications with .NET Tracing
(Joe Mayo) Application instrumentation gives you the ability to perform runtime diagnosis of enterprise application state, which is critical to mission success. To help with instrumentation and logging, .NET ships with tracing types in the System.Diagnostics namespace. Using these types, you hav
Foreign and Legacy Data
(Michael Booth and Philip Greenspun) Most of the world’s useful data are either residing on a server beyond your control or inside a database management system other than Oracle. Either way, we refer to these data as foreign from the perspective of one’s local Oracle database. Your objective is alw
UDFs to ease migration: fun with bits, Booleans, and bitwise operations
(Marina Greenstein) Many relational databases (including Sybase, Oracle, Microsoft SQL Server, and Informix) support the bit data type or Boolean data type for column definitions, and provide bitwise or Boolean functions for these types of data. T-SQL also provides bitwise operations – AND, OR,
XML and Scripting Languages
(Parand Tony Darugar) For the purposes of this article, we will use a stock quote, expressed as XML, as our input file.
A Crash Course on ASP.NET Control Development: Deriving New Controls from Existing Classes
(Dino Esposito) This series of articles will look at creating ASP.NET controls. In this first article, Dino looks at deriving from the existing controls, and modifying their behavior.