Tag: database

Checking the version of a SQL Server using T-SQL

Published on September 15, 2016 by Senthil Kumar

Filed under SQL Server

Last modified September 15, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 3.3 (14 votes)

This article have been viewed 15165 times

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

Published on September 15, 2016 by Senthil Kumar

Filed under SQL Server

Last modified September 15, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 3.2 (18 votes)

This article have been viewed 14946 times

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

Published on September 14, 2016 by Senthil Kumar

Filed under SQL Server

Last modified September 14, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 3.1 (8 votes)

This article have been viewed 15699 times

How to Check if a login exists in SQL Server ?

Published on September 13, 2016 by Senthil Kumar

Filed under SQL Server

Last modified September 13, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 2.7 (9 votes)

This article have been viewed 16027 times

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

Published on September 13, 2016 by Senthil Kumar

Filed under SQL Server

Last modified September 13, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 4 (3 votes)

This article have been viewed 15134 times

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

Published on September 6, 2016 by Senthil Kumar

Filed under SQL Server

Last modified September 6, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 2.8 (6 votes)

This article have been viewed 14504 times

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

Published on September 6, 2016 by Senthil Kumar

Filed under SQL Server

Last modified September 6, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 4 (7 votes)

This article have been viewed 14624 times

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

Published on September 6, 2016 by Senthil Kumar

Filed under SQL Server

Last modified September 6, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 3.1 (8 votes)

This article have been viewed 14834 times

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

Published on September 6, 2016 by Senthil Kumar

Filed under SQL Server

Last modified September 6, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 3 (5 votes)

This article have been viewed 14764 times

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

Published on September 3, 2016 by Senthil Kumar

Filed under SQL Server

Last modified September 3, 2016


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 3.4 (5 votes)

This article have been viewed 14880 times