Encrypting a SQL Server Stored Procedure If you have any complex business logic that you want to keep secure and hide from end user due… Read More »How to Encrypt a Stored Procedure in SQL Server
The sp_procoption is a SQL Server system stored procedure allows us to Set or clear a stored procedure for automatic execution when an instance of… Read More »SQL Server sp_procoption startup procedures
How to change the Collation of table column to Case insensitive or Case sensitive? Lets prepare a sample table called DumpData, and insert few records… Read More »SQL change column collation to case sensitive
How to copy or delete files from directory in SQL Server ? It can be done using xp_cmdshell which is SQL Server built in system… Read More »Copy or delete files from directory in SQL Server
The SQL ROWCOUNT is a SQL Server SET statement which causes SQL Server to stop processing the query after the specified number of rows are returned
SQL Server SET NOCOUNT ON/OFF statement that controls the behaviour in SQL Server to shown the number of affected rows in the T-SQL query.
The SQL GOTO statement is used to alter the flow of execution. When the execution reaches the GOTO statement.