I have a simple stored procedure as follow. After I create the procedure. It
is successful.
then I execute
Exec pAddNewThemeScheme 4, 'Scheme3', 0, 'Scheme3'

Los Angeles Emergency Locksmith 1-877-364-5264 Affordable Locksmith
Services in Los Angeles,
24/7 Locksmiths 1-877-364-5264
San Fernando Valley Locksmith 1-818-386-1022

Hello;
I have created a SSIS solution that contains multiple packages, all of
which work in isolation.
What I'd like to know is how can I run all of these packages

I have a strange problem with the round function in T-SQL applied to float
numbers.
This is the code:
declare @x float

I have a series of records that relate to various people in another
table.  These records are a compilation of an individuals status over
time.  Whats the sql to obtain the most recent status given the
following criteria..

Suppose I have this:
CREATE TYPE mytable AS TABLE (field1 char(10), field2 char(10))
I can now do this:
DECLARE @mt mytable

I can connect to a locally installed MSSQL server by using
ACER-3B6299156D\SQLEXPRESS as the hostname, test as the username, and
user as the password, but I cannot connect to it remotely from another
computer.

Hello;
I need your help; I have a stored procedure A that needs to call 2 other
stored procedures that will then get inserted into a temp table.  Stored
procedure B returns 1 row with 2 columns (only need 1 column of data) and

Hi team,
  Could someone help me with this code? I need to use the output, but I
don't know how!
--

I am used to coding functions in CSharp and to deploying these
assemblies to SQL Server 2005 seamlessly in a Database project in
Visual Studio 2005.
This is something I use for functions that are very intensive (such as

    I have a 2 tables Table 1 and Table 2 Table 1 has the fields
t1.field1
t1.field2
t1.field3

If I have a SQL file I want to schedule.  Can this be schedules with task
scheduler?  If so, how do you specify the database and logon info.  If not,
what tool can I use to do this?  I am not sure if it is SQL 2000 or 2005...
Thanks,

Hi all... I'm back again. I finished part of my application and database
and now I'm with some problem, let's me explain and hope someone can
help me.
I have a table with the medical agenda, like this:

Why would someone want to use nvarchar instead of varchar for a table column
like customer name? Or visa versa?

I restored a BAK using the sql 2005 SSMS Restore wizard.  The BAK is a sql
2000 BAK on a sql 2000 Server - just using the tools for SSMS on my
workstation.  The Restore action using the wizard worked fine - except that I
was not able to see anywhere in the dialog window where I ...