Search Results

Search found 1740 results on 70 pages for 'procedures'.

Page 5/70 | < Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >

• Transform your Oracle Tutor Documents to Your Corporate Standard

  - by mary.keane

  You have all of your company's processes documented in Oracle Tutor, and now you want to get the HTML files to reflect your company's corporate look and feel. How are you going to do this without having an HTML guru to change every HTML page? The good news is you do not need to be an HTML expert to make minor changes to your documents. All Tutor…

  Read the article

• Visual Studio 2010 SQL Server Database Project - Ignore Stored Procedures and Functions

  - by Carter

  I really like the new SQL Server Database projects in Visual Studio 2010. I also like using the "Generate DROP statements for objects that are in the target database but that are not in the database project" option in the deployment properties. However, I do not want to manage Stored Procedures and Functions using this interface; I have another…

  Read the article

• Dataset Binding stored procedures update/insert/delete

  - by Jin

  Hi all, I am currently having a problem since the DB has been changed. I am using Datasets for a c# application, and there is a user management system. For the security issues, our current DB design is like user log into app. DB returns a session ID On use of any other stored procedures, a session ID must be specified. BUT, the DB…

  Read the article

• Data Security Through Structure, Procedures, Policies, and Governance

  Security Structure and Procedures One of the easiest ways to implement security is through the use of structure, in particular the structure in which data is stored. The preferred method for this through the use of User Roles, these Roles allow for specific access to be granted based on what role a user plays in relation to the data that they…

  Read the article

• T-SQL Tuesday #24 : Dude, where's the rest of my procedure?

  - by AaronBertrand

  This month's T-SQL Tuesday is being hosted by Brad Schulz ( blog ) and the topic is one that should attract a lot of submissions: Procedures and Functions. Last week, I talked about the case against INFORMATION_SCHEMA views - I provided several examples where I feel the INFORMATION_SCHEMA views fall short of the catalog views, and expressed…

  Read the article

• Is it worth moving from stored procedures to linq ?

  - by Josef

  I'm looking at standardizing programming in an organisaiton. Half uses stored procedures and the other half Linq. From what i've read there is still some debate going on on this topic. My concern is that MS is trying to slip in it's own proprietry query language 'linq' to make SQL redundant. If a few years back microsoft had tried to…

  Read the article

• PetaPoco with stored procedures

  - by Jalpesh P. Vadgama

  In previous post I have written that How we can use PetaPoco with the asp.net MVC. One of my dear friend Kirti asked me that How we can use it with Stored procedure. So decided to write a small post for that. So let’s first create a simple stored procedure for customer table which I have used in my previous post. I have written …

  Read the article

• Creating Stored Procedures in MySQL Using HeidiSQL 4&amp;#146;s Stored Routine Editor

  In the "Write MySQL Queries Using HeidiSQL 4" article, we learned how to connect to a MySQL database and execute queries against it using the free HeidiSQL GUI client. Today, we'll learn how to create a stored procedure using HeidiSQL's Stored Procedure Editor.

  Read the article

• System Wide Performance Sanity Check Procedures

  - by user702295

  Do you need to boost your overall implementation performance? Do you need a direction to pinpoint possible performance opportunities? Are you looking for a general performance guide? Try MOS note 69565.1.  This paper describes a holistic methodology that defines a systematic approach to resolve complex Application…

  Read the article

• MySQL Input Parameters Add Flexibility to Crosstab Stored Procedures

  When generating a result set where the query contains an unknown number of column and/or row values we can use a combination of Prepared Statements, which allows us to tailor the output based on the number of data values. We can also add input parameters to a procedure to assign the field names, aliases, and even the…

  Read the article

• MySQL Input Parameters Add Flexibility to Crosstab Stored Procedures

  When generating a result set where the query contains an unknown number of column and/or row values we can use a combination of Prepared Statements, which allows us to tailor the output based on the number of data values. We can also add input parameters to a procedure to assign the field names, aliases, and even the…

  Read the article

• NHibernate and Stored Procedures in C#

  - by Jess Nickson

  I was recently trying and failing to set up NHibernate (v1.2) in an ASP.NET project. The aim was to execute a stored procedure and return the results, but it took several iterations for me to end up with a working solution. In this post I am simply trying to put the required code in one place, in the hope that the…

  Read the article

• Passing Field Names to MySQL Crosstab Stored Procedures

  Rob Gravelle demonstrates a solution for passing MySQL dynamic field names to the group_concat function using a combination of stored proc input parameters, string concatenation, and prepared statements.

  Read the article

• Passing Field Names to MySQL Crosstab Stored Procedures

  Rob Gravelle demonstrates a solution for passing MySQL dynamic field names to the group_concat function using a combination of stored proc input parameters, string concatenation, and prepared statements.

  Read the article

• CloudSeeder: CLR Stored Procedures For Creating CPU Pressure

  - by Adam Machanic

  Sometimes, in the interest of testing various scenarios that your server might encounter, it's useful to be able to quickly simulate some condition or another. I/O, memory, CPU pressure, and so on. This latter one is something I've been playing with a lot recently. CPU pressure in SQL Server creates all sorts of…

  Read the article

• Search Engine Optimization Proven Procedures That Will Guarantee Higher Page Ranking

  An important search engine optimization procedure is identifying a combination of popular keywords. You need to be careful not to go for very popular keywords since the competition for such keyword phrases is quite high.

  Read the article

• Comment Déboguer les procédures, fonctions et triggers sous SSMS 2008, par hmira

  hmira nous propose un article qui explique comment déboguer une procédure stockée, une fonction ou un trigger sous SSMS 2008 (SQL Server 2008 Management Studio). Celui-ci décrit la manière de définir des points d'arrêts, faire du pas à pas dans les blocs T-SQL, consulter le contenu des variables locales et…

  Read the article

• Survey: Most Software Bugs Due to Poor Testing Procedures

  When a bug is found in released software, the bottom-line impact on an organization is significant.

  Read the article

• Survey: Most Software Bugs Due to Poor Testing Procedures

  When a bug is found in released software, the bottom-line impact on an organization is significant.

  Read the article

• Creating Stored Procedures with Managed Code

  This article is intended to illustrate how to implement a stored procedure with managed code.

  Read the article

• Handling errors within Stored Procedures in SQL Server

  This article discusses the @@ERROR, SP_ADDMESSAGE, and RAISERROR functions within SQL Server.

  Read the article

• Warning and error information in stored procedures revisited

  - by user13334359

  Originally way to handle warnings and errors in MySQL stored routine was designed as follows: if warning was generated during stored routine execution which has a handler for such a warning/error, MySQL remembered the handler, ignored the warning and continued execution after routine is…

  Read the article

• Verify SQL Server Stored Procedures are the same on multiple servers

  I have a stored procedure I push down to all of my servers that does a custom backup job and I want to make sure all servers have the same stored procedure. Is there some way to check without going to each server and reviewing the stored procedure? Check out this to find out. New!…

  Read the article

• Coping with infrastructure upgrades

  - by Fatherjack

  A common topic for questions on SQL Server forums is how to plan and implement upgrades to SQL Server. Moving from old to new hardware or moving from one version of SQL Server to another. There are other circumstances where upgrades of other systems affect SQL Server DBAs. For example, where I work…

  Read the article

• abt oracle procedure agv and deleting the csv file from procedures of oracle

  - by kishroe

  Hi can u give me the info abt how can we pass the arg to the oracle procedures how can i delete the csv file from oracle procedures

  Read the article

< Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >