Declare @var varchar(200)
SET @var = 'varchar1,varchar10,varchar15'
But i want like this @var = varchar,varchar,varchar
any one help on this

I want to explore the properties of an existing job by going to Management
Sutdo
->SQL Server Agent -> Jobs
Right click one of the jobs and select 'Properties'

Is there a way where I also can return the indexed word similar to the way
we can get the Key and Rank?
Thanks in advance
Christian

I have an auto generated excel file(.xlsx) in a particular format .
I tried importing the file to the SQL server database using the query
below.
SELECT * INTO temp_ExcelData2 FROM OPENROWSET('Microsoft.ACE.OLEDB.

What are people using to generate scripts to drop/add all FKs referencing a
table ?  Thanks.

In my calling stored procedure how do I access the recordset returned by
another stored procedure that I call? I know how to retrieve output
parameters but how do I retrieve a recordset? Does it make any difference if
I know only one record will be returned?

Anyone who has been following my tribulation with a particularly sticky
query might not be surprised to see this post.
I am now in the position where I want to update a live system by exchanging
one clustered index for another, on a table that gets several updates per

I would like to be able to run a query based on joining a temp table with  an
existing table
and export the result using dts.
I select the " use query to specify the data to transfer" and paste the sql in

We're pulling values from a the "inserted" table that is created in an
insert trigger. When we do an insert and view the execution plan in
Query Analyzer, the "Inserted Scan" accounts for 98% of the entire
query cost. How can this be optimized? There is very little

hey all,
i'm doing a copydatabase on my producation to create a test database. Once
this is done do I need to modify anything on the new test database to make
sure I'm not affecting the producation database in anyway?

I have a sql server table where a field (e.g.) field1 has length 9 and is of
datatype decimal with precision 18 and scale 8 (I am getting this value from
design view of sql server table).
Now I need to create a temporary table in sql server stored procedure. The

Am I correct in saying that SQL Server does not support an unsigned integer
variable?
If that is so, then I am curious why they would not.  I can see uses for it
and support exists for unsigned ints in the .NET environment.

I am in the process of building a stored procedure. Some of the datatype are
decimals which corresponds to table field types. I am using a temptable to
store intermediate values. When I am executing this stored procedure and
getting the output from the temp table the values are ...

I have a table with composite primary key.
I created a long stored procedure that batch insert
some records into the table based on some checking
condition.

In C#
[Flags]
private enum Action
{