How to Encrypt a Stored Procedure in SQL Server
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
Home » SQL SERVER »
SQL Interview Q & A
A Series of SQL Server basics to advanced level SQL Interview questions and answers that are commonly asked in interivew.
SQL Server sp_procoption startup procedures
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
SQL change column collation to case sensitive
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
Copy or delete files from directory in SQL Server
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
Get a last access time for tables 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 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 Prime numbers for any given n number in SQL Server
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:
Get the Students who scored higher than 80 Marks
Query to Get the Students who scored higher than 80 Marks ?
SQL Server Dynamic PIVOT
SQL server allows us to transform a row- level data into columnar data using SQL Pivot.
How to get all tables those are having a primary key
How to get all the tables in database those are having primary key constraints ?
SQL Server Stored Procedures Vs User Defined Functions
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.
Generate Calendar table in SQL Server
How to Display calendar dates for any n numbers of years in SQL Server?