I learned about this from Pinal Dave's blog(You can see the original article in references.) In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...

I learned about this from Pinal Dave's blog(You can see the original article in references.) In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...

I learned about this from Pinal Dave's blog(You can see the original article in references.) In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...

I was looking into some table creation scripts in source control today. I found that the developers used two ways to check if the table exists in the database. Few scripts employed `information_schema.tables` vs `sys.objects`. I personally, have be...

I was looking into some table creation scripts in source control today. I found that the developers used two ways to check if the table exists in the database. Few scripts employed `information_schema.tables` vs `sys.objects`. I personally, have be...

I was looking into some table creation scripts in source control today. I found that the developers used two ways to check if the table exists in the database. Few scripts employed `information_schema.tables` vs `sys.objects`. I personally, have be...

I was looking into some table creation scripts in source control today. I found that the developers used two ways to check if the table exists in the database. Few scripts employed `information_schema.tables` vs `sys.objects`. I personally, have be...

I support third party software databases at work. During the implementation of the application it needed to create a database to store the data. However the application created a database with a name that does not follow the rules for the format of id...

I support third party software databases at work. During the implementation of the application it needed to create a database to store the data. However the application created a database with a name that does not follow the rules for the format of id...

Suppose you have a huge table which has say 30-40 columns and you want to select all of them or most of them say around 30 columns. It is a tedious job to type each of the column names. Here is a quick way to get a comma separated list of all the column...