Tag Archives: sql

Date and Time Functions in SQL Server 2008

Higher-Precision System Date and Time Functions  SYSDATETIME Returns a datetime2(7) value that contains the date and time of the computer on which the instance of SQL Server is running. The time zone offset is not included. Example: 2011-07-26 23:48:50.2038641 SYSDATETIMEOFFSET … Continue reading

Posted in SQL | Tagged , , , , , , , , , , , , , , , , , , | Leave a comment

SQL Server 2008 New DATETIME DataTypes

This article is going to cover the newly introduced data types in SQL Server 2008. The DATETIME function’s major change in SQL Server 2008 is the four DATETIME data types introduced. They are DATE, TIME, DATETIME2 and DATETIMEOFFSET. DATE Data Type … Continue reading

Posted in SQL | Tagged , , , | Leave a comment

SQL Server “Denali”: New Certifications

The Microsoft certifications for the next version of SQL Server, there will be seven exams: Four certification exams are planned for SQL Server “Denali” Business Intelligence roles: Writing queries with Transact-SQL (T-SQL) ETL Developer or Data Warehouse Developer. People in this role cleanse … Continue reading

Posted in SQL | Tagged , , , , , , , , , , , | Leave a comment

Entity Framework 4.0 – Learn to Create Databases from the Model

The ADO.NET Entity Framework (EF) is object relational mapping software for ADO.NET, used to develop applications that interact with data. It provides a mapping between the relational database schemas and objects. This technology is helpful for architecting, designing and developing … Continue reading

Posted in Links | Tagged , , , , | Leave a comment

Windows Application For Backup and Restore Database

In case that we develop various applications in development computer and want those applications to move on the client computer or any other computer for testing except that we need to copy those files, we need also backup the database and … Continue reading

Posted in Windows Applications | Tagged , , , , , | Leave a comment