Topics
Started by
Posts
Last post
Hello, we had a HP3000 server with a (I think) hierarchical database migrated to a SQL Server 2000 …
2 replies
I have a simple table named Manu with columns: ManuID and ManuName. ManuID is auto incrementing st…
3 replies
How do I search for a pattern in a text column. E.g. Col Data : "Some text to search for including …
1 replies
I am working a hospital patient event data set. Currently my extract list all patient activity with…
12 replies
I have a query that I use for searching that contains a FREETEXTTABLE statement. I now need another…
2 replies
I have a stored procedure that: Sets a bunch of local variables Truncates a table In…
12 replies
Hi guys, I recently picked up a new project on one of old SQL 2000 servers that is proving to be q…
2 replies
Hi guys, A small query...I am trying to get the Time part only from a DateTime column, I am using i…
6 replies
Has anyone written tsql code to check if an index exists for a table and if so drop the index . Som…
11 replies
Hi, I am scripting some stored procedures to be deployed to our test and later live environments, a…
1 replies
ok, for some reason I have never been asked this in my 5 years working on SQL server (2000). I need…
18 replies
how to convert seconds to HH:MM:SS format?
3 replies
Greetings all. I am working with an extremely poorly written view, and I know that because I wrote…
10 replies
Hi, I am developing a Material management system where I have an Amendment table. It contains the a…
3 replies
Base Table contains 100K rows. Table name - Base Columns -AppliedDate -RecievedDate -ApprovedDate -…
1 replies
Viewing 15 topics - 1,966 through 1,980 (of 17,082 total)
You must be logged in to create new topics.