1 Resources for

declare @fieldname nvarchar

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

Integrated System Continuity Solutions for Virtual System Consolidation
Live Webcast: Integrated Security: Simplified and Scalable Threat Management
Live Webcast: Save Time, Money and Manpower While Eliminating Redundancies from Your Data Backups

TechRepublic 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

Additional Resources

Why does this Trigger go off?: I have created a SQL trigger that should only work if both fields are updated. Can someone tell me why when ony one field is uptated that this trigger goes off. Thank YouCREATE TRIGGER send_update_requeston dbo.ONSA_NSSFOR UPDATEAS--- Send a Update request to the owning ONSA/AGENTDeclare @ID NVARCHAR (4000)Declare @subject...; Tags: UPDATE, SELECT; Q&A 2006-06-28
Generate dynamic SQL statements in SQL Server: When you need to solve a tricky database problem, the ability to generate SQL statements is a powerful tool -- although you must be careful when using it. This article explores how you can use this functionality to generate SQL statements on the fly. Dynamic SQL statements A...; Tags: Parameter, Procedure, Microsoft SQL Server, Statement, Server, SQL, SalesHistory, usp_GetSalesHistory, EXECUTE, Tim, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Tim Chapman; Blog posts 2008-03-10
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

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
Access query to combine table fields: How do I construct an Access query to combine table fieldsOpen the query in design viewIn the Lower section, in the Field of teh column where you want to display the joined fields type the formulaExampleFieldname:[First Name] & [Last Name]orFieldname:[First Name]&" " & [Last Name] (if you need space between...; Tags: acampbell@..., First Name, Last Name, Microsoft Access, software; Q&A 2004-10-06
ACCESS DATABASE: Date Field: We use a lot of copying records. Although we have formatted the date field using the input mask (99/99/00;0;_) for a short date (MM/DD/YY) it still records the time. When we copy a record, it does not allow us to change the date of the new record because...; Tags: claire.ringel@..., database, Microsoft Access, new data, software; Q&A 2004-12-01
SQL Server, Query Last month, always: I am trying to create a view in microsoft sql server 2005, where it pulls in invoice details for last month, i can use the between command and get it working just fine, but i have to change it every month, the view is used for a report that runs...; Tags: DatePart, GetDate, andresk@..., programming, Microsoft SQL Server; Q&A 2006-07-12
Execute Stored Procedure in a Resultset: I have a sql server resultset that returns productid numbers. I would like to loop thru this resultset and run a stored procedure using the productid as the input parameter. Any samples would be helpful. thanksIn T-SQLsome thing likeDeclare csr_Products cursor For insert your query hereDeclare...; Tags: Congero, productID, resultSet, software, database, programming, cursor; Discussion threads 2007-02-21
Visual Basic 6.0 help: I'm getting an error Run time error '6' overflow. Help me!! Tell me what's wrong.Private Sub cmdbutton_ClickDim population As IntegerDim years As Integeryears = 0population = 6000000Do While population > 10000000population = population * 0.014years = years + 1LooppicWhen.Print "In"; years; "Population will be"; population;End SubDear Friend,It is very...; Tags: dodotwilson@..., it management, Microsoft Visual Basic, Microsoft Visual Basic 6.0; Discussion threads 2004-10-20
Making a report via CR 10 in VBScript: Hi to all, Can anyone tell me how to generate a report in VBScript using a crystal report 10? Is there a tutorial on this or any site that can help me on this? Many thanks in advance.Thanks.100 points?Try this, it's close, but you may need to work...; Tags: Scripting languages, Try This; Q&A 2006-04-23
Access:Have 1field autofill another?: My form has 6 fields and all but 1, have data input via ten-key pad. Is it possible to have one field entry auto fill another (e.g. "MainDTCode"=24 "Code"=Set) without requiring alpha key entry or a "List Box"?Sure you can!If you use the AfterUpdate event on any of your...; Tags: jpadilla, MainDTCode, software, VBA, VBA CODE; Q&A 2005-12-23
Learn PL/SQL: Declaring Variables, Named vs Anonymous Blocks: This is part 2 of a series on learning PL/SQL. If you are new to PL/SQL, you should read part 1 first. Also, check out the Article Index. Declaring VariablesWe'vespoken about the declaration section of a PL/SQL block. The declarationsection is the first section of a block....; Tags: Programming languages, Databases, PL/SQL, declaration section; Blog posts 2006-07-30
How do I get Task ID: How do I get my own Task ID in VB6. (I know I can use Shell to start and retrieve one, I just want my own!)Check out the App objectUm... "Task ID"?App.ThreadID returns the thread ID.App.hInstance returns the instance handle. (Not very useful in Win32 - See Dan Appleman's "Visual...; Tags: Task; Discussion threads 2005-09-09
Is SQL a legitimate programming language?: Developers often dispute the merits of SQL as a legitimate programming language, but this misses the point. SQL is a powerful 4GL for accessing data.Let’s face it: Bigotry within the ranks of the development community is rampant. Java developers look down on .NET stalwarts, and vice versa. Surprisingly, I’ve noticed...; Tags: Programming languages, Databases, programming, Baseline Inc., programming language, SQL; Technical articles 2002-08-26
MIL - Read Table (zip): MIL - Read Table is a powerful automation tool that can read table from SAP. Using this application, you can instantly view and search table and data from SAP. MIL - Read Table is designed for high flexibility, numerous options enable you to read SAP table that best suits your...; Tags: SAP AG, Microsoft Windows, .Net, Productivity, Operating Systems, Software, Software Development, Software/Web Development; Software downloads 2008-02-05
Yatzee (zip): Yatzee is a game of dice. The purpose of the game is to fill in the 4 columns achieving the highest possible score in each field. These columns are Downwards you have to fill in the fields starting with your score in 1s and ending with your score in Yatzee...; Tags: Field, Score, Yatzee, Games, Personal Technology; Software downloads 2006-08-04
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
Incorporate SQL Server UDFs in your .NET applications: User Defined Functions UDFs are a powerful feature that every developer who works with SQL Server needs to know. Learn how to incorporate UDFs in your next .NET project. Database interaction is a standard feature of most .NET applications, with SQL Server as the popular choice for the...; Tags: Microsoft SQL Server Transact-SQL, Microsoft .NET, Microsoft SQL Server, Databases, Tony Patton, .NET, Middleware, Database interaction, User Defined Function, .NET Newsletter, Function, Method, Procedure, User-defined Function, Listing B, Scalar, Listing D, Enterprise Software, Software, Data Management; Technical articles 2005-10-18

<< Previous
page 1 of 1
Next >>

Troubleshooting Patch Cables Power Checklist: Call them what you want: patch, Ethernet, category 5, or even cat 5e cables. Regardless of the moniker, Ethernet patch cables perform the bulk of the ...; Buy Now

Troubleshooting A Failed Hard Drive Power Checklist: The hard drive is one of the most important components in a computer because this is where most of us store all our data. As a result, hard drive prob ...; Buy Now