Anup Shah on WPF and Silverlight (Programming Garden): Create ASPNETDB database using aspnet_regsql tool

Anup Shah on WPF and Silverlight (Programming Garden): Create ASPNETDB database using aspnet_regsql tool: What is ASPNETDB? Microsoft has introduced a powerful default database schema in ASP.Net 2.0 as ASPNETDB.mdf database. This database fil...

Read More »

SQL SERVER QUERY Part-1 Script to find database role given to logins in all the databases.

/* Description     : Script to find database role given to logins in all the databases. Parameters    : NONE. Returns    : NA Create date : 4/May/2016 */      create table ##t2(      DBname varchar(300),      DBrole_name varchar(300),      Type_dbrole varchar(300),      Grantee varchar(300))             insert into ##t2 exec      ...

Read More »

C# Collection & Generics Tutorials Array, ArrayList, Deep Copy vs Shallow Copy etc.,

C# Collection & Generics Tutorials Collections are data structures that holds data in different ways for flexible operations . C# Collection classes are defined as part of the System.Collections or System.Collections.Generic namespace. How to use C# ArrayList Class ArrayList is one of the most flexible data structure from CSharp Collections. ArrayList contains a simple list of values. ArrayList implements the IList interface using an array and very easily we can add , insert...

Read More »

T-SQL: SQL SERVER CURSOR A Simple Example Using a Cursor

T-SQL: SQL SERVER CURSOR A Simple Example Using a Cursor First Create Table CREATE TABLE [dbo].[Tbl_Broadcast_Mktg](       [Broadcast_Id] [int] IDENTITY(1,1) NOT NULL,       [Broadcast_Campaign] [nvarchar](100) NULL,       [Broadcast_Coupon] [int] NULL,       [Broadcast_Custdb] [int] NULL,       [Broadcast_Custdb_Flag] [nvarchar](50)...

Read More »