Showing posts with the label stored procedures
Simple Cursor Tutorial with Syntax example in SQL Server

Simple Cursor Tutorial with Syntax example in SQL Server

By Krunal Shah
In this article I will provide a tutorial with simpl…
What is Stored Procedure in SQL Server, how to create and use a Stored Procedure and its Advantages

What is Stored Procedure in SQL Server, how to create and use a Stored Procedure and its Advantages

By Krunal Shah
In this article I will explain what is Stored Pro…
Sql querys

Sql querys

By Krunal Shah
SQL SELECT Statement: SELECT column1, column2....columnN F­­­­­ROM table_name; SQL DISTINCT Clause: …
Generate Random Number In Sql Server.

Generate Random Number In Sql Server.

By Krunal Shah
Create View First then Create Function. GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[Rand…
Delete and Drop all the tables, stored procedures, triggers, constriants and all the dependencies in one sql statement.

Delete and Drop all the tables, stored procedures, triggers, constriants and all the dependencies in one sql statement.

By Krunal Shah
/* Drop all non-system stored procs */ DECLARE @ name VARCHAR ( 128 ) DECLARE @ SQL VARCHAR ( 254 ) SELECT @…