Showing posts with the label Sql
What is Cursor in SQL Server with Example

What is Cursor in SQL Server with Example

By Krunal Shah
o use cursor in  sql server  that syntax will be like as shown below Syntax to Create Cursor DECLARE …
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…