quote:

---

IF @columntype = 175 SET @defaulttype = '(' + SPACE(1) + ')'

---

How about this:

IF @columntype...

when designing your data base, you have to think about next year in addition to tomorrow. Consider how your well-known and small list of keys might change over time....

use the Information_Schema views

quote:

---

SELECT ISNULL

((SELECT COUNT(*)

FROM aaTABLE1 AS a2

...

There are several functions in the scripts area that do this.

This is an ideal situation where a user-defined function would suit your need.

Create one that accepts the int value and returns your 6-character string as output. I'd use the...

quote:

---

Hi Guys...

Problem.. have an online datawarehouse that lives on SQL, but gets data thrown into it from a UNIX production system....

I have observed that query manager behaves somewhat differently that one would expect. Try running your procedure as part of a SQL Server Agent job or calling it from...

Agreed that the trigger is not a good idea to use to write to the system files. What we did when we had a similar situation was this: ...

When we first had this problem we decided to store all system dates in GMT and convert them to the user's local time. As long as the servers are...

Only the system admin (SA) can use the BULK INSERT statement. Are you giving your VB app this access? I hope NOT!!

quote:

---

Hi,

I need quite the same ability to count the rows, but unfortunately, since my SQL is dynamically generated, can't rely on the...

select one.CrDate, two.crDate, datediff(s, one.crdate, two.crdate)

from table1 one

join table1 two

on two.crDate =

(

select min(crDate)

from table1 inside

where inside.crdate > one.crDate

)

here's a...

I'm not sure but I think er/win may do this.

quote:

---

How can you script a query to drop all tables in a Database that start with the letter "L"?

---

December 8, 2002 at 6:21 pm