To replace a table name with a query in MS SQL Server, the following procedure should be followed...

In MS SQL Server, the following procedure is followed to change the column name of a table with a query...

Below is the query where we will get the list of system hard disks with available free space using MS SQL Server...

In MS SQL Server, the following procedure is followed to get the Id of the last record entered into the system...

To disable a TRIGGER specified in MS SQL Server, the following procedure is followed...

In MS SQL Server, run the code below to disable all TRIGGERs in a table...

If we want to back up a database with the query method in MS SQL Server, the following path is followed...

The following code is run to take a database to offline mode in MS SQL Server...

In MS SQL, run the following code to get the list of record numbers of all tables (created by the user) in a database...

In MS SQL, the following code should be run to get the list of all views in a database with a query...

The following code should be run to obtain the list in which tables a column name is wanted to be searched in MS SQL Server...

The following code should be run to get the list of all column names and data types of a specified table in MS SQL Server...

To get a list of all tables created by user(s) in a database in MS SQL Server, the following query should be run...

The following code should be run to find out what version is installed in MS SQL Server by query...

When writing queries in MS SQL Server, clear line numbers make it easier for developers. Showing row numbers in MS SQL Server is explained step by step below...

The following query model is run to recompile the stored procedure in MS SQL with the query...

Using IF ELSE is an option if you want to run or skip a condition in the query to be written. Using if else in Ms Sql is not much different from other programming languages...

The following code is run to bring a database online in MS SQL Server...

In MS SQL Server, we get the current time with the getdate() method. But this method gives us results with hours, minutes, seconds and milliseconds...

If it is desired to restore (return from backup) of a database that has been backed up in MS SQL Server, the following code is run...