Showing posts with the label sql query
Generate class from database table

Generate class from database table

By Krunal Shah
I just need to create the entities (simple class). Something like: public class Person { public string N…
Start Index No With 1 Sql Query Reseed Auto increment

Start Index No With 1 Sql Query Reseed Auto increment

By Krunal Shah
DBCC CHECKIDENT ('TabelName', RESEED, 0);
Generate Random Number in SQL Numeric and Password / String

Generate Random Number in SQL Numeric and Password / String

By Krunal Shah
Random Number SELECT ABS(CHECKSUM(NewId())) % 10000 AS [NewID] SELECT ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT…
Step by Step Tutorial to backup database in SQL Server Management Studio 2005, 2008, 2008R2 and 2012

Step by Step Tutorial to backup database in SQL Server Management Studio 2005, 2008, 2008R2 and 2012

By Krunal Shah
In this article I will provide a step by step tut…
Simple Insert Update and Delete Triggers in SQL Server with example

Simple Insert Update and Delete Triggers in SQL Server with example

By Krunal Shah
In this article I will explain with simple example…
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…