1 Resources for

select dbo.wholename

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Creative uses for COALESCE() in SQL Server: Arthur Fuller shows you two unusual uses of the COALESCE function in SQL Server. For instance, you can generalize its use, as well optimize its performance and make its results constantly available. COALESCE accepts a series of values and a value to use in the event that all...; Tags: Microsoft SQL Server, Listing B, Databases, Arthur Fuller, server, SELECT dbo.WholeName, SQL Server Newsletter, Problem, Column, COALESCE, Enterprise Software, Software, Data Management; Technical articles 2007-05-14

Additional Resources

table join: Hey guys what is the best way to join a table like this let say I've got a table Towns with a pkID and TownName field. And I've got a table named Destination with a pkID, DepartureID, DestinationID. Now destination and departure obviosly refer to the towns pkID field.So how...; Tags: pkID, SELECT; Discussion threads 2005-05-17
Sql Select from Databases on Multiple MSSql Servers: Is there a way to include the server name in an sql select statement. (E.g select ([select columns] from server1.db1.dbo.table1 , server2.db2.dbo.table2 where [where statements])if not is there any other way to achieve thisLook up sp_addlinkedserverBeen a long time but yiou can then useselect * from Link.dbo.TableWhere link = server.database.Usually...; Tags: Programming languages, Databases, awcrichton@..., SQL, database; Discussion threads 2007-05-16
Understand the ambiguities of compound JOINs in SQL: Arthur Fuller explains why he wants developers to think about this general principle: Compound JOINs become nonsensical when one of the clauses references only one of the tables. This article begins with a test. Look at the SQL below and determine, without using your computer, what the ...; Tags: SQL, Arthur Fuller, dbo.Orders.OrderID, dbo.Orders.CustomerID, Databases, SELECT dbo.Customers.CustomerID, NULL CustomerID, OUTER JOIN dbo.Orders, dbo.Customers, SQL Server Newsletter, TechRepublic Inc., Clause, Row, dbo.Customers.CustomerID, Programming Languages, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Technical articles 2005-07-25
Look up values in SQL Server using range joins: Be careful when dealing with floating numberNice, but rather than altering MinWeight to 1.01 we should alter the join condition with x < 1 and x = dbo.ShippingRates.MinWeight AND dbo.Shipments.Weight < dbo.ShippingRates.MaxWeight); Tags: Look-up, MinWeight, sql, join, sanjaya.tio@..., software, Microsoft SQL Server, server; Discussion threads 2006-05-16

