Topics
Started by
Posts
Last post
I gathered some code from David Jackson's site and made a Stored Procedure out of it. This code ret…
6 replies
WITH DirAgent(AccountID, Number_of_Accesses) AS ( select AccountID,count(*) from account_log_BAK …
4 replies
Hello! I'm a T-SQL stored procedure novice and I got all proud of myself when I wrote this script u…
10 replies
Hi What im trying to do is build a menu in asp.net/SQL 2005 backend all examples are that the paren…
3 replies
I have a SQL script that runs statements that is enclosed by TRY-CATCH construct, it is part of SQL…
1 replies
Hi All I hope you can help me with the following query. It’s quite complex query and I’m sure that …
9 replies
Hi, i want to deny structural changes on a database. DML must be allowed, DDL not. I do this, like …
1 replies
hi, i want to monitor list of queries fired on any table ...a kind og log i know this could be don…
6 replies
How to create one application to execute a SSIS package ?
1 replies
I have a table called config_itemi. It has a single indentity column (pk_auto_id). I have a user …
4 replies
I am having what appears to be a replication problem. What I am currently doing is checking for ch…
1 replies
I'm trying to create a function but getting an error message about the use of EXEC within a functio…
2 replies
HI All, I'm getting an unexpected result, and I'm sure it's a SET OPTION somewhere but I'm not sure…
5 replies
DECLARE @X XML SET @X = (SELECT XML FROM @tempLogical) INSERT INTO @tempPhysical ([MovementIdenti…
5 replies
I have a query that looks for the MAX(bigintcolumn) to find a particular record in the database. I …
23 replies
Viewing 15 topics - 8,956 through 8,970 (of 12,230 total)
You must be logged in to create new topics.