<div>
Note that you could of course easily go back to dates prior to 1924 if you want to: just back up 1924 by even multiples of 12 years, the rest of the logic should function perfectly.<br />
<br />
By the way, % is the modulo (remainder) operator in SQL Server; on other systems it is MOD or \ or whatever else.
</div>


Note that you could of course easily go back to dates prior to 1924 if you want to: just back up 1924 by even multiples of 12 years, the rest of the logic should function perfectly.

By the way, % is the modulo (remainder) operator in SQL Server; on other systems it is MOD or \ or whatever else.

<div>
<div class="content wysiwyg-content">
Chinese Zodiac question:<br />
<br />
I have to write an SQL program which I have to find what animal is on my birthyear. &nbsp;I need to declare a date variable birth_date and assign it to my birthdate. &nbsp;Use an IF/ELSIF structure to test every year and determine the animal associated with my birth year. &nbsp;<br />
1924.36.48.60.72.84.96 - Rat<br />
1925.37.49.61.73.85.97 - Cow<br />
1926.38.50.62.74.86.98 - Tiger<br />
1927.39.51.63.75.87.99 - Rabbit<br />
1928.40.52.64.76.88.00 - Dragon<br />
1929.41.53.65.77.89.01 - Snake<br />
...................... - Horse<br />
...................... - Sheep<br />
...................... - Monkey<br />
...................... - Chicken<br />
...................... - Dog<br />
1935.47.59.71.83.95.07 - Pig<br />
<br />
output should be this<br />
dbms_output.put_line('I was born in ' || year || ', which is the year of the ???') ??? = whatever animal is in that year.
</div>
</div>


Chinese Zodiac question:

I have to write an SQL program which I have to find what animal is on my birthyear.  I need to declare a date variable birth_date and assign it to my birthdate.  Use an IF/ELSIF structure to test every year and determine the animal associated with my birth year.  
1924.36.48.60.72.84.96 - Rat
1925.37.49.61.73.85.97 - Cow
1926.38.50.62.74.86.98 - Tiger
1927.39.51.63.75.87.99 - Rabbit
1928.40.52.64.76.88.00 - Dragon
1929.41.53.65.77.89.01 - Snake
...................... - Horse
...................... - Sheep
...................... - Monkey
...................... - Chicken
...................... - Dog
1935.47.59.71.83.95.07 - Pig

output should be this
dbms_output.put_line('I was born in ' || year || ', which is the year of the ???') ??? = whatever animal is in that year.

IF/ELSIF program in SQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.