Data Bank | Yazilim Ders

Getting List of All Stored Procedures in Database in MS SQL

The following code should be run to get the list of all Stored Procedures in a database in MS SQL Server with a query...

187 Ms Sql

List of Table Columns Used in Any View in MS SQL

The following query is run to get the List of Table Columns used in any View in MS SQL...

186 Ms Sql

Finding List of Tables Using View in MS SQL

Run the following query to find the list of all tables using View in MS SQL...

184 Ms Sql

Generating Random Letters in MS SQL

The following code is run to generate random letters in Ms Sql...

195 Ms Sql

Using Trim Function in MS SQL

TRIM() function came with MS SQL Server 2017. Previously, we used to handle spaces in the variable with methods such as LTRIM, RTRIM or REPLACE...

187 Ms Sql

Getting Character Count in MS SQL

In Ms Sql, LEN() function is used to get the number of characters of a string type data (char, varchar..)...

195 Ms Sql

Finding Session Id in MS SQL User's Current Process

In MS SQL, the following query is run to find the Session Id of the logged in user in the current process...

206 Ms Sql

MS SQL Getting a Random Row in a Table

If we want to fetch a random row in a table in MS SQL Server, the following path is followed...

181 Ms Sql

Changing MS SQL Database Name with Query

To replace a database name with a query in MS SQL Server, one of the 2 ways below should be followed...

183 Ms Sql

Changing MS SQL Table Name with Query

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

178 Ms Sql

Changing Column Name of MS SQL Table with Query

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

181 Ms Sql

Getting List of System Hard Disks with Free Space in MS SQL Server

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

189 Ms Sql

Getting the Id of MS SQL Server Last Entered Record

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

186 Ms Sql

Disabling a Specified Trigger in MS SQL Server

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

194 Ms Sql

Disable All Triggers in MS SQL Server Table

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

188 Ms Sql

Making a Backup of MS SQL Database With Query

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

192 Ms Sql

Making a MS SQL Database Offline

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

194 Ms Sql

MS SQL List of Records in All Tables

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

179 Ms Sql

Getting List of All Views in MS SQL Database

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

201 Ms Sql

MS SQL Finding Which Tables a Column Name is In

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...