Codebarlet - codebarlet.com - SQL Server Tips and Tricks
General Information:
Latest News:
Changing database collation 20 Mar 2012 | 10:35 pm
Changing database collation “A collation encodes the rules governing the proper use of characters for either a language, such as Greek or Polish, or an alphabet, such as Latin1_General (the Latin alp...
Changing database collation 20 Mar 2012 | 06:35 pm
Changing database collation “A collation encodes the rules governing the proper use of characters for either a language, such as Greek or Polish, or an alphabet, such as Latin1_General (the Latin alph...
Ranking in SQL Server 2008 24 Feb 2012 | 03:33 am
Ranking in SQL Server 2008 People do a lot of ranking in their business every day for several reasons. Statistics, checking for best selling product, checking for best customer and etc. In SQL Server...
Explicit and Implicit Transactions 4 Feb 2012 | 05:22 am
Explicit and Implicit Transactions In SQL Server transaction is when you have several operations and you want to run it as one. If your code runs successfully then you do a commit and you end the tra...
User Defined Function in SQL Server 3 Feb 2012 | 02:44 am
User Defined Function in SQL Server In this article you will read and understand the types of User Defined Functions or shortly called UDFs, how to create UDFs and how to use them. There are 3 types ...
User Defined Function in SQL Server 2 Feb 2012 | 09:44 pm
User Defined Function in SQL Server In this article you will read and understand the types of User Defined Functions or shortly called UDFs, how to create UDFs and how to use them. There are 3 types o...
Responsibilities of DBA 21 Jan 2012 | 12:09 am
In IT sector the term “DBA” stands for Database Administrator. Database Administrator is a person who has a full controls on the database. The primary role of the Database Administrator is to administ...
Database Backup 20 Jan 2012 | 01:14 am
Database Backup Database Backup is one of the most important duty for database administrators (DBA) in daily basis. Not knowing this in most cases will cause you lose your job. In SQL Server there ar...
DateTime in SQL Server 15 Jan 2012 | 09:10 am
Date and Time in SQL Server is very important, in almost every application you have good reasons to use the date and time. Since it’s very useful for us, SQL Server has the data type datetime and smal...
convert() function in sql 10 Jan 2012 | 12:31 am
This function in sql server is used for mostly two reasons; to convert one datatype into another datatype or for conversion of date/time formats. So you can convert integer to varchar, varchar to date...
