.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

How do i create a looping script

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server
How do I create a script where it will loop through a set of WHERE clause.

View Complete Post

More Related Resource Links

generate create script of table using c# and SQL server 7.0, can anyone help me?


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.

I need to create a script in SSIS which creates a data source that connects to an Access database.

I need to create a script in SSIS which creates a data source that connects to an Access database. The Access database file name needs to be set as a variable as it will change from month to month. I have no idea what I am doing can anybody give me some tips? Mr Shaw

How to create/trigger a server-only script

Background:  I have a site that sends a good bit of emails, some one at a time, and some larger groups of admin emails.  I'm running on a shared hosting service.  The mailserver is horribly slow, so any script that sends a single email can take as much as 15 seconds to execute (and I can't seem to set Response.BufferOutput  to false, so the whole page has to wait the entire duration).  On the bulk emailings, it can take minutes for that to run.I want to create a "mail queue" of my own... I want any script that sends an email to, instead, write a row to a db table containing the necessary email info, which will let the script get on with its business quickly.  Then, I want to create a script that runs on the server only, and have it check the table for emails, send them, and remove them from the table.I know I can have the "mailsender" script run as a scheduled task, and it would thereby run on the server only.  But I would prefer to have the initial script somehow "trigger" the mailsender script.So, QUESTION:  Is there a way in asp.net to create a script that will execute solely on the server, and call that script from another page, so that the calling page doesn't wait for the server script to execute?Thanks!

create new email account in asp.net script

helloi want asp.net script to create new email account. i mean there should b registration form like gmail or yahoomail and my user can create their own account under my domain name.please help me.my client has extreme need this.thanks

How to auto create (or Generate a script) which can create indexes on subscriber


In our scenario, subscriber and publishers have same tables and we want the indexes also to be same at all places..

How to auto create (or Generate a script) which can create indexes on subscriber which are already added on publisher.. Is there a auto way or is there any article somewhere which can help..


IMP : There might be a delay in posting replies due to time difference (GMT +2:00) and Friday's Holiday instead of Sunday.

How do I drop and create a store procedure on the fly during a installion script?


hi all

I am doing the following to drop the sproc which works fine:

use database1



exists (select * from sysobjects where id =

How to create and emails Script in VBScript?


 I Created a contact page for my web site.  I have a name field, email address field, subject field and a message field. I have a reset button and a submit button at the bottom of the fields.  I am looking for a VBScript to make the about fields send the message to my email address from my website.  Can anyone supply me with that script or point me in the right direction to find the script?


Create Table Script



I have the following T-SQL script generated from an existing table:

	[ErrorId] [uniqueidentifier] NOT NULL,
	[Application] [nvarchar](60) NOT NULL,
	[Host] [nvarchar](50) NOT NULL,
	[Type] [nvarchar](100) NOT NULL,
	[Source] [nvarchar](60) NOT NULL,
	[Message] [nvarchar](500) NOT NULL,
	[User] [nvarchar](50) NOT NULL,
	[StatusCode] [int] NOT

create table script



I need a create table script (see bottom), where a field-description will be placed beside every field. In addition the field timestamp should contain the defaultvalue of the current time.

Thanks for your hint.




TABLE dbo.Example




Powershell script to create permission levels & groups and add users


We are trying to setup a Powershell script to create permission levels & groups and add users to groups for a SharePoint site.

We've tried to use the new
PowerShell commandlet for 2010 but it will not add a user to a group unless the user is already defined to the SharePoint site.

Does anyone know how to do this without having to add the users to the site first - or if it can be done - in SP 2010 ?

Thank you..

Can not create table via SSMS 2005 GUI even with dbowner rights (I can via ddl script)


I have SQL server 2005 client with SP3 (Microsoft SQL Server Management Studio      9.00.4035.00).

Back end database is SQL server 2008 SP2

I can create/alter a table via sql script.
In the SSMS Database Designer (GUI), When I right click on the database >> Tables and select New Table I get the following error - "Unspecified Error. MS Visual Database Tools."

I was able to use SSMS 2008 client to create tables with out any issues. Looks like a compatibility issue between SSMS 2005 and SS 2008 server.  Has anyone seen this issue and if yes is there a fix for it ?




How to create 3 tier application using LINQ

As you know that in 3 tier architecture there are three layers

User interface layer. (Is our Form in Windows application and .aspx page in Web application)
Data Access layer. (Which provides interface between Business logic layer and Database)
Business Logic layer.(Which stores your application logic)

Create ToolTip for GridView Header

The following allows you to add a tooltip to the header links of your GridView, a feature that is lacking.

Create And Run Excel Macro At Runtime in C#

You've been tasked with writing a Windows Form application using the .NET Framework that interacts with Microsoft Excel. If you are new to working with Excel in .NET and are having trouble learning how to format certain cells or cell ranges, then this little tip will come in handy. Rather than scour the internet hoping to find the correct set of constants or method syntax for formatting your spreadsheet, use the built in tools in Excel to write the familiar VBA code for you. Then, you can paste the VBA code generated by Excel into the sample C# code below and run it dynamically at runtime.

Create and Use a Typed DataSet by Using Visual C# .NET

This article shows you how to create and use a typed DataSet in a small Web application. Typed DataSets, which inherit from the DataSet class, create first-class members of a DataSet's DataTables and DataColumns, yielding the many benefits that come with the use of strong typing.

Connestion string create any database server

This links important to how to create connection string to any data base sever.

Rendering ASP.NET Script References into the Html Header

One thing that I've come to appreciate in control development in ASP.NET that use JavaScript is the ability to have more control over script and script include placement than ASP.NET provides natively. Specifically in ASP.NET you can use either the ClientScriptManager or ScriptManager to embed scripts and script references into pages via code.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend