[T-SQL] creating table for fiscal year |
| creating table for fiscal year Posted: 19 May 2013 11:10 PM PDT hi alli want to create table for fiscal year in sql server 2012.the fields are :1-ID2-StartDate3-EndDatebut i have some problems with ID column ,i want to set it for the first year(2013)Id int identity(2013,1)when i insert the first records in 2013, ID for that record is 20131, and for the second one 20132, and ...next year it must be set to id int identity (2014,1)how can i do that?changing values of identity column ? |
| Posted: 19 May 2013 06:50 PM PDT All,I want to display -0 when i run the below queryselect 0.0*-1 |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / T-SQL (SS2K8) To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment