Month: September 2016

Checking the version of a SQL Server using T-SQL

How to get the first character of a string in SQL Server ?

How to change the ‘Edit Top 200 Rows’ in SQL Management Studio ?

How to Check if a login exists in SQL Server ?

What is the equivalent of MySQL’s Now() function in SQL Server ?

How to read a connection string from web.config file in ASP.NET ?

How to Generate C# class from a XML file ?

How to get the Names of all the columns from a SqlDataReader object in C# ?

Comparing only Date in the DateTime datatype in C#

How to remove the non ascii characters from a string in C# ?

How to get the total number of items in a Enum in C# ?

Could not load file or assembly … An attempt was made to load a program with an incorrect format (System.BadImageFormatException)

DateTime and Null value in C#

How to generate C# classes from xsd file ?

How to get the first day of the month in SQL Server ?

Get the date in YYYY-MM-DD format in SQL Server.

SQL Server – Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

How do you check if an index exists in a table?

How to select N random rows using a T-SQL Query ?

How to display Row Numbers in the results in SQL Query ?