English
Türkçe
[email protected]
  • HOME PAGE
  • LESSON
  • QUESTION
  • DATA-BANK
  • BLOG
  • APPS

YouTube Kanalımız

ÇOK YAKINDA SİZLERLE

Creating a View in MS SQL

In Ms Sql, VIEW s or Views are virtual tables. They can be used just like a table, but they do not have the definition or structure of a table..

184 Ms Sql

Using CASE WHEN in MS SQL

In Ms Sql the CASE WHEN structure is often used to set the value of a column based on values in other columns or variables..

192 Ms Sql

Disadvantages of Using Stored Procedures in MS SQL

Although using Stored Procedure in Ms sql is beneficial in many ways, it also has disadvantages in some issues...

184 Ms Sql

Benefits of Using Stored Procedures in MS SQL

Using Stored Procedure in ms sql provides many benefits. Below are the main benefits. It can reduce interference in application code..

189 Ms Sql

Differences Between Stored Procedure and Function in MS SQL

Many people using ms sql have wondered about the differences between stored procedure and function...

187 Ms Sql

Creating a Stored Procedure in MS SQL

In Ms Sql, Stored Procedure or Stored Procedures is a group of queries maintained in a database. They can take parameters..

179 Ms Sql

Disabling All Constants in a Table in MS SQL

The following query model is used to disable constants in a table in MS SQL...

183 Ms Sql

Deleting Table With Query in MS SQL

The following method is used to delete (drop) a table by writing a query in MS SQL..

178 Ms Sql

Getting Rows in a Table in Random Order in MS SQL

In MS SQL Server, the following procedure is followed to randomly fetch all records in a table...

186 Ms Sql

General Information List of All Allowed Databases in MS SQL Server

In MS SQL Server, the following query is run to get the list of general information of all databases allowed by the user role...

179 Ms Sql

Deleting Columns From a Table with a Query in MS SQL

If we want to delete a column from a table with a query in MS SQL Server, we follow the path below..

186 Ms Sql

Adding Columns to a Table with a Query in MS SQL

In MS SQL Server, the following procedure should be followed to add a column to a table with a query...

179 Ms Sql

Showing Server Active Server Name in MS SQL

The following query should be run to show the active Server name in MS SQL Server...

182 Ms Sql

Finding Server Default Language in MS SQL

The following code is run to find the default language of MS SQL Server...

195 Ms Sql

Getting List of All Server Databases in MS SQL

The following query should be run to get the list of all databases in the active instance in MS SQL Server...

176 Ms Sql

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

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

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

178 Ms Sql

Generating Random Letters in MS SQL

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

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

180 Ms Sql

Total Result : 51
  • 1
  • 2
  • 3

DATA-BANK CATEGORY

  • .NET ( 40 )
  • C# ( 53 )
  • DevExpress ( 20 )
  • Flutter ( 1 )
  • Go ( 1 )
  • Hardware General ( 142 )
  • HTML ( 8 )
  • Internet General ( 40 )
  • Java ( 150 )
  • JavaScript ( 37 )
  • Kotlin ( 1 )
  • Ms Sql ( 127 )
  • Network General ( 7 )
  • Oracle ( 1 )
  • Python ( 1 )
  • Ruby ( 1 )
  • Security General ( 6 )
  • Software General ( 5 )
  • Swift ( 2 )
  • Technology ( 295 )
  • Unity ( 28 )
  • Visual Basic ( 17 )
  • Visual Studio ( 7 )
© 2012-2023 - All Rights Reserved. Yazilim Ders