Your Technical Consultant
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
In this article, we want to share how to convert number to Bangladeshi taka in excel easily and earlier than writing phrases manually. like as, you write the number ‘123’. However, now you do not want to type to MS […]
Continue reading Excel Tutorial: Convert Number to Words in Bangladesh Taka (BDT)
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
You may have heard of the OWASP before. It is the Open Web Application Security Project. In 2019, the OWASP group determined that with the adoption of APIs, there was a need for an API-specific Top 10 – and that’s […]
Continue reading Learn the OWASP API Security Top 10: Essential Guide to API Security Fundamentals
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
Hello Everyone! In this article, I want to share the method to enable focus next textbox in Gridview on the “Enter” key pressed using javascript. Enhance User Experience – Move to the Next Input Field in GridView on Enter Key. […]
Continue reading How to Focus Next Textbox in GridView on Enter Key Press – A Step-by-Step Guide
