Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- Avoid output message when using Trigger
- I created a trigger for delete on my table. When a user try to delete an item, several processes are lunched, and I don't want this processes to output. When the user try to delete a row, he got a result like (1 rows affected)(2 rows affected)(0 rows affected)Is it...
- Tags: Avoid DBCC, trigger avoid output, werewolf_@..., software, identity
- Discussion threads 2006-08-31
- About sql server 2k trigger/procedure
- When a table is modified, I want a trigger to export the data of table to a file,such as *.txt or other. I have tried to realize that by using following codes, but failed. create trigger tr_ActionLog on ActionLog for update,insert, delete AS SET NOCOUNT ON --declare @strSql varchar(255) exec dbo.ExportData2Csv 'liulzh',...
- Tags: Databases, @strSql, ActionLog
- Q&A 2005-06-01
- Build upon SQL's built-in statistical functions
- Median code not practicalThe code to compute the median is not very practical, as it employs a cross join. On one of my modest tables, the 60,000 rows will become 3.6 billion in the intermediate result set. I let it run for over 30 minutes before I terminated the query....
- Tags: alternate, INSERT, median, MikeSQLDBA, software, SQL, statistics, VALUES
- Discussion threads 2006-01-24
- Strategies for approaching null values with SQL Server
- By Kaye GartenData integrity is a critical aspect of any database system. No matter how well a system is planned, the issue of null data values is always present. Let's examine the three aspects of dealing with these values in SQL Server: counting, using null table values, and dealing with...
- Tags: Databases, strategy, server, Guest Contributor, Microsoft SQL Server, Col1, CREATE TABLE xCount, ISNULL
- Technical articles 2003-01-24
- 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
- Create customized XML streams with SQL 2000
- This article originally appeared as a Web Development Zone e-newsletter.By Phillip PerkinsYou might have an idea of the XML that you'dlike to use in your application, yet the ability to grab thatinformation from Microsoft SQL Server 2000 isn't available with asimple query. Let's say that you have...
- Tags: XML, SQL, SPAN dataFld, HTML TABLE
- Technical articles 2003-09-29
- Trigger output
- I'd like to use a trigger to identify the GUID that was assigned to a record just inserted. Here is the TRIGGER statement:CREATE TRIGGER trigBoardsGUID ON [EngineeringUser].[Boards] FOR INSERTASBEGIN SET NOCOUNT ON SELECT Board_GID AS '@@GUID' FROM insertedENDHow do I access '@@GUID' from my stored procedure that inserts into Boards?I was using an...
- Tags: database, GUID, GUID PK, identity, Identity PK, insert, Scope_Identity, software, sql server 2000, thomas.bihn@..., triggers
- Discussion threads 2006-01-10
- Finding dependencies in SQL Server 2005
- Any time you need to modify objects in your SQL Server 2005 database, the objects that are dependent upon those objects are a concern. You don't want to remove columns from tables, procedures, views, or tables if there are objects dependent upon them that are being used. ...
- Tags: Procedure, Microsoft SQL Server, Microsoft SQL Server 2005, Object, SalesHistory, SalePrice, Tim, Databases, Storage, Enterprise Software, Software, Data Management, Hardware, Tim Chapman
- Blog posts 2008-02-04
- 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
- Comparing SQL Server constraints and DML triggers
- Over the years, I have witnessed many developers be confused about when to use data-manipulation language DML triggers vs. when to use constraints. I have seen numerous occasions where both objects have been used incorrectly, which has led to problems. This article sheds some light on when to use constraints...
- Tags: Sql Developer, Sql
- Blog posts 2007-06-04
- See SQL Server graphical execution plans in action
- Execution plans are one of the best tools to use to tune your SQL Server queries. In this article, I identify a few basic things to look for in a graphical execution plan to help you better understand how SQL Server uses indexes. I also offer ideas about how to...
- Tags: Query, Microsoft SQL Server, Data, Server, Column, Index, Speed, Table, Execution Plan, SalesHistory, SaleID, SaleDate, PoolTable, Product, Bookmark Lookup, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2007-10-01
- Download: Save time using batch files to perform repetitive tasks
- Download: Save time using batch files to perform repetitive taskshttp://techrepublic.com.com/5138-10586-729266.htmlWhile batch files are still a viable tool for performing simple day-to-day tasks in a Windows operating system environment, much of their functionality has been supplanted by other scripting languages.[b]Which do you use more in your day-to-day tasks: batch files or...
- Tags: backup, C100, Fs1\SYS\Apache\nwdocs\web\login.html, Mark W. Kaelin, networking, \\Fs1\SYS\Apache\nwdocs\web\login.html
- Discussion threads 2005-04-11
- << Previous
- page 1 of 1
- Next >>
