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,806 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
938 reads
Quite often in our day today activity we need to check the count of records in each table of the...
2013-04-03
737 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,798 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,346 reads
Below script will calculate total number of days based on the input from user from 1st Jan. Though we have...
2013-02-25
899 reads
Below code will display the week started along with the number of days completed in that week. For deriving this...
2013-02-24
585 reads
Below code returns remaining days in the month based on the input date. We can have this inside a function...
2013-02-24
457 reads
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Comments posted to this topic are about the item Let's Talk Certifications
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers