SQL Server Tutorials By Pradeep Raturi- This website provides a SQL server, SSRS, Power BI, Python, Azure basics and advanced tutorials for beginners and professionals .You will find out a step-by-step
You can generate a database scripts including the schema and the data by using the Generate Scripts option available in SQL Server Management Studio (SSMS),… Read More »Generate Database Scripts With Data in SQL Server
Selecting a top n records for each category from any table, can be done easily using row_number function which generates a sequential integer to each… Read More »How to get TOP N records for each category
How to find and separate the numbers, letters and special characters from string? Suppose you a column in table which contains a mix words which… Read More »Separate numbers, letters and special characters from string
SQL Server allows several options to protect sensitive data, and one of them is specifying a column level encryption. Using this option you can encrypt… Read More »Column Level Encryption Decryption using Symmetric Keys
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
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
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.
Detaching and attaching a SQL database, is helpful in case in case when you want to move to move a database to a different SQL Server instance. So Bascially, first we detach database from SQL Server and move those files to another SQL Server and then attach files.