Your Technical Consultant
Storing and retrieving data as requested by other software applications, either on the same computer or a remote machine, utilizing the client-server model.
If you specify the OUTPUT keyword for a parameter in the procedure definition, the procedure can return the current value of the parameter to the calling program when the procedure exits. To save the value of the parameter in a variable that can be used in the calling program, the calling program must use the OUTPUT keyword when executing the procedure. For more information about what data types can be used as output parameters.
The example here runs the size query twice for two different databases on the same server. You can then have a simple report off the back of this showing the growth trends over time and on a weekly basis for the largest and the fastest growing tables.
There are two types of primary key, a simple primary key, and a composite primary key. A simple primary key is made of just one column while a composite primary key is made of more than one columns. Primary key also enforces some constraint e.g. UNIQUE and NOT NULL, which means if you try to enter another record with the primary key already existing in the database than DBMS will reject it.
Continue reading Difference between Primary Key Vs Foreign key in SQL
I had the same task recently and I used the following for SQL Server 2012 db. Use management studio and connect to the database you want to search. Then execute the following script for list of all triggers in SQL Server database with table name and table’s schema.
Continue reading List of all triggers in SQL Server Database
Many a time we come across a scenario where we want to fetch data from all over database tables based on delimited some string. It is very difficult and time to consume to write different queries based on every table/column to […]
Continue reading SQL: How To Quickly Search For Data All Over Database
SQL, which stands for Structured Query Language, is a powerful language used for managing and manipulating relational databases. In this comprehensive guide, we will delve into SQL commands, their types, syntax, and practical examples to empower you with the knowledge to […]
Continue reading SQL Commands (DDL, DML, DCL, TCL, DQL): Types, Syntax, and Examples
sp_MSforeachdb is extremely useful for pulling together metadata about your various SQL databases. I use it quite frequently for reporting on such important metrics as database file sizes, amount of free space, and backup status.
SQL Server is a powerful relational database management system that is widely used to store and retrieve data. Writing efficient and effective queries is crucial for optimizing the performance of your SQL Server database. In this article, we will explore […]
Continue reading SQL Server Query Tips and Tricks: Boosting Performance and Efficiency
In the following lesson, you can learn how to get All the Information in the Database using sys.databases. In SQL Database, this view is available in the master database and user databases. In the master database, this view returns the […]
Continue reading Find Database Related Information from sys.databases using SQL Command
In this article, you will learn how to concatenate many rows into a single text string using SQL queries. Before learning conversion and casting, you should have knowledge about Python Data Types. Many a time, SQL programmers are faced with […]
Continue reading Concatenate Many Rows Into A Single Text String
