Showing 21 - 40 of 42 results
Problem Statement You need to install SQL Server 2014 Express edition on Windows 10 machine. Solution There are several ways...
Today , I encountered a wiered thing in my SQL Server Management Studio 2008 R2 where the intellisense was somehow...
It might be important to take the back of the SQL Server database regularly and store them in a secure...
Which port number does SQL Server run on? By default, Microsoft SQL Server runs on port 1433. If you want...
There are times when you want to kill all the current active connections of your SQL Server database and you...
If you want to pause the execution of the code block for a specific amount of time , you can...
You can easily return all the column names of a table in SQL Server 2008 using the sp_columns stored procedure....
You might want to search all the tables in your database for a specific column name in order to rename...
If you need to check if a column exists in a table or not in SQL Server , below is...
By default, primary key creates clustered index on the column and then enforces the uniqueness of the column whereas the...
When working with SQL Management studio , you might need to display a string N number of times , in...
This was one of the quick task that I was required to work where i need to get the domain...
If you are looking at a way to find the identity of the inserted row in SQL Server , you...
There are times when you want to to list out all the stored procedure names that contains certain keyword or...
If you need to retrieve the list of the tables created by the users in SQL Server, you can do...
Assume that you have a date โ€œ01/09/2016โ€ and you would like to find out what day of the week it...
Sometimes, you might want to query the ย SQL Server version to know its exact version number and other information like...
There are times when you want to change the text from the table to a proper case in SQL Server...
Hereโ€™s a common question on what is the maximum number of databases that I can run on a single SQL...
Are you looking at displaying the stored procedure code quickly with-in your SQL Server Management Studio ?. Hereโ€™s how you...