l I dont think my inner dynamic sql is executing, at least it doesnt look
like it in profiler. anyone got any suggestions? And please refrain from
providing the default how dynamic sql is bad, just need help. Thank you.
use AELN

Is there an easy way to get a column listing of a temporary table you create
dynamic?

I have two tables, one containing items whith thier common properties
and second with properties, which contains extensive list of
properties. The tables are linkex with 3rd table which maps different
properties to different items.

i just want take the order to create tables (PK and FK relationships)
i need both ways sql and SMO can any one help me

Why is it that some errors immediately throw an unhandled exception and
others do not ?
For example, when attempting a DELETE an unhandled FK violation will
immediately throw an exception and exit the sproc ... ( it is not possible

hey all,
i'm getting ready to import all my tables from test to prod.
the first part of my script is to clear that target tables of all the test
records by using truncate. is there a way to truncate all the tables at once

I am a little novice at running queries, so please be patient with me.
Windows Server 2000
SQL Server 2005
I am trying this is a test database first.

So I have an order entry system and I need to show a report of the number of
orders per day. People want it to show even when there is no orders for that
date. So the only way I can think of doing it is create a temp table that
contains all of the dates in my range, and then join ...

In SMO StoredProcedureCollection has both system and user defined stored
procedures , i just want filter the user defined stored procedures ( also
tables , views)
adv thanks

I have two tables with the same structure
T1: ID, Accessories
T2: ID, Accessories
The goal is...

I'm finding the tabs in Management Studio really sucky. I find the tabs in
Visual Studio much easier to use. Does anyone find the same thing?
Cheers,
Michael

which way will give me better performance?
select * from table1
OR
select id, name, email from table1

I'm having trouble writing a query for this.
Supposed I have 2 tables
table: Student
stdID    first name    last name

I hope the post title makes sense.  What I want is a table like this:
ID         Pos
------     --------
1         1

Can someone explain the actual storage of varchar vs. nvarchar in SQL Server
2005? I understand that a varchar is a single-byte character and nvarchar is
a double-byte character, but does SQL Server ultimately store them both as
UCS-2? In other words, what format is the ...