There are couple of ways in which you can retreive the version of the SQL Server using T-SQL.
1. using @@VERSION
SELECT @@VERSION
2. Using SERVERPROPERTY function as shown
SELECT SERVERPROPERTY('productversion') Assume a scenario where you have a column in your table in SQL Server database where you want to retreive the first character of the column value.
When working with the SQL Server Management Studio and trying to edit the table records , you would have noticed the context menu option “Edit Top 200 Rows”.
If you need to check if a login exists in SQL Server , you can use query the master.dbo.syslogins for it.
Here’s a sample query demonstrating how you can …
MySQL has the function Now() which is a Datetime type field which shows the current date as well as the time.
In SQL Server , you can use …
If you want to get the first day of the month of a input datetime variable from a SQL Query , here’s how you do it.
SELECT DATEADD(month, DATEDIFF(month, 0, GetDate()), 0) AS StartMonthDate
You can retreive the date in the YYYY-MM-DD format in SQL Server using the CONVERT method as shown in this code snippet.
SELECT CONVERT(char(10), GetDate(),126) as abundantcodedate
There are times when you get an error stating
“Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created …
You can find out if the index exists for a table by querying the sys.indexes table as shown in this blog post’s code sample.
Use AdventureWorks2014 GO SELECT *
You can use the TOP keyword and specify the number to retreive the TOP N records that the query returns. Additionally , order the records by newid() function using the ORDER BY clause to make the records random.