I was working in a finance application. Recently we discovered the simple mistakes done the datatype and its dangerous implications.
1. Temp table column data type
We had a report SP which has temp tables. The data type of temp tables are set exactly matching to the base column. But when the report is executed it gets the consolidate values, so the data lost is happening.
In the latest stage of the project we have change the data from INT to GUID, which lead to break the existing codes. We need to have a special consideration for GUID data type.
When declaring the VARCHAR it is mandate to specify size of the VARCHAR other it will be defaulted to 1 and data lost will happen.
Whenever you data has multi language characters we must use NVARCHAR, if you use VARCHAR the charters are set o ?.
I need to check in a table, is the all day data available, here is the handy script to check the same.. DECLARE @startdate DATETIME ...
What is view state and use of it? The current property settings of an ASP.NET page and those of any ASP.NET server controls contained with...
In SQL Server Integration services, we have Script Component, which can be used in Data Flow Task as Source, Destination or Transformation. ...