Topics
Started by
Posts
Last post
I am sure this has been talked about before but I couldn't find it in a search. I have a stored pro…
6 replies
I'm working on UPDATE TRIGGER It's getting more than 200 lines. It has 4 IF UPDATE() checks and eac…
1 replies
Using SQL Server 2000, the documentation says (that's for the XOR but same goes for the AND, OR and…
2 replies
We have a set of Property Loans: LoanNumber #1: personal lender1 details LoanNumber #2: personal le…
1 replies
Below is my select statement...what I'd like to do is to add a column to the select statement, that…
2 replies
create procedure sample_proc(@session_id int) as begin declare @sql_stmt varchar(4000) set @sql_st…
1 replies
Hello, I have a Stored Procedure set up to take a single parameter which represents a numeric ident…
2 replies
Guys, I have a database with tables that have identity columns in the tables. I created a new datab…
3 replies
I have a problem with a join of 3 tables. The tables are described below Master (table name) alias …
4 replies
Is the a way to do a search and replace for all or a group of stored procedures? I.E. I need to cha…
2 replies
If you have a SELECT stmt with a DISTINCT keyword, are the combination of all columns referenced di…
2 replies
I have 1200 databases. How could i use t-sql "alter table ...." to dynamically deal with a pk int f…
2 replies
The first UPDATE statement in the trigger below works, but not the second. I verified there is dat…
9 replies
Hi All, I found an article on the extended stored proc xp_file. Downloaded the project files and tr…
4 replies
hello, i would like to update a column called footer in a table called agency. i have to update abo…
1 replies
Viewing 15 topics - 14,536 through 14,550 (of 17,082 total)
You must be logged in to create new topics.