Understand the ambiguities of compound JOINs in SQL: good use of on clauseActually, I do use elements of the on clause that only reference one table to good effect. I use it when the table I'm joining with has a lot of records in it that I would like to filter out before joining, (e.g. a description lookup...; Tags: clause, dbo.Customers.CustomerID, dbo.Orders.CustomerID, dominic@..., join, joins, software, SQL, sql server; Discussion threads 2005-11-15
Help with SQL Query (Date ranges): I've been struggling with a SQL query and can't find a answer anywhere, although I've come kinda close. I need to pull a range of users by hire date BUT just the month and day. For example I want to pull all users who had a hire date...; Tags: ADynes@..., DatePart; Discussion threads 2007-07-11
Date Format and correlated subquery: I need to take a month and day field in a table, and update a new date field, based upon the month and year. I tried this query, which says it updates the records, but none of the date fields are updated. Can someone tell me what is...; Tags: dateTime, FETCH NEXT, programming, Randy.L.Kemp@...; Discussion threads 2004-11-05
Alter every table in a SQL database: Adding two columns to every table in a database that contains hundreds of tables is impractical to do by hand. Arthur Fuller describes how simple it is to create a query that performs this task. All developers make mistakes from time to time; sometimes this happens...; Tags: SQL, Databases, Arthur Fuller, database, ALTER TABLE NorthwindTest.dbo, ADD LastUpdated TimeStamp NULL, LastUpdated TimeStamp, SQL Server Newsletter, TechRepublic Inc., Table, Storage, Hardware, Enterprise Software, Software, Data Management; Technical articles 2005-07-22
Finding the highest value in several SQL Server columns: If your task is to return the maximum value contained on a row from n columns, you may want to program defensively, anticipating that some new columns might be added. See why Arthur Fuller says this approach can leave you with useful functions. You have a SQL Server table...; Tags: Microsoft SQL Server, Databases, Arthur Fuller, server, supposition, SQL, SELECT dbo.Max2, MinMaxID, SQL Server Newsletter, Column, NULL, dbo.Max2, Enterprise Software, Software, Data Management; Technical articles 2007-02-26
summarize by date in a sql statement: I am trying to write a report in Excel, I am using 3 tables from a sql server database, one table has tech labor by invoice which I want to sum by date, the 2nd table is Tech name and id #,the 3rd table is time clock entry by date....; Tags: Char, INSTHIST.DATESTAMP, INSTHIST.DATESTAMP,121, INSTHIST.LABOR_TIME, MECHANIC.MECHANIC_NAME, programming, sparkee16@..., SQL; Q&A 2005-12-23
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
Email Trigger HELP: Hi,we use sql 7 and i want to be able have an email sent to a email address whenever an order over £5000 is placed.This is what i have the moment, and i do receive an email but i dont know how to show the customer name.CREATE TRIGGER xackmailcef ON...; Tags: mahmad@..., e-mail; Discussion threads 2007-07-24
Finding the highest value in several SQL Server columns: greatest at leastFiding the highest or lowest values in a row is something that I stumbled upon years ago.In my job I have to handle several RDBMSs, among them MSSQL, Oracle, Postgresql and MySQL.I added a couple of function in my MSSQL library named dbo.least(@n1,@n2) and dbo.greatest(@n1,@n2) since I...; Tags: philippe.e@..., NULL VALUE, greatest, least, feedback, arg, Microsoft SQL Server, server; Discussion threads 2007-02-27
How do I use BCP in SQL Server?: The Bulk Copy Program BCP is a command-line utility that ships with Microsoft SQL Server. With BCP, you can import and export large amounts of data in and out of SQL Server databases quickly and easily. Any DBA who has utilized this functionality will agree that BCP is an essential...; Tags: Microsoft SQL Server, Server, Bulk Copy Program, Databases, Storage, Enterprise Software, Software, Data Management, Hardware, Steven Warren; Blog posts 2008-03-28
EMC CLARiiON Backup Storage Solutions Backup to Disk Guide with LEGATO NetWorker DiskBackup Option (DBO): Motivated by the reality that data loss can bring productivity to a standstill, push customers to competitors, cost staggering sums in lost revenue, and sent IT staff scrambling, businesses are now focusing more than ever on the ability to quickly recover data. Backup-to-disk is emerging as a technology that...; Tags: Legato, Disk, EMC Clariion, EMC Corp., Backup-to-disk, Storage, Backups, Hardware; White papers
Building a data values dictionary with SQL: Include Object OwnerA useful little utility is you need that type of thing.I'd suggest adding an owner to the results table to allow for different people owning the same table / view.Automate the ProcessYou could automate the process so it goes through the entire database - see below.(I've excluded the...; Tags: GO CREATE VIEW, kenneth.leake@..., Null, SELECT, SELECT Name, software, SQL; Discussion threads 2005-04-26
Insert using data from form transact sql: I am trying to write a simple query or so I thought that takes data from an Access form and inserts it into the database. as far as I can tell my syntax is right but it doen't seem to be aware of the form. The code is ALTER PROCEDURE...; Tags: Forms, Microsoft SQL Server Transact-SQL, noel@..., proceedure, programming, syntax; Q&A 2005-03-18
Using recursion in stored procedures: Conditional RecursionI wrote this function to help me on a query I was working on. It uses recursion in the case where you want the last day of a month.-- =============================================-- Create scalar function to convert dates-- based on user input. Useful to find-- first day of month, last day of month-- and...; Tags: DateAdd, DECLARE @dtNew DATETIME, MichelliL@..., recursion, routine, SELECT SENTINEL.DBO.udf_Dates, SENTINEL.DBO.udf_Dates, software; Discussion threads 2005-05-10
Alter every table in a SQL database: Count Records in Every TableI use a similar script to generate a script to count every record in each table. (I do database conversions, so it's rather nice to not have to open each table to see if it was used.)select 'select ''' + Name + ''' "Table", count(*)...; Tags: database, Name, permission, software, SQL, sql - other, stevep@...; Discussion threads 2005-10-11

<< Previous
page 1 of 1
Next >>

Lock Down the IT Department: Safeguarding your company's systems and information assets requires vigilance on many fronts, but it's difficult to stay on top of every vulnerability ...; Buy Now

Quick Guide: Windows Group Policy: One way for help desk technicians and network administrators to reduce help desk calls and protect their networks is to limit the damage curious users ...; Buy Now