i have a table with 2 columns !
1- id int identity(1,1) not null .
2 - name nvarchar(50)
and data is :
id = 1 , name = "brad pitt"
id = 3, name = "diego maradona"
how i can insert a row with id = 2 ?
View Complete Post
Hi I have created an intranet application using ASP.Net/IIS.
I normally need to web share the folder and allow full permission to ASP.Net user account.
However, I carelessly deleted this account. How to create it again ?
Pls help.... thanks.
SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.
Alok Mehta and Ricardo Rodriguez
MSDN Magazine May 2003
Developers have myriad options when it comes to creating solutions for mobile devices. One of the greatest challenges facing mobile developers is finding a compact yet robust local storage solution. SQL Server CE 2.0 promises to deliver on both fronts. This new release represents a tremendous leap in terms of features and performance over its predecessor. This article will review some of the platform and tools choices developers have today. The authors will compare and contrast the significant new features in SQL Server CE 2.0 with the previous release. Following that, they will build a sample app for illustration.
Mark Brown and David Meunier
MSDN Magazine January 2003
I want to generate create table script using c#.net, I want to connect sql server 7.0 and generate table create script. Its urgent kindly help me urgently.