Subscribe to this blog
Vivek's SQL Notes
Vivek johari is currently a Analyst and
have more that 5.5 yeras of experience in database. He has Master
degree in Computer and also he is Microsoft certified Sql DBA
(MCTS)& Microsoft certified SQl BI professional(MCTS). He is also
Oracle certified profession(OCP)DBA in ORACLE 10g and ORACLE 9i.He has
the experience of working in PL/SQL, T-SQL and SSIS/SSRS. His work
basically involved designing and optimization of the Database.He has
also published many database articles on his blog Technologies with Vivek Johari.
Archives: December 2009
Sql Server- Difference between Stored Procedure and Function
In Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to complete a task, but still there are many differences between Stored procedure and Functions.
These differences can be summarized as follows:-
1) A stored procedure can return a value or…
1 comments, 223 reads
Posted in Vivek's SQL Notes on 22 December 2009
Difference between Delete and Truncate Command
Although the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still there are many differences in their working. These differences are given below:-
1) Delete command maintained the logs files of each deleted row but Truncate command do not maintain the…
1) Delete command maintained the logs files of each deleted row but Truncate command do not maintain the…
0 comments, 323 reads
Posted in Vivek's SQL Notes on 17 December 2009
Sql Server - How to write a Stored procedure in Sql server
Stored Procedure:- Stored Procedure In Sql server can be defined as the set of logically group of sql statement which are grouped to perform a specific task. There are many benefits of using a stored procedure. The main benefit of using a stored procedure is that it increases the performance…
1 comments, 300 reads
Posted in Vivek's SQL Notes on 5 December 2009