Topics
Started by
Posts
Last post
I have a stored procedure thats passing right now 58 fields(subject to go higher, my boss automagic…
5 replies
Hi all, Am trying to write a query to return only columns that are populated. If I could do: selec…
15 replies
in SQL Server 2000 , I tried to compile a stored procedure which refers to a non existing table. e.…
1 replies
I am trying to Delete records from JDE on AS400 using Linked servers. I am using the following code…
8 replies
Hi all, I have one table with oper_year and oper_month , those two are int. Now i want to take the …
1 replies
Is there any way to have optional parameters in a SP that does an update. Lets say that I have 3 in…
3 replies
By: jrspano
I have a back job schduled for everyday,but its not working from 3/14/2003.How to enable the script…
6 replies
By: SQLBill
Microsoft books online tells that var char length can be upto 8000 characters. Does this mean that …
2 replies
Hi, I just want to know if I can run XP_CDMSHEL as a diferent user and how do I do it. Thanks in ad…
1 replies
I have a parent table (Site) and two child tables (Customer and Opportunity) that each have the col…
13 replies
How to create a dts package to import a file regularly into a table.suppose I have the table A and…
2 replies
How to know whether there is a lock on a table.
3 replies
Is there a script that generate 100% processor utilization (in single or multiple processors machin…
2 replies
I have two tables, one is a company information table the other is a NAICS/SIC code table. I'm try…
1 replies
By: jmadren
1. I need to build a delete statement, which doesn't run in a single transaction. E.g. statement: D…
1 replies
Viewing 15 topics - 15,511 through 15,525 (of 17,082 total)
You must be logged in to create new topics.