SQL Server

Showing 21 - 40 of 42 results
If you want to pause the execution of the code block until a specific time is reached , you can...
If you want to pause the execution of the code block for a specific amount of time , you can...
To check if the table exists in a database in SQL Server , you can use the INFORMATION_SCHEMA view. How...
You might want to sort the results of an query in a different order from the traditional sort (Ascending/Descending) order....
There are times when you don’t have a specific value to find but you might have to use the general...
When we work on SQL Server query , we use the AS keyword to specify the alias name for a...
When we want to specify a alias for a column in SQL Query , we tend to use the double...
Problem Statement You need to install SQL Server 2014 Express edition on Windows 10 machine. Solution There are several ways...
Below is a sample SQL query that demonstrates how to count the number of tables in a SQL Server database...
By default , the SQL Server listens to the port number 1433 and assume that if your server name is...
If you need to retrieve the list of the tables created by the users in SQL Server, you can do...
Microsoft SQL Server comes in different versions that includes SQL Server Enterprise SQL Server Business Intelligence SQL Server Standard SQL...
Here’s another tip where you could export the query result to .csv file in SQL Server. How to Export the...
Today, when I was trying to insert a value to a table in SQL Server which had single quotes, I...
Sometimes, you might want to query the  SQL Server version to know its exact version number and other information like...
You can create a Database Backup in SQL Server easily by using the SQL Scripts. Just specify the BACKUP DATABASE...
It might be important to take the back of the SQL Server database regularly and store them in a secure...
Below are few points that differentiate the DELETE and TRUNCATE command. Sl. No. DELETE TRUNCATE 1 This removes the rows...
By default, primary key creates clustered index on the column and then enforces the uniqueness of the column whereas the...
Which port number does SQL Server run on? By default, Microsoft SQL Server runs on port 1433. If you want...

Categories

Archives