Topics
Started by
Posts
Last post
Has anyone ever seen this error message when trying to create a database? Server: Msg 1807, Level 1…
8 replies
What query can I do to replace null values in columns in a table? For example, if I have a table c…
2 replies
We run sp to insert data into the table. The query contains couple of joins ant outer joins. When …
3 replies
Hi all, My SQL2K has over 100 tables and some triggers for tracking who deletes records. I intend t…
16 replies
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
Is there a way to find out when an index was created for a table? I looked at the sysindex table a…
1 replies
Every so often, I see Datetime data type columns being used as part of a clustered Primary Key. Wh…
3 replies
HI. I understand sql profiler is not only a tool for dba's but also programmers/developers to use. …
5 replies
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
Viewing 15 topics - 6,241 through 6,255 (of 7,464 total)
You must be logged in to create new topics.