HomePosts tagged “SQL Server”

SQL Server

Showing 1 - 20 of 42 results
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...
You might want to search all the tables in your database for a specific column name in order to rename...
You might have a scenario where you want to find out how much space that each of the tables in...
If you want to return the current date time in SQL Server , the easiest way to do it is...
If you need to check if a column exists in a table or not in SQL Server , below is...
There are times when you want to add an column with a default value to the existing table in SQL...
Assume that you have a table named “Employee” in MS SQL Server and you would like to delete the top...
Are you looking at displaying the stored procedure code quickly with-in your SQL Server Management Studio ?. Here’s how you...
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...
There are times when you might have a column names in your SQL Server database table that might looks like...
You can easily return all the column names of a table in SQL Server 2008 using the sp_columns stored procedure....
SQL Server provides an function ISNULL if the value placed in the 2nd parameter if the first parameter passed to...
There are times when you want to to list out all the stored procedure names that contains certain keyword or...
Here’s a quick tips on viewing the code of a stored procedure in SQL Management Studio. One of the quickest...
When working with SQL Management studio , you might need to display a string N number of times , in...
Assume that you have a date “01/09/2016” and you would like to find out what day of the week it...
There are times when you want to kill all the current active connections of your SQL Server database and you...
Assume a scenario where you are trying to get the records from the table where some of the records contains...

Categories

Archives