Using MS SQL Server

GROUP BY a computed column
If I want to count the number of records in a table GROUPed BY the first word in a string column, must I first compute the first word and store in a temporary table and then do my GROUP BY select? ... 2 Jul 2008 12:55

Can I search for a string in a set of stored procedures?
I found that I'm making an error in my 'case' statements, and now I want to go through a database full of many stored procedures to find that error in some of them and to fix it. Is there any way to do a search through multiple stored procedures at once? I don't see one in my version of Sql Server Management Stud... 27 Jun 2008 10:05

Concatenate in MSSQL
Hello. I 'm working on a project which has developed a huge program. Some customers use DB2 as database, and others oracle. So far so good and everything works ok. Now there's a demand on using SQL server. We have found two major problems. 1) Trim() There's no trim in MSSQL. Even if we create a trim() func... 26 Jun 2008 10:29

Storing BLOBs outside database
I remember readng that BLOBs can be stored externally (with reference to the BLOB file stored in tables instead). Does anyone have any experience doing this ? I have a few questions: 1).what are the things to watch out for (apart from obvious ones like 'file not found' type errors). 2). How may a stored proc... 26 Jun 2008 18:45

Creating a database from set of TSQLl files
I have written a set of sql files that make my entire database schema. I have divided the schema into seperate files mostly for "manageability" (for example, I can check error codes as I go along, and terminate the process as soon as an error occurs). I have several tsql files in a directory, and I want to b... 26 Jun 2008 09:27

Grouping by Day for a Date Range
Hi, I thought this would be easier but after looking all over the web I had to post this question. We have a workflow table that tracks when an item goes in an out of a workflow state. I would like to pull a week's worth of data and group it by day. My query to do this is: DECLARE @TODAY DATETIME; DECLAR... 25 Jun 2008 19:08

table naming convention about this case..
Hi! I've read some article about naming convention and they all say don't use number in the table name. But I have a case that I can't figure out how to deal with it in a proper name. I have to import 2 flat files from FTP for OLAP use. Both of these files contain similiar information,Customer data. layout in ... 26 Jun 2008 15:39

Question about recompiling a dll
Hi all, I'm reading this article on Microsoft's website: http://support.microsoft.com/kb/932872/ , and they state that the solution is to recompile the "COM dll"... how do I do this? Is there a makefile or something I need? Thanks ... 26 Jun 2008 00:15

Duplicate Tests - Help Please
Using SQL 2000 - Columns are AssociateID, Associate, [DateTime], [Assessment Test], Score Application provides the students to take assessment tests. They are instructed to only take a specific assessment test once and receive a score. Unfortunately the application will let the student take the same assessment t... 25 Jun 2008 11:54

Database security (non-existent?)
I recently downloaded and install SQLServer Express. I am considering using it as the backend db for my app (i.e. moving from the current PostgreSQL). I run sqlcmd without specifying any username or pwd, and I was suprised that I had access to the 'server', and could create and drop databses (admittedly I dr... 2 Jul 2008 11:53