How to delete a stored procedure in TSQL?

How to delete a stored procedure in TSQL?

If you need to delete or drop a stored procedure in TSQL. You can use a built-in function called DROP. It is recommended that you perform a check to see if the stored procedure you want to delete does exist in the sysobjects table.
How to use ROW_NUMBER in TSQL?

How to use ROW_NUMBER in TSQL?

If you want to have a sequential number against a row in SQL Server record. You can use the number function called ROW_NUMBER.
How to get inserted Guid in TSQL?

How to get inserted Guid in TSQL?

If you need to get the returned GUID uniqueidentifier after inserting a record. You cannot use the method  SCOPE_IDENTITY() to retrieve the value. What you can do is by creating a temporary table in TSQL as a variable table and then perform output to insert the column Guid into the table variable.
How to delete all Functions in TSQL?

How to delete all Functions in TSQL?

To delete If you need to delete all non-system functions in TSQL. We need to look against the sysobjects and looking for the type value under 'FN', 'IF', 'TF', 'FS', and 'FT'.
How to create a table with uniqueidentifier in TSQL?

How to create a table with uniqueidentifier in TSQL?

A Guid is a 16-byte binary data type TSQL. This data type can be used as another alternative unique identifier for a record. Usually, we use numbers for the primary key. But on some occasions, if we want to make it harder for users to guess the primary key we can use this Guid type alternative. For example: If we have a user table with a primary key integer. If we want to do a query against it we can easily pass any integer number. But with Guid type, it will be a bit hard to guess. So this can be a good choice if you want to build a better application.
How to delete a column of a table in TSQL?

How to delete a column of a table in TSQL?

Learn how you can delete a column of a table in TSQL. Before deleting a column, it is always recommended to check if a column does exists in a table. This is to ensure the process of deleting is working fine.