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,772 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
910 reads
Quite often in our day today activity we need to check the count of records in each table of the...
2013-04-03
711 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,765 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,306 reads
Below script will calculate total number of days based on the input from user from 1st Jan. Though we have...
2013-02-25
876 reads
Below code will display the week started along with the number of days completed in that week. For deriving this...
2013-02-24
560 reads
Below code returns remaining days in the month based on the input date. We can have this inside a function...
2013-02-24
426 reads
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Comments posted to this topic are about the item Restoring On Top II
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Comments posted to this topic are about the item Breaking Down Your Work
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers