Topics
Started by
Posts
Last post
What's the best wat to do this? I need to audit changes to tables. I'm thinking trigger but I'm not…
1 replies
I have input parameter store procedure. Depending on the parameter passed in,…
3 replies
Hi. I'm trying to write a script that will create a user in each database on a SQL server and then…
3 replies
Hi all, I think my brain has gone into meltdown as I cannot for the life of me see why I cannot get…
3 replies
Hey guys...I guess I suck at building tables. Anyway, I have this webform that consists of 7 parts…
9 replies
Hi All, I am writing a stored procedure in which I need to read some records from a tabl…
6 replies
Hi Folks, I need some opinions on something. I have a web form that spans across 5-pages.&nb…
167 replies
Hi Guys, Consider following details, Suppose, Database - Test, Users - 100 and I have defi…
5 replies
This code works fine: --CREATE PROCEDURE #t as create trigger [Anamoly Descriptions_boolean] on [An…
16 replies
I'm trying to make a dynamic SQL string that is roughly 450 characters long (insert / select piece)…
4 replies
I tried performing datediff on two strings converted into datetimes and found that it simply subtra…
5 replies
Hi, I am trying to pass a table to a stored proc and can't get it to work. Basically I want s…
5 replies
Hi, Does anyone know how to make a column an IDENTITY using T-SQL I tried the following but it give…
2 replies
For starters, no need to reply that use of xp_cmdshell is dangerous. The following is merely …
5 replies
SELECT * into #v_saleproperty FROM OPENQUERY(Server1, 'Select city, MLS_nbr from California.db…
14 replies
Viewing 15 topics - 9,496 through 9,510 (of 17,082 total)
You must be logged in to create new topics.