Topics
Started by
Posts
Last post
We run sp to insert data into the table. The query contains couple of joins ant outer joins. When …
3 replies
By: liyaka
Hi all, My SQL2K has over 100 tables and some triggers for tracking who deletes records. I intend t…
16 replies
By: scraft
Hi, I am a new bee for store procedure. Can someone tell me how to find the last day for a date fie…
8 replies
By: ytao
Is there a way to find out when an index was created for a table? I looked at the sysindex table a…
1 replies
By: winash
Every so often, I see Datetime data type columns being used as part of a clustered Primary Key. Wh…
3 replies
By: PBirch
HI. I understand sql profiler is not only a tool for dba's but also programmers/developers to use. …
5 replies
By: Juanita
In SQL SVR 7 is there a way to determine which rows are being exclusivley locked? We have a problem…
1 replies
Sorry for the basic question but I was wondering if you could run IIS and MS SQL server on the same…
7 replies
I have a unique situation that perhaps some of you can help me out with. I work at a riverboat casi…
2 replies
Hi all Try this: create table aaaaa (aid int, adesc char(100) ) create table bbbbb (bid int, bid_ai…
4 replies
I want to return a specified column row with the adjacent number of rows above and below. e.g. Sele…
8 replies
When I import XL files, varchar columns that have text values with more than a couple hundred chara…
1 replies
Hello Gurus! Have a look at this query in Query Analyzer (provided you have the Northwind DB instal…
2 replies
I have IIS and SQL on separate boxes. Using profiler I catch this line very often: quote: declare…
1 replies
Hi I want to have a query in a stored procedure which will check a table if it has the columns ,col…
1 replies
Viewing 15 topics - 6,241 through 6,255 (of 7,462 total)
You must be logged in to create new topics.