SSIS Data TypeSSIS ExpressionSQL Serversingle-byte signed integer(DT_I1)
two-byte signed integer(DT_I2)smallintfour-byte signed integer(DT_I4)inteight-byte signed integer(DT_I8)bigintsingle-byte unsigned integer(DT_UI1)tinyinttwo-byte unsigned integer(DT_UI2)
four-byte unsigned integer(DT_UI4)
eight-byte unsigned...
2017-06-08
1,768 reads
Script for Dimension table for Time.
Here Date_ID is the primary key which can be used as the foreign key...
2013-04-22
907 reads
Quite often in our day today activity we need to check the count of records in each table of the...
2013-04-03
709 reads
Scenario:
We need to find the first occurrence of character ie non numeric data in the string without using the built...
2013-03-01
2,761 reads
Case Study:1) We need to track the employee table in terms of new records inserted along with the datetime stamp
2) ...
2013-02-28
9,301 reads
Below script will calculate total number of days based on the input from user from 1st Jan. Though we have...
2013-02-25
875 reads
Below code will display the week started along with the number of days completed in that week. For deriving this...
2013-02-24
556 reads
Below code returns remaining days in the month based on the input date. We can have this inside a function...
2013-02-24
424 reads
By Brian Kelley
Following the advice in Smart Brevity improves communication.
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
I have table: t1 in schema1 with 19 billion records. I have another table...
Comments posted to this topic are about the item Minimally Viable Security
Comments posted to this topic are about the item Encoding NULL
What is returned from this code in SQL Server 2025?
SELECT BASE64_ENCODE(NULL)See possible answers