Showing posts with the label tables
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 @…