I have a table requirements it contains the following data table structure
and sample data;
id, year, term, program, division, location, sequence, requirement_code,
requiremtent_type, test_code, test_element,requirement_description,

Is there a way in SQL Server T-SQL to store commonly used SQL
statements in a function, stored proc, or system variable?  That way
if that code ever changes I can change it in one place.
If I use the code below in 100 different SQL statements... can I

A couple of more questions for the group! What do the
following command(s) do? Is this one command or several different
ones? And can I execute this in the same manner as the previous
command (OSQL)?

Hello I get this error message and I don't know what to do or go to fix this
I am a new user to sql server 2005 can someone help. I am trying to connect
via ODBC Microsoft to AS/400.   Message says:
Executed SQL Statement:  SELECT OVDA, OVBC, ODGY  FROM

From a security point of view, is accepting wildcards like "%" in
input parameters of stored procedures against any best practices?
As an example, if a user defined function uses "Productname LIKE
@ProductName" in WHERE clause of a select statement, and a stored

I have this data:
id             GroupId             DDate                   Value
1                        1            7/31/2008                     5
2                        1            7/31/2008                     6

What is the most robust method of executing a stored procedure via a
batch file on a remote machine?
PSEXEC?
I am trying to run a restore that will execute from a SPS web server

i have a problem using aliased column. I have the following query:
       With masids AS
       ( select         masID,
       dbo.concat_friendly(masIDFrom) as 'From'

Hi: I have a table that I want to return the max, min, median and mean
values from. I have the first three returned in a single query (select
Max(val) As myMax, etc.), and I have the mean returned in a separate query:
with positions

SQL Server 2005 SP2 (9.0.3068) installed on Windows Server 2008 Enterprise.
When I installed SQL Server I specified a "named instance" with the name
TEAMFOUNDATION.
This appears to be working OK; I have Team Foundation Server and SharePoint

I have a table column that has data as shown below
item A STD
item B STD 1
item C 1 FP

I have setupa job to run an ActiveX script. I have setup the activex proxy
and set the job to use the proxy.
The job fails with the following message:
Error Code: 0  Error Source= Microsoft VBScript runtime error  Error

Is there an option or script that will automatically/easily index all/most
columns of a table or better still all tables in a database?
Thanks
Regards

I have an SQL Server 2005 database that is populated with a customer's data.
I want to create a new database, in exactly the same format, so that I can
set up a system for a potential new customer to start converting his data.
Initially I want to create a 'blank' database, so I ...

I have a problem to find a function name: mod (returns the remainder portion
of  i mod p) at SQL server and it is exit at vusual studio.
Example : 5 / 2 = 1 is my remainder portion.
Thank You