Topics
Started by
Posts
Last post
hi guys a question, i have a after insert trigger that does an update in another table, this trigge…
21 replies
I'm trying to do some cleanup in our Uptime database and I need a little help with the delete synta…
12 replies
ALTER TRIGGER [trg_Transport] ON [dbo].[Transport] FOR UPDATE AS SET NOCOUNT ON DECLARE @UpdatedRo…
3 replies
Hi all, My understanding is that EXISTS and IN are semantically equivalent, but I'm getting differe…
4 replies
TBL: ADC Column NameData type ID1Int, NOT Null ID2Int, NOT Null Beg_dtDate End_dtDate Using t…
2 replies
I'm sure there are many ways to skin a cat and probably many ways to do what I'm trying to do here:…
40 replies
Hi, Is it possible to parametrize a remote procedure through a linked server or a query through a l…
3 replies
Dynamic query error hi, my query is below: declare @myfield varchar(20) declare @mysql nvarchar(1…
4 replies
Hi all, I am trying to convert some Ansi sql code to new version of sql for compliance with SQL Se…
4 replies
I would like to run a T SQL script that looks at the data within a table and specific column and g…
6 replies
-- CREATE TEMP TABLE CREATE TABLE T ( Id INT NOT NULL, IsEnabled bit not null, NAME VARCHAR(500)…
1 replies
Hi, I have the below table structure: RowNumber UserId UserNmae Date 1 …
7 replies
Hi, I am trying to build the following query: declare @s-2 nvarchar(500) declare @Dbname nvarchar(…
1 replies
From T-SQL, I can use xp_FixedDrives to get all drives and MB free on each. But how can I get the t…
5 replies
Hi to all, I need a function that run a simple sp, but i need to insert into a table the result... …
8 replies
Viewing 15 topics - 8,521 through 8,535 (of 12,230 total)
You must be logged in to create new topics.