Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- Doing an "indirect" SQL SELECT
- Does anyone know how I can do an "indirect" SQL SELECT statement? (one in which the column to return from a table is not named explicitly, but is contained in a variable?)For example, instead of this:SELECT trailer FROM .... WHERE ...I need to be able to do something like this:DECLARE...
- Tags: ttobin100@..., SQL, SELECT @FieldName, DECLARE @FieldName nVarChar
- Discussion threads 2007-10-08
- sql function
- how to use exec statement in udf function to excute a variable which given as select statementDo you meanDeclare @MyQuery VarChar(500)Select @MyQuery = "Select * From MyTable"Execute (@MyQuery)You have to put the parentheses in.
- Tags: software, SQL, thiyagarajan.srinivasan@...
- Discussion threads 2007-01-02
- Oracle PL/SQL
- When i use the Oracle built-in function GET_APPLICATION_PROPERTY within the sub-query of an sql statement i get an error which states "You may not use GET_APPLICATION_PROPERTY function in SQL"...what can be the workaround for this problem?Sounds like you're using forms. Since you did not post the sql statement, I...
- Tags: Programming languages, SQL
- Q&A 2005-07-17
- Replication: SQL Server Express 2005
- Replication an user database-----------------------------I execute thisDECLARE @publicationDB as sysname;DECLARE @login as sysname;DECLARE @password as sysname;DECLARE @publication as sysname;SET @publication = N'DP';SET @publicationDB = N'DP';SET @login =N'sa';SET @password = N'AQDATA';EXEC sp_addpublication @publication=@publication, @status=N'active', @allow_push=N'true', @allow_pull=N'true', @independent_agent=N'true';and I receive this answer-->"Msg 14013, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 159This database is not enabled for...
- Tags: Databases, maria@..., Microsoft SQL Server
- Discussion threads 2007-07-17
- Can you really declare independence from Microsoft?
- Microsoft is kind of like the weather. Everybody complains about their software, but nobody does anything about. Can you *really* declare independence if you wanted to? I'm not so sure. Here's why. by John Sheesley
- Tags: Microsoft Corp., Linux, UNIX, Open Source, Operating Systems, Software, John Sheesley
- Blog posts 2008-07-03
- Avoid program bugs in VB6 with the Option Explicit statement
- In Visual Basic 6, you can use a variable in code without declaring it. Some VB programmers tout this as an advantage of VB, but, in fact, it's a serious shortcoming. Peter Aitken explains why. Most programming languages, such as C and Fortran, require that you explicitly...
- Tags: Microsoft Visual Basic 6.0, Microsoft Visual Basic, Peter Aitken, Microsoft development tools, Programming languages, Visual Basic Tips Newsletter, Variable, Development Tools, Software Development, Software/Web Development
- Technical articles 2005-07-28
- Learn Oracle: Datatypes for SQL and PL/SQL, Boolean and Large Objects (LOB)
- Use the article index for more articles on this subject.BOOLEANABOOLEAN datatype is a native PL/SQL type that lets you signify a TRUEor FALSE condition. A BOOLEAN is NULL until explicitly assigned avalue. A BOOLEAN is assigned like other variables:DECLARE v_bool BOOLEAN; v_bool2 BOOLEAN := TRUE; ...
- Tags: subject.BOOLEANA BOOLEAN, Oracle Corp., PL/SQL, SQL
- Blog posts 2006-08-29
- Evaluating Accounting Software: Print a Financial Statement to the Screen
- The process of printing a financial statement to screen can be very revealing. To start with, this allows you to see how many default financial statement formats come standard with the system. Some products provide a balance sheet and income statement while others provide numerous standard reports including a Statement...
- Tags: Accounting, Financial, Financial Statement, Financial Statements, Financial Accounting, Financial Planning, Finance
- White papers
- Declare (exe)
- Declare allows easy time billing of billable and non-billable tasks you have performed for your customers. It presents declarations in a client/project tree structure, enabling quick access to all declarations that still need to be billed. Version 1.0.6 includes improved GUI for single users. Improved looks.
- Tags: Declaration
- Software downloads 2006-03-07
- Performing basic array operations in VB.NET
- VB.NET offers a simple way of grouping data into the array structures similarly to other languages. This article explores array declaration and usage. The ability to work with arrays is important in any programming language. VB.NET offers a simple way of grouping data into the array structures...
- Tags: Microsoft Visual Basic.Net, Irina Medvinskaya, Microsoft development tools, Programming languages, .NET, Visual Basic Tips Newsletter, Array, Listing B, Listing D, Development Tools, Software Development, Software/Web Development
- Technical articles 2006-07-27
- WHERE Vs. IF Statements: Knowing the Difference in How and When to Apply
- When programming in SAS, there is almost always more than one way to accomplish a task. Beginning programmers may think that there is no difference between using the WHERE statement and the IF statement to subset the data set. Knowledgeable programmers know that depending on the situation, sometimes one statement...
- Tags: Statement, SAS Institute, Development Tools, Software Development, Software/Web Development
- White papers 2006-02-28
- show all
- SQL statement I am creating a where statement showing not like fields. But I want to show all in the range. ie. combo = fcitem = fc, reNot like statement will show item re, but I want to view the fc alsoNot like what?for example if you have the values...
- Tags: Programming languages, cjconnell@...
- Q&A 2006-08-14
- Vision Statement Mentor (msi)
- Vision Statement Mentor guides you through the steps of creating core values statements and vision statements for your church and ministries. A church vision statement or ministry vision statement is a tool to help you communicate the vision which God has entrusted to you. A vision statement can invoke passion...
- Tags: Vision, Vision Statement, Rohawk, Strategy, Management
- Software downloads 2008-02-29
- The Power of the BY Statement
- When used to its fullest potential, the BY statement can save time and effort, and add clarity and simplicity to SAS programs. It can make complex coding problems simple or accomplish in one pass what would otherwise require multiple passes of the data. Unfortunately the full power of the BY...
- Tags: Statement, SAS Institute
- White papers 2007-05-14
- SQL Output
- Hi thereI need to have a basic select statement to run automatically, which I can do, but I need the results to be saved to a txt file and then emailed to a group of users, I used to do this in oracle by using the spool statement, any ideas?hi,may...
- Tags: Declare @mailRecipients, e-mail, header, job, software, SP, SQL, tim.williams@...
- Q&A 2005-10-05
- Xamining the X Statement (and Some Other Xciting Code)
- The X statement has been briefly documented for years in the SAS Language Guide. However, the usage of this statement in code appears uncommon and its power is underutilized, especially by the novice programmer. This statement can be used to issue operating system commands during an interactive SAS session, consequently...
- Tags: Statement, SAS Institute, X Statement
- White papers 2006-02-28
- Avoiding TOO_MANY_ROWS errors in PL/SQL
- Why not use a cursorDECLARE CURSOR c_emp(p_last_name VARCHAR2) IS SELECT last_name || ', ' || first_name FROM employees WHERE last_name = p_last_name; l_employee_full_name...
- Tags: Programming languages, Databases, michael.roblin@..., Varchar2, PL/SQL
- Discussion threads 2007-08-01
- IF statement in Excel
- I am creating an IF statement and would like to place the results into another cell. Is this possible? I would like the formula to do the following: in cell E4 place the IF statement. I want to determine if cell E3 is
- Tags: cell, Microsoft Excel, software, white2golf@...
- Q&A 2006-08-09
- Financial Statement Pro (exe)
- The Financial Statement Pro is easy to use, step-by-step software that quickly calculates net worth. The Financial Statement Pro's statement of financial condition replaces the hard to read, hand written or spreadsheet based financial statements that typically do not reflect your proper net worth.The Financial Statement Pro software was developed...
- Tags: Software, Financial, Financial Statement, Financial Condition, Interactive Software Solutions, Financial Statement Pro, Financial Statements, Financial Accounting, Financial Planning, Finance
- Software downloads 2008-07-10
- << Previous
- page 1 of 1
- Next >>
