.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 use procedure combine tran in SQL server 2005

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :
 

Hi , I have database :

create table Product
(
 IDproduct char(10) primary key not null,
 Nameproduct nvarchar(10) not null,
 Prices money not null,
 inventory int not null,
)
create table Employee
(
 IDemployee char(10) primary key not null,
 Nameemployee nvarchar(10) not null,
)
create table Customer
(
 IDcustomer char(10) primary key not 
                                     
                                            
                                        

View Complete Post


More Related Resource Links

SQL Server 2005 - Specifying Optional Parameter in Stored Procedure

  
I need to alter the following stored procedure so that the UserID is an optional parameter. I have, as yet, been unsuccessful. Basically, if the user doesn't supply a User ID, I want to return all of the users that match the other criteria.

This seems like it should be a simple thing.......

ALTER PROCEDURE [QMS].[GetQueries]

@CompanyID tinyint

,@DepartmentID tinyint

,@ApplicationID int

,@UserID AS



SELECT [QueryID]

,[UserID]

,[QueryName]

,[Comments]

,[CreateDate]

,[UpdateDate]

,[ExpirationDate]

,[LastAccessedDate]

FROM [ReportQueries]

WHERE

[UserID] = @UserID

Decrypt the encrypted store procedure through the T-SQL programming in SQL Server 2005

  

HI ,

 

I have a encrypted store procedure in my production server .Right now I do not have the script now I want do some modification.

Please any one can help me to decrypt the store procedure it will be a great help for me.

 

For any suggestion thanks  in advance.


" Education is the beginning of transformation. Dedicate yourself to daily learning via Blogs/Forums/books and coaching "
Click here to read my blog

how to create stored procedure in sql server 2005 and how to use that stored procedure in asp.net

  

Hi friends ,

       I am very newbie

I have created stored procedure and student database and also asp.net application for asp.net page

but it could not found stored procedure what is the mistake actually I don't no

Please help me



Warm Regards

Durga


CRUD Stored Procedure Code/Scripts Generator for SQL SERVER 2005

  

I need a simple anf functionally CRUD Stored Procedure Code/Scripts Generator.

Anyone have a solution?

Thanks in Advance.


SQL Server 2005 store procedure performance issue

  

We are calling store procedure from vb.net client following are the observation.

1) sqlserver 2005  takes huge amount of time (more than 1 hour) to execute procedure. The procedure has select statement using join statement. (Generally this procedure executes and populate data in 5 seconds when it is called from .net client.)

2) If same procedure is executed from sql server management studio, procedure executes and populate data in 5 seconds (works as per expectation)

3) If we recompile procedure (i.e. open procedure in alter mode in management studio and click on execute button) ,  the procedure executes and populate data as per expectation.

4) This is intermittent issue on production machine. Most of the time procedure is executed and populate data as per expectation when called from vb.net client. But it does not give expected outout in some scenario. The frequency for occurring the issue is  once in 15 days and there is no pattern in which the issue is occurring.

 

Can any one help to resolve the issue.

 

Thanks in advance!!!

 

 

 


SQL Server 2005 Grant User Permission to Create Stored Procedure and Grant Execute Access to another

  

I'm trying to determine the minimal amount of access I can give my developers to be able to run create stored procedure scripts with an inclusion of the grant execute to the application user group.

We have been developing some interesting work arounds, but I think there must be an easier way to grant the access.

Grant Create Stored Procedure to user1 on a specific database

Grant Permission to Grant Execute permission for Stored Procedures on a specific Database to user1 for any user.

 


SQL Server 2005 Transactional Replication Fails to Publish Stored Procedure Containing an Index Crea

  

I've experienced a bizarre problem with a SQL Server 2005 Transactional Publication. The issue is this: If the publication contains an article that is a stored procedure that contains a create index statement, then there is an error thrown when attempting to replicate the schema of the stored procedure to a subscriber.

The behavior is very odd, because even if the create index statement is commented out, it still gives the exception, and it will only work if it is removed altogether.

Here is the exact error that's being returned:

