HomeSQL ServerPage 704

SQL Server

Showing 14061 - 14077 of 14077 results
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 differences between HAVING Clause and WHERE Clause HAVING Clause HAVING Clause is used for aggregating or grouping...
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...
Last few weeks , I have been playing around with this cool tool called Open DBDiff . As the name...
SQL Server Management Studio has a feature that lets you to automatically generate Create or Alter scripts when using the...
Few days back , I had to find the SQL Server Version in one of the Machine and here’s a...
Here’s a way to reset the value of the identity column in SQL Server . The scenario is explained below...
Recently i had to restore a SQL Server 2008 R2 Database to a Database in another machine and i ended...
Have you noticed the Context Menu , when you right click on the table in the SQL Server Management Studio...

Categories

Archives