stored

The interest indicator controls interest calculation. The following data is stored in the system under the interest indicator:The calendar type used for defining the days due for interest. You can choose between the bank, French, Japanese, and Gregorian calendars Interest rates and conditions (see Modifying Interest Rates) Form for the lists You can also specify under the interest indicator tha

Interested in location and preservation of responsive documents to comply with court ordered discovery requests? Well, now it is easy with help of Technology Pathways, LLC that announced today the release of e.s.i.DiscoverTM, a new electronic-discovery search appliance. The e.s.i.Discover Search Appliance indexes millions of documents contained on servers and workstations throughout an enterprise

A stored-value card represents money on deposit with the issuer, and is similar to a debit card. One major difference between stored value cards and debit cards is that debit cards are usually issued in the name of individual account holders, while stored value cards are usually anonymous.The term stored-value card does not necessarily mean the funds data is physically stored on the card. In many

Any amount of food you eat that isn’t burned off is stored as body fat. That’s the bad news. Your daily calories must be equal to or less than the number of calories your body burns, both while active and at rest. The good news is there are several ways you can do this. The first [...]

Note - This tutorial also applies to Flock, an unofficial derivative of Firefox. If you have been using Firefox for some time, chances are you have saved a good number of passwords for auto-filling of sign in information at some websites. This is a particularly good feature in all new web browsers, but what to do if you save a wrong password by mistake? Or say you want to delete a stored account

