Topics
Started by
Posts
Last post
I am trying to create a column in a temp table (stored procedure) with a counter based on certain v…
8 replies
Hi Folks, i use the table Person.address from adventureworks. i add a column "Datei" with the datat…
18 replies
hello , I am working on the Profiler and increase performance of the queries. "A QUER…
3 replies
I have a log table, that contains a Detail column which looks like this... auth=2 ms,xslt=110 ms,wa…
3 replies
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
Viewing 15 topics - 8,521 through 8,535 (of 12,234 total)
You must be logged in to create new topics.