Command attempted: GRANT EXECUTE ON [dbo].[usp_Test] TO [CompanyDatabase_access]

(Transaction sequence number: 0x00000170000008B9000500000000, Command ID: 5)

Error messages: Cannot find the object 'usp_Test', because it does not exist or you do not have permission. (Source: MSSQLServer, Error number: 15151) Get help: http://help/15151 Cannot find the object 'usp_Test', because it does not exist or you do not have permission. (Source: MSSQLServer, Error number: 15151) Get help: http://help/15151

The error is accurate, because when I check on the subscriber, the stored procedure wasn't created as expected... but that was the purpose of the publication...

Calling stored procedure from funciton in sql server 2005

  

Is there any way to call stored procedure from funciton in sql server 2005?

If it is possible, please give some examples.

Thanks.

 


RAHUL Dot Net Developer

How use procedure add in sql server 2005 ?

  

Hi . How use procedure add in sql server 2005 ?

create table Product
(
  IDproduct char(10) primary key not null,
  inventory int,
)
create table DetailBill
(
     IDproduct char(10) not null,
  foreign key(IDproduct) references Product(IDproduct)

  balance int,
)
create proc AdddetailBill (@idproduct char(10),@balance int)
as
  declare @number int
    set @number=(select inventory from product where idproduct=@idproduct)
    if @balance > @number
      begin
        print 'lack number of product'
        return 0
      end
    
    else
    begin
      update product
      set inventory=inventory - @balance
      where @idproduct=(select idproduct from product)
    
      insert detailbill(IDproduct,balance)values(@idproduct,@balance)
      print 'Add success'
      return 1
    end
Example :
In table Product :
ID product    Inventory
P001        15
P002        5

AdddetailBill  'P002',10,    => Print 'lack number of product''

AdddetailBill  'P002',2,      => Print  'Add success' 
=> Auto Update table product :
ID product    inventory
P001        15
P002    &n

SQL Server 2005 Try and Catch Exception Handling

  
I'm pretty excited to see that there is some real error handling for T-SQL code in SQL Server 2005. It's pretty painful to have your wonderfully architected .NET solution tainted by less-than-VBScript error handling for stored procedures in the database. The big difference being the addition of TRY..CATCH blocks. Let's take a look:

Send Email from SQL Server Express Using a CLR Stored Procedure

  
Problem
One of the nice things about SQL Server is the ability to send email using T-SQL. The downside is that this functionality does not exist in SQL Server Express. In this tip I will show you how to build a basic CLR stored procedure to send email messages from SQL Server Express, although this same technique could be used for any version of SQL Server.

Solution
If you have not yet built a CLR stored procedure, please refer to this tip for what needs to be done for the initial setup.

sql server 2000 vs 2005

  

i would like to ask what the difference between sql server 2000 and 2005 


How to save Unicode in SQL Server 2005

  
I am using google transliteration to display the text in Hindi/Tamil
etc.

I tried to store the text appear as Hindi from textarea in an nvarchar
field of database (SQL Server 2005) , the text saved as "???????".

After retireving text from the same it display the text as "???????".

Can anyone help me how to store and retrieve the actual data from SQL
Server 2005?

I am using ASP.net,VB.Net and SQL Server 2005

connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.

  

I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

 I have two SQL Server instances installed.

 1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?


sql server 2005 enterprise edition is required

  

sql serve 2005 enterprise edition is required to work with microsoft enterprise blocks

 


need help: HTMLEditor, Sql-Server 2005 and CrystalReport

  

Hi All,
i use the Ajax Control Toolkit HTMLEditor in VS 2008 web-project and save the formated text/content in Sql-Server 2005 - it works fine!

Now, i want print the formated text in a Report, with CrystalReport...??? is this possible?

How do i handle the process? i thing, i see the forest based on all the trees not more...

Can anyone help me? how to do?

thx
 
frank
 


SQL Server 2005: Regular Expressions Make Pattern Matching And Data Extraction Easier

  

Now you can perform efficient, sophisticated text analysis using regular expressions in SQL Server 2005.

David Banister

MSDN Magazine February 2007


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