xp_cmdshell Executes a given command string or batch file as an operating-system command shell and returns any output as rows of text. Permission/Rights: Only SysAdmin fixed role can execute it. Syntax xp_cmdshell {‘command_string‘} [, no_output] Arguments ‘command_string‘ Is the command string to execute at the operating-system command shell or from DOS prompt. command_string is varchar(

Can a stored procedure call itself or recursive stored procedure? How many level SP nestingpossible?Ans:Yes. Because Transact-SQL supports recursion, you can write stored procedures that call themselves.Recursion can be defined as a method of problem solving wherein the solution is arrived at byrepetitively applying it to subsets of the problem. A common application of recursive logic is to performnumeric computations that lend themselves to repetitive evaluation by the same processing steps.Stored procedures are nested when one stored procedure calls another or executes managed code byreferencing a CLR routine, type, or aggregate. You can nest stored procedures and managed codereferences up to 32 levels.

As a student living abroad I am highly dependant on computers in the university library to write my thesis papers. The only disadvantage is that when saving my work and retrieving it the next day, it becomes a problem especially when somebody else is using that computer. This problem was resolved once the university discovered Online [...]

· Stored procedure can reduced network traffic and latency, boosting application performance.· Stored procedure execution plans can be reused, staying cached in SQL Server's memory,reducing server overhead.· Stored procedures help promote code reuse.· Stored procedures can encapsulate logic. You can change stored procedure code withoutaffecting clients.· Stored procedures provide better security to your data.

While playing with SQL Server 2008 I found new feature of “Row Constructors”, where I can load temp table from stored procedure directly. Look at the following SQL where I have to use OpenQuery from server to itself creating loopback server and execute stored procedure and insert into temp table. INSERT INTO #TempTable SELECT *      FROM OPENQUERY(ServerName, ‘exec StoredProc’) Above mentioned same query can be now [...]

· Stored procedure can reduced network traffic and latency, boosting application performance.· Stored procedure execution plans can be reused, staying cached in SQL Server's memory,reducing server overhead.· Stored procedures help promote code reuse.· Stored procedures can encapsulate logic. You can change stored procedure code withoutaffecting clients.· Stored procedures provide better security to your data.

Here is the situation. You are writing a program in Java. You need to access data in a Microsoft SQL Server via stored procedure and the data has an XML field. A what field? SQL Server 2005 introduces a new datatype for XML. It is essentially a blob field that you can perform XML operations [...]

Can a stored procedure call itself or recursive stored procedure? How many level SP nestingpossible?Ans:Yes. Because Transact-SQL supports recursion, you can write stored procedures that call themselves.Recursion can be defined as a method of problem solving wherein the solution is arrived at byrepetitively applying it to subsets of the problem. A common application of recursive logic is to performnumeric computations that lend themselves to repetitive evaluation by the same processing steps.Stored procedures are nested when one stored procedure calls another or executes managed code byreferencing a CLR routine, type, or aggregate. You can nest stored procedures and managed codereferences up to 32 levels.

UDF can be used in the SQL statements anywhere in the WHERE/HAVING/SELECT section where asStored procedures cannot be.UDFs that return tables can be treated as another rowset. This can be used in JOINs with other tables.Inline UDF's can be though of as views that take parameters and can be used in JOINs and otherRowset operations.

A stored procedure is a named group of SQL statements that have been previously created and storedin the server database. Stored procedures accept input parameters so that a single procedure can beused over the network by several clients using different input data. And when the procedure ismodified, all clients automatically get the new version. Stored procedures reduce network traffic andimprove performance. Stored procedures can be used to help ensure the integrity of the database.e.g. sp_helpdb, sp_renamedb, sp_depends etc.

Tokyo - A Japanese university plans to return about 250 pieces of original animation art to the Walt Disney Company that were mislaid in storage after traveling to Japan nearly five decades ago. Disney said that the art — cels, backgrounds, preliminary paintings and storyboard sketches — was part of a collection that was handpicked by Walt Disney himself. It was sent to Japan in 1960 for a touring exhibition timed to the opening of the film “Sleeping Beauty.” The exhibition opened at Mitsukoshi Department Store in Tokyo in May of that year and traveled to 16 other stores throughout Japan.For more information, Go here.Taken from

How many times we all DBA’s might have wonder which stored procedure is executing most in the database? I have wondered it often and I have written following small script which gives me answer to my above questions. I am also retrieving few additional data along with the highest used SP names. You can change the [...]

A stored procedure is a set of SQL statements used to perform specific tasks. A stored procedure resides on the SQL server and can be executed by any user who has the appropriate permissions. Because the stored procedures reside on the SQL server, you do not need to transfer SQL statements to the server each time you want to perform a task on the server. This reduces the network traffic. When you want to execute a procedure, you only need to transfer the name of the procedure. However, if the procedure takes any parameters, you also need to transfer the parameters along with the procedure name.You can create a stored procedure by using the Create Procedure statement asfollows:Create Procedure ProcNameAsSQL statementsReturnIn this statement: ProcName: Represents the name of the stored proce

As current through the coil increases the magnetic field of the coil also increases, and electrical energy is stored in the coil as a magnetic field. The self induction is in coil N and current in the coil I; then the Energy stored in the coil; U=L.I.I/2

Well that sure was a mouthful. Sure, there are those minor changes to the iPhone UI that may or may not materialize, but there are also some serious changes in store for the iPhone v2.0.The iPhone SDK, freely downloadable from Apple, is proving to be a...

What is bit datatype and what's the information that can be storedinside a bit column? Bit datatype is used to store boolean information like 1 or 0 (true orfalse). Untill SQL Server 6.5 bit datatype could hold either a 1 or 0and there was no support for NULL. But from SQL Server 7.0 onwards,bit datatype can represent a third state, which is NULL

We got some questions about, what to do if you stored your bike for the last few months, and kind of mechanical checks should be preformed before going for a ride. Your motorcycle will need a good going over before your first ride. It's best to chec...

The Internet Explorer stores the passwords, which you have chosen to save, in encypted form in the Registry. And as such, should you forget any and should you want to recover such forgotten or lost passwords, you can do so by . . .

You can lose your weight by doing different types of weight loss exercises. Weight loss exercises will include all physical activities that lead to movement. Weight loss exercises include walking, dancing or doing any physical activities. You can be physically active and lose your weight by going to gym and playing sports. You can also [...]

Just a day ago, I received interesting question about correct syntax for Stored Procedure. Many readers of this blog will think that it is very simple question. The reason this is interesting is the question behavior of BEGIN … END statements and GO command in Stored Procedure. Let us first see what is correct syntax. Correct Syntax: CREATE PROCEDURE usp_SelectRecord AS BEGIN SELECT * FROM TABLE END GO I have seen many new developers write statements after END statement. This will not work but will probably execute first fine when stored procedure is created. Rule is anything between BEGIN and END will be created as part of the stored procedure and will work fine. However, anything after END statement will be not part of Stored Procedure. Nesting of BEGIN … END statement is allowed in Stored Procedure. Incorrect Syntax : (This may not throw an error) CREATE PROCEDURE usp_SelectRecord AS BEGIN SELECT * FROM TABLE END Other Statements GO Reference : Pinal Dave (http://www.

Run following simple script on SQL Server 2005 to retrieve all stored procedure in database. SELECT * FROM sys.procedures; This will ONLY work with SQL Server 2005. Reference : Pinal Dave (http://www.SQLAuthority.com)

SQL Server has released SQL Server 2000 edition before 7 years and SQL Server 2005 edition before 2 years now. There are still few users who have not upgraded to SQL Server 2005 and they are waiting for SQL Server 2008 in February 2008 to SQL Server 2008 to release. This blog has is heavily visited by users from both the SQL Server products. I have two previous post which demonstrates the code which can be search string in stored procedure. Many users get confused with the script version and try to execute SQL Server 2005 version on SQL Server 2000, they do send me email or leave comment that this does not work. I am going to list both the post here with clearly indicating the SQL Server version. I am sure this will clear some of the doubts. SQL Server 2000 USE AdventureWorks GO --Option 1 SELECT DISTINCT so.name FROM syscomments sc INNER JOIN sysobjects so on sc.id=so.id WHERE sc.text LIKE %Employee%' GO --Option 2 SELECT DISTINCT o.name ,o.xtype FROM syscomments c INNER JOIN sysobje

Is it time to say goodbye to CDs, DVDs, Zip drives?A Kerala student has developed a technique for portable data whereby the data can now be stored on ordinary paper. And to boot, larger amounts of data can be had on lesser space.The immediate question that pops into the mind is how to retrieve the data. Will it be as easy as feeding a floppy disc or CD into the drive and having it on the monitor? Perhaps it will be much easier than that. The piece of paper or even plastic sheet storing the data has only to be scanned in the scanner and read over the monitor. So wait, scan drive would be part of your computer.Named “Rainbow Technology”, the new technique is the brainchild of Sainul Abideen, who has just finished his MCA at Muslim Educational Society Engineering College in Kuttipuram in Kerala’s Malappuram district.The extremely low-cost technology will drastically reduce the cost of storage and provide for high-speed storage as well. Files in any format such as movie files, songs,

Stored procedure with dynamic SQL and embedded parametersThe Stored ProcedureCreate proc authenticate (@uid nvarchar(25),@pwd nvarchar(25))as DECLARE @uid VARCHAR(64) DECLARE @pwd VARCHAR(64) DECLARE @SQLString NVARCHAR(500) DECLARE @ParmDefinition NVARCHAR(500) /* Build the SQL string once.*/ SET @SQLString = N'SELECT * FROM users WHERE userid = @uid AND password = @pwd' SET @ParmDefinition = N'@login VARCHAR(64), @password VARCHAR(64)'Server side code:cmd.CommandText = "authenticate";cmd.CommandType = CommandType.StoredProcedure;cmd.Parameters.Add( "@uid", strUserName);cmd.Paramerters.Add( “@pwd, strPassword);con.Open();string result = (string)cmd.ExecuteScalar();oCon.Close();In this case,bSQL Injection would NOT be possible. Hence what I would like to summarize is if at all we have to use dynamic SQL in stored procedure, always use embedded parameters in dynamic SQL

Let us examine SQL Injection in Stored Procedure. This would be 1 of the vulnerable cases.The Server Side Code would be something like:oCmd.CommandText = "sp_login";oCmd.CommandType = CommandType.StoredProcedure;oCmd.Parameters.Add( "@loginId", strUserName);oCmd.Paramerters.Add( “@password”, strPassword);oCon.Open();string result = (string)oCmd.ExecuteScalar();oCon.Close();====================================================================The Stored Procedure would be:CREATE PROC sp_login (@loginid nvarchar(25),@password)AS DECLARE @SQLString NVARCHAR(500) DECLARE @loginid VARCHAR(64) DECLARE @password VARCHAR(64) /* Build the SQL string once.*/ SET @SQLString = 'SELECT * from cust_users WHERE login_id = '+ ''''+@loginid+'''' + 'AND password = '+ ''''+@password+'''' EXECUTE sp_executesql @SQLString====================================================================If the user input is as follow

I was going through comments on various posts to see if I have missed to answer any comments. I realized that there are quite a few times I have answered question which discuss about how to call stored procedure or query on linked server or another server. This is very detailed topic, I will keep it very simple. I am making assumptions that remote server is already set up as linked server with proper permissions in application and network is arranged. Method 1 : Remote Stored Procedure can be called as four part name: Syntax: EXEC [RemoteServer] .DatabaseName.DatabaseOwner.StoredProcedureName ‘Params’ Example: EXEC [DEVSQL] .AdventureWorks.dbo.uspGetEmployeeManagers ‘42′ Method 2 : Use Distributed Query functions (OpenQuery()) Syntax: SELECT * FROM OPENQUERY([RemoteServer],DatabaseName.DatabaseOwner.StoredProcedureName) Example: SELECT * FROM OPENQUERY([DEVSQL],AdventureWorks.dbo.spAdmin_GetAllUsers) Let me know if you want me write about above two methods in d

Dopo il precedente post ho notato che è possibile tramite il wizard Aggiungi nuova procedura SQL con Designer attivare il debug su stored procedure:Dopo aver attivato la modalità si può lanciare la stored procedure direttamente dal wizard:Nel caso specifico accetta un parametro di tipo VarChar:adesso si può procedere con F10 e Watch per controllare il contenuto di una determinata variabile:

Is it any wonder why Google is the fastest growing brand for the second year in a row? They are a company focused on people, run by brilliant, friendly people. They spend millions of dollars researching what you and I like and don't like. They are a business that aims to make you and me happy.Yet, in order to successfully operate as the top search engine, Google has to spend millions of dollars researching and evaluating you and I.You may not know it, but every time you search for something on Google your information is recorded, sorted, and stored in a database. Should you be worried?Exactly what information is stored? Only everything that anyone else has access to: what internet browser software you are using, where you are located, what you have searched online for in the past, what websites you frequent the most, and - in a lot of cases - your age, gender, education, income, etc.This technology brings up the question as to whether or not Google knows too much.While there is no eas

Jr. DBA in my company only have access to the database which they need to use. Often they try to access database and if they do not have permission they face error. Jr. DBAs always check which database they have access using following system stored procedure. It is very reliable and provides accurate information. Sytanx: EXEC sp_MShasdbaccess GO ResultSet: ( I have listed only one column) AdventureWorks AdventureWorksDW master model msdb MyDB ReportServer ReportServerTempDB tempdb Reference : Pinal Dave (http://www.SQLAuthority.com)

I was glad when I discovered this Extended Stored Procedure myself. I always used different syntax to retrieve server information. Many of information I was looking up using system information of the windows operating system. Syntax: EXEC xp_msver ResultSet: Index Name Internal_Value Character_Value ------ -------------------------------- -------------- ------------------------------------- 1 ProductName NULL Microsoft SQL Server 2 ProductVersion 589824 9.00.3042.00 3 Language 1033 English (United States) 4 Platform NULL NT INTEL X86 5 Comments NULL NT INTEL X86 6 CompanyName NULL Microsoft Corporation 7 FileDescription NULL SQL Server Windows NT 8 FileVersion NULL 2005.090.

In my organization we rename the database on development server when are refreshing the development server with live data. We save the old database with new name and restore the database from live with same name. If developer/Jr. DBA have not saved the SQL Script from development server, he/she can go back to old Server and retrieve the script. There are few interesting facts to note when the database is renamed. When renamed the database, filegroup name or filename (.mdf,.ldf) are not changed. User with SA privilege can rename the database with following script when the context of the database is master database. USE master; GO EXEC sp_dboption AdventureWorks, 'Single User', True GO EXEC sp_renamedb 'AdventureWorks', 'AdventureWorks_New' GO EXEC sp_dboption AdventureWorks, 'Single User', False GO Reference : Pinal Dave (http://www.SQLAuthority.com)

Want to lose weight to get better appearance, better health or even both? In order to achieve your desire, here are free weight loss tips that helps you a lot. These free weight loss tips are very helpful for those who didn’t get good results by following yo-yo dieting. The free weight loss tips helps you to loose [...]

Following quick tutorial demonstrates how to create T-SQL script to copy complete database schema and all of its objects such as Stored Procedure, Functions, Triggers, Tables, Views, Constraints etc. You can review your schema, backup for reference or use it to compare with previous backup. Step 1 : Start Step 2 : Welcome Screen Step 3 : Select One or Multiple Database If Script all objects in the selected database checkbox is not selected it will give options to selected individual objects on respective screen. (e.g. Stored Procedure, Triggers and all other object will have their own screen where they can be selected) Step 4 : Select database options Step 5 : Select output option Step 6 : Review Summary Step 7 : Observe script generation process Step 8 : Database object script generation completed in new query window Reference : Pinal Dave (http://www.SQLAuthority.com), All images are protected by copyright owner SQLAuthority.com

By Jesse Miller Data is anything that you have entered into your computer. It is placed or read by small magnetic head that floats over the spinning platters. It is stored on the floppy disk by read write head of the floppy disk drive. Computer memory allows it to function in various ways, for example software to be run and data to be saved and processed. While all forms of memory work together, RAM is considered the main memory because most data is stored in RAM before it is registered in any other storage device. A computer uses Ram to hold temporary data needed to complete tasks. This enables the computer's CPU (Central Processing Unit), to access data stored and it can be retrieved much quicker than from the hard drive. A computer might store some or all of its program in memory that is kept separate from the data it operates on. Because memory is one of the most important parts of a computer, it has been redesigned to enable it to store more data and work faster. Such as Double D

Author: Dejan SundericPaperback: 696 pagesPublisher: McGraw-Hill Osborne Media; 2 edition (May 16, 2003) Language: EnglishISBN: 0072228962 Design T-SQL and SQLXML SolutionsDiscover the key concepts, techniques, tips, and tricks professional developers need to know in order to take full advantage of stored procedures in the SQL Server environment. SQL Server 2000 Stored Procedure & XML Programming, Second Edition teaches you to manage SQL Server resources using Enterprise Manager, Query Analyzer, SQL Profiler, Visual SourceSafe, Visual Basic, and Visual Studio .NET. Learn basic and advanced XML with special focus on features that are in use in Microsoft database and development tools. Develop dynamic, Web-based applications using SQL Server's XML capabilities. This helpful resource contains simple explanations for developers who are just starting to work with stored procedures and XML, as well as advanced recommendations and techniques for experienced developers.Essential Skil

Author: Matt ShepkerPaperback: 346 pagesPublisher: Sams; 1st edition (January 15, 2000) Language: EnglishISBN: 0672318865 Writing Stored Procedures for Microsoft SQL Server focuses on teaching you not only how to build effective stored procedures, but also how to optimize and streamline them for long term use. Get an understanding of how SQL Server interprets stored procedures verses direct access via SQL queries. This is followed by detailed instructions on creating and maintaining a repository of stored procedures. Once you know how stored procedures are created and built, you are taught how to determine which logic within an application makes sense to be put into this scheme. Additionally, you're provided with guidance on making stored procedures that are portable across applications. Zip Password: T0sT@rN@

Author: Tony BainPaperback: 288 pagesPublisher: Apress; 1 edition (September 24, 2003)Language: EnglishISBN: 1590592875 Stored procedures are compiled T-SQL statements that reside on the database, and are the cornerstone of successful data manipulation;data-handling operations of any complexity make use of them. This book is an in-depth guide to a key area of database development.This book tackles real-world problems faced by developers when working with stored procedures, showing how to solve these problems, avoid the common pitfalls and work around them, to produce faster, more robust stored procedures. Put simply: if you want to write better stored procedures, then this is the book for you. Zip Password: T0sT@rN@

Previous post: Store Document / File to SAP Get document / file stored in SAP Business Document. REPORT ZAALTES1 line-size 300. INCLUDE officeintegrationinclude. " used by DOI * Get descr_list TYPES: BEGIN OF SOI_DOCUMENT_TYPE_DESCR, DOCUMENT_TYPE TYPE SOI_DOCUMENT_TYPE, " prog id TYPE_FULL_NAME(70) TYPE C, " full name TYPE_SHORT_NAME(20)

In Oracle è possibile tramite query conoscere la lista dei package: SELECT object_name FROM user_objects WHERE object_type = 'PACKAGE'oppure dato un package la lista delle stored procedures contenute:SELECT OBJECT_NAME, PROCEDURE_NAME FROM USER_PROCEDURES WHERE OBJECT_NAME = 'name package'infine data una stored procedure è possibile conoscere il nome dei parametri, il tipo e se sono in ingresso o uscita:SELECT * FROM USER_ARGUMENTS WHERE PACKAGE_NAME = 'name package' AND OBJECT_NAME = 'name stored procedures'

Picture this, hundreds of songs on your computer and you mobile has limited storage space but still you can listen to all of your song collection via your mobile phone.Well Winamp's latest beta release 'Winamp Remote' does that. So now you can turn your home computer into a streaming music server for your cell phone. Winamp Remote on Mobile connects you with an entirely new level of freedom - the freedom to choose. Now, change your music with your mood. Well if you are thinking about the playback quality, then heres' the reply: Winamp Remote on Mobile automatically streams content to your mobile device's browser at the appropriate bitrate for your data connection and format. That means you'll receive a optimized playback experience so you can:- Access your home music on your mobile phone 24/7- Stream your favorite tunes from Winamp- Manage your mobile music experience with ratings & playlistsSo how do i do this ? Follow below instruction.a. Go to http://www.winamp.com and downloa

At the moment the police in the United Kingdom are thinking of adding everyone to their DNA database. Do you think that this is a good thing? or a bad thing? We need your feedback to help this site grow !!! I personally think its a totally bad thing as your DNA can be found almost anywhere you go, say for instance you scratched your head at a crime scene, and didn�t know it was a crime scene, the police would be on your back like a dog to a rabbit.....and most of all you will have to explain why your hair was found at that particular spot. These little things could be enough to send you to prison for something that you haven�t done, so here is a chance to have your say. Should we all walk around wrapped in Clingfilm........lol

At home, our planes are stored in heated hangars when we aren't flying them. We pay a fairly hefty amount of rent for the privilege, but it's better than keeping the planes outside in the cold and in the snow. When we are on the road, a typical charge for putting our planes in a heated hangar is around $200 - the majority of the cost goes to reheating the hangar air after having to pull the doors open 50 feet wide to let the plane in. Sometimes if we purchase fuel the nice people at the FBO will hangar our plane for free, like on this trip. Today our airplane is warm and snug in a heated hangar, waiting until we return home. That way I don't have to worry about cranky batteries, frozen radios, stuck pressurization valves or exploded pop cans in the commissary bins.I found this on AvCanada. This looks like the central deice facility at Toronto Pearson. If you need deicing, you pay $450 for the privilege of going onto the deice ramp and sitting there while 2 types of fluid are