1 Resources for

nvarchar

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Create custom looping procedures in SQL Server 2005: Tim Chapman shows how to create system stored procedures that will allow you to loop through and execute statements against any type of object in SQL Server 2005. by Tim Chapman; Tags: Stored Procedure, Microsoft SQL Server, SQL, Microsoft SQL Server 2005, CLR, Exec, N, Tim, System Stored Procedure, NVARCHAR, Databases, Enterprise Software, Software, Data Management, Tim Chapman; Blog posts 2008-07-08

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
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
Generating change scripts in SQL Server 2005 Management Studio: If you are faced with a particular type of change request and it reverberates through your entire database, then generating individual scripts can be quite tedious. Discover how SQL Server 2005 Management Studio's Generate Change Script feature can help. In the typical dev environment, there is a development ...; Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Databases, Arthur Fuller, SQL Server 2005 Management Studio, Generate Change Script, SQL Server Newsletter, Database, Server, Column, Enterprise Software, Software, Data Management; Technical articles 2006-05-08

10 questions to ask yourself before optimizing your database: "Standard Columns"?Tip 8 mentions "Standard Columns". Is this in Enterprise Mananger, Query Analyzer or somewhere else? I can't find it and I'm not sure what it is. ThanksGreat QuestionsGreat Questions. What are the answers?Anyone reads this comments?where is the Standard Columns?Thanksagreed, how about answersI agree that...; Tags: Char, database, MetroMark, software, sql server, Standard Columns; Discussion threads 2005-08-23
Building solutions with MSDE and Access 2000: Rick Dobson discusses the architectural and management issues that you need to understand in order to build solutions with MSDE and Microsoft Access projects.Access 2000 sports two new features that dramatically enhance its ability to manage client/server solutions. First, it ships with the Microsoft Data Engine MSDE as an alternative...; Tags: Databases, Microsoft Office, Microsoft SQL Server, Rick Dobson, database, Microsoft Data Engine, Microsoft Access, Access Project; Technical articles 2000-02-23
10+ common questions about SQL Server data types: SQL Server has a variety of data types, and as with anything, the more options you have, the more confusing a choice can be. Most misunderstandings arise from data type limitations rather than functionality. Here are the most common questions I receive about using SQL Server data types. ...; Tags: Byte, Microsoft SQL Server, Server, Data Type, Datetime2, Databases, Enterprise Software, Software, Data Management, Susan Harkins; Blog posts 2008-05-15
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
Implement custom paging with SQL Server 2005: In previous columns, I covered the basics of using the .NET 3.5 ListView control and explained how to pair it with the DataPager control. Now I'll show you how to use these controls with a SQL Server 2005 backend to implement custom paging, in which only a subset of the...; Tags: Function, Microsoft SQL Server, Data, Paging, Row, Microsoft SQL Server 2005, DataPager, ViewState, GetData Method, ID, newIndex, Servers, Databases, Enterprise Software, Hardware, Software, Data Management, Tony Patton; Blog posts 2008-03-25
Building and using table UDFs in SQL Server: Table UDFs (user-defined functions) are one of Arthur Fuller's favorite features of SQL Server 2000 and 2005. Find out why he says that, if you've never used them, you may be in for a surprise. Table UDFs (user-defined functions) are one of my favorite features of SQL Server...; Tags: Microsoft SQL Server, UDF, Databases, Arthur Fuller, server, SQL Server Newsletter, TechRepublic Inc., Fun, Table, Enterprise Software, Software, Data Management; Technical articles 2006-08-07
How do I... Transfer logins from one SQL Server 2005 instance to another?: In my last How do I..., I discussed how to restore a SQL Server to a new server. After the article published, I had some questions on the best way to move SQL Server logins from one SQL Server 2005 instance to another SQL Server 2005 instance. ...; Tags: Login, Microsoft SQL Server, Server, Script, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management, Steven Warren; Blog posts 2007-09-25
Generating and working with GUIDs in .NET: A Globally Unique Identifier GUID is a 128-bit integer that you can use across all computers and networks wherever a unique identifier is required. Tony Patton explains how the .NET Framework makes it possible for you to create your own GUID. TechRepublic's free .NET newsletter, delivered each Wednesday, contains...; Tags: Microsoft .NET, Tony Patton, GUID, Microsoft Windows, Middleware, Databases, .NET, Application servers, Microsoft development tools, Programming languages, sample code, .NET Newsletter, TechRepublic Inc., Microsoft .NET Framework, Namespace, Microsoft SQL Server, Microsoft Corp., C#, Software Development, Software/Web Development, Operating Systems, Software, Enterprise Software, Data Management; Technical articles 2005-05-17
SQL Server Yukon: Advantages of the new PIVOT operators: Database developers who use Microsoft products have often experienced frustration at the disparity of functions between Access and SQL Server. SQL Server, which uses Transact-SQL (T-SQL), is a step behind Access in its range of features, although it is several steps ahead in terms of connectivity capabilities (i.e., more connections...; Tags: Databases, Enterprise software, Microsoft Office, Sanders Kaufman, Jr., Pivot Tables, Microsoft SQL Server, SVG, Microsoft Access, server; Technical articles 2004-03-05
Application Development: SQL Server "Yukon" and CLR integration: If you're a Microsoft programmer, you have probably invested quite a lot in the transition from Windows NT/SQL Server 7 to Windows 2000/SQL Server 2000. The transition to Longhorn/Yukon is going to require a similar investment. Enhancements to SQL Server Yukon will include more complex reporting services and better handling...; Tags: .NET, Application servers, Programming languages, Middleware, Databases, Development tools, CLR, application development, Sanders Kaufman, Jr., server, stored procedure, Yukon, Microsoft .NET, SQL, Microsoft SQL Server; Technical articles 2004-03-16
10 reasons to explicitly convert SQL Server data types: SQL Server converts data types in two ways -- the way it wants to and the way you tell it to. Most implicit conversions work the way you expect. It's the surprise conversions that cause trouble. Unless you know exactly how SQL Server converts a data type, I recommend that...; Tags: Microsoft SQL Server, Expression, Problem, Value, Data Type, CONVERT, Figure E, Figure G, Databases, Enterprise Software, Servers, Software, Data Management, Hardware, Susan Harkins; Blog posts 2008-03-13

<< Previous
page 1 of 1
Next >>

Cisco IOS Command Chart (IOS v.12+): Becoming proficient with Cisco equipment means remembering a whole new set of commands. These command charts give you a quick way to look up the needed IOS commands and switches when you need them.; Buy Now

TechRepublic Power Checklist: Securing Windows XP: If you have just finished installing Windows XP and you think the work is done, you're wrong. Some of the most important steps to getting Windows XP u ...; Buy Now