Sql Server
Introduction
What is Sql
What is database normalization
SQL Profiler
Local temp table and global temp table
What is the Difference between ROW_NUMBER(), RANK() and DENSE_RANK()](what-is-the-difference-between-row_number()-rank()-and-dense_rank().md)
Difference between Primary Key & Unique Key
SQL Constraints
What are the differences between UNION and UNION ALL Operators
Aggregate Functions
Scalar Functions
SQL Wildcard Characters
SQL Comparison Keywords
Having vs Where Clause
Magic tables
What is the difference between TRUNCATE and DROP statements
Why Truncate is faster
Sql Joins
Store Procedure
Foreign key column value can be null
Difference Between Temp Table and Table Variable
Cursor
Scope Identity
How to create userdefine and call
How to change male to female and female to male in Sql server
How to display two related table records without join
SQL SERVER – @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT
Scope
SQL Server Exception Handling by TRY…CATCH
Third highest Salary
How to delete a table in SQL Server
How to update a database table using SQL
Trigger in SQL Server
pivot in sql server
What is PL/SQL
Difference between sql logins and sql users in sql server
Write a query to fetch values in table table_a that are and not in table_b without using the NOT keyword
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors
What are the two authentication modes in SQL Server
What will be query used to get the list of triggers in a database
What is the command used to get the version of SQL Server
how to improve stored procedure performance

Powered by GitBook

What is the command used to get the version of SQL Server

Command used to get the version of SQL Server

Select SERVERPROPERTY(‘productversion’)

results matching ""

No results matching ""