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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

How to Perform SQL Server Row-by-Row Operations Without Cursors

Posted By: Amit Mehra     Posted Date: May 15, 2010    Points: 2   Category :Sql Server
 
SQL cursors have been a curse to database programming for many years because of their poor performance. On the other hand, they are extremely useful because of their flexibility in allowing very detailed data manipulations at the row level. Using cursors against SQL Server tables can often be avoided by employing other methods, such as using derived tables, set-based queries, and temp tables


View Complete Post


More Related Resource Links

Can't perform Create, Update or Delete operations on 'Table(outbox)' because it has no primary ke

  

 Hi,

I'm a beginner in asp.net and I have some problem inserting data into sql server 2005 with linq.

 

my code is : 

 

        Dim Result As New SMS.SendResult
        If Result.status = 0 Then
            Label1.Text = "Your Message Sent Successfuly"
           
            Dim db As New IGSSDataContext
            Dim out As New outbox With {.ClientID = intRandomNumber, .From = User.Identity.Name, .TO = TextBox1.TabIndex, _
            .Time = Now, .Message = Message}
            out.ID = (ID)
            db.outboxes.InsertOnSubmit(out)
            db.SubmitChanges()
           
            TextBox1.Text = ""
   &nb

Replication: How could we use SQL Server to perform this replication model ?

  
Hi everybody, I'm trying to build up a database system using both peer-to-peer and normal transactional replication. However, it seems to be not able to combine both types of replications on one database. This is the replication model which I'm trying to build. http://a.imageshack.us/img28/4095/8copym.jpg I have already had two DB servers and one common database which could be synchronized between these two DB servers using peer-to-peer replication (2-way synchronizing). And then I attempt to use normal transactional to perform 1-way synchronizing but not successful. Always get this error: Invalid column name '$sys_p2p_cd_id'. Anyone has ideas to resolve the problem or suggestions to build this replication model. Please help.   Thank you.  

LINQ - Can't perform Create, Update or Delete operations on because it has no primary key.

  
Hi, not sure if I'm posting this thread in the right section. anyway, I''m trying to do the update/insert/delete using LINQ but the underlying table does not a primary key. The table consists of composite ket (e.g. fieldA & FieldB make a primary key). At the moment, I have LINQ complaning about not having a single primary key (not sure what LINQ does it - not making any sense at all). did anyone ever come across this issue and rectified it?  thanks

User does not have permission to perform this action( Microsoft SQL Server, Error:15247)

  

Hi,

I was able to do my work with ease on my Database server, until sometime Friday evening. Don't exactly know what transpired, only that I can now no longer run queries or even create new databases. Here is a sample of what happens when I try to create a database

Create Database PetitionSample

Msg 262, Level 14, State 1, Line 1

CREATE DATABASE permission denied in database 'master'.

I used to be able to create databases, create new users and so on. My Server is installed on a Vista machine and I am running Developer version and using Management studio 2008 to access it. Anyone have any idea what could be going on?


None

Perform database operations in data entity model

  

hi ..

i want to know how to perform database operations link inser,update,delete in data entity model using ado.net data entity model(.edmx)


i was follow the instructions from asp.net site this link
http://www.asp.net/aspnet-in-net-35-sp1/videos/getting-started-with-dynamic-data and i succesfully created .edmx file and i run the

project it load all my table and if i selects a particular table it shows the details of my table..

but i want to perform insert,delete and update operations..i want to put a page and perform this sample operations using edmx..i dont know how to do this operations.

how to do this...
need ur suggestions..


explain me with suitable examples using c# for(.edmx)..

regards
gopal.s


about architecture of SQL Server Cursors and inside SQL server cursors process mechanism

  

Hi all,

I need some information about architecture of SQL Server Cursors and inside mechanism of SQL Server Cursors,

My Information

·         IM using SQL SERVER 2005 and 2008

·         CURSOR TYPE - READ_ONLY

Ex: DECLARE

How can I prevent server admins to perform SQL admin tasks on a SQL server 2005?

  

There are too many server admins in my environment. How can I prevent server admins to perform SQL admin tasks on a SQL server 2005?


Sara

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

CLR Integration With Microsoft SQL Server

  
Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).

IP Address Blocking or Restriction in SQL Server

  
"is it possible to block connections to SQL Server based on IP address". As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.


.Firewall
.IPSec
.RRAS IP Filter

Determine whether Forms Server is installed on a server

  
Check whether the Microsoft.Office.InfoPath.Server.dll and FormServer.aspx files are installed on the server.

Connestion string create any database server

  
This links important to how to create connection string to any data base sever.
Categories: 
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