This line is in your script:

SET @cmd = 'ALTER INDEX ['+@IndexName+'] ON [dbo].'+@TableName+'] REBUILD

Fill that with life:

DECLARE @cmd varchar(200), @indexname varchar(200), @tablename varchar(200)

SELECT @indexname = '', @tablename = ''

SET @cmd...

Oops, apparently you would want to repleace #t with a permanent table in the AdventureWorks database. 🙂

Maybe something like this will work:

CREATE TABLE #t (c1 int);

DECLARE @i int;

SET @i = 1;

WHILE @i <= 10 --adjust this

BEGIN

INSERT INTO #t SELECT @i;

UPDATE #t SET c1 = @i;

DELETE #t...

Then why not run INSERT and DELETE statement in a loop?

A good way to check the correctness of a SQL string before executing it, is top PRINT it. You will notice that you are missing an opening bracket before @TableName

SET...

Too lazy to Google? 😉

http://en.wikipedia.org/wiki/Database_management_system

SELECT DATEADD (DAY, DATEDIFF (DAY, 0, '2009-05-28 11:18:49.123'), 0)

Sorry, if I was a bit lazy in my reply 🙂

I still keep forgetting about it, but another alternative in SQL Server 2005 might look something like this:

DECLARE @Output TABLE...

Have a look at the EXISTS () clause in Books Online. You can test if at least 1 row matches the criteria and if so do the UPDATE along with...

GilaMonster (5/26/2009)

---

Is it first normal form?

The requirement for being first normal forum is that there are no repeating groups. If we take the addresses as repeating groups, then this isn't...

It is First Normal Form and normally you would want to have your model in Third Normal Form or even higher.

If you need some good arguments for the design discussion...

Can you please post your actual code?

The only thing I can think of right now is that the "Script for server version" option is "SQL Server 2000". In that case the INCLUDE clause is ignored

A way to mimic this Access behaviour would be to right-click on the stored procedure in SSMS -> Execute -> and then supply the values in the window that opens...

nazaninahmady_sh (12/31/2008)

---

i want it asks me about the value of those 3 variables, and when i wrote them , the select can Do,

for example iwant to write "exec Garhasbi...