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
How to get a last access time for tables in SQL Server ? To get the last time when table was accessed in SQL Server,… Read More »Get a last access time for tables in SQL Server
Cascading referential integrity constraints are foreign key constraints that is used to defines the action that SQL Server performs when a user try to delete or update a primary key value to which an existing foreign key points.
Print a prime numbers separted by comma for any given number .
For example, the prime number for 10 , wolud be 2,3,5,7 .
Here is the query:
Query to Get the Students who scored higher than 80 Marks ?
SQL server allows us to transform a row- level data into columnar data using SQL Pivot.
How to get all the tables in database those are having primary key constraints ?
What is the difference between SQL Server Stored Procedures and User Defined Functions (UDF)?
Following are the some major difference between Stored procedures and User Defined functions
Return a value
Stored procedure may or may not return a value while UDF function must return a value.
What is the difference Between CHAR and NCHAR data types?
What is the difference Between VARCHAR and NVARCHAR data types?
How to Display calendar dates for any n numbers of years in SQL Server?