Jeff Moden (6/11/2015)

---

srgaddam2 (6/10/2015)

---

Jeff,

I am new to SQL server, so I would appreciate if you could help me understand the SQL hacking concept. What is the purpose of quotename?...

Can't even post your code in a reply, that sucks.

Any way, I would still prefer to use EXEC sys.sp_executesql and pass the variable data using the proper data types...

Jacob Wilkins (6/10/2015)

---

It just has the QUOTENAME and ISNULL mixed up for the database name. Flip them and it will work. As is it's trying to pass DB_NAME() as the...

Attached is another way to accomplish the task. It also includes the code for the dbo.DelimitedSplit8K function.

Sorry, work isn't allowing me to post the code directly.

Try testing your code passing in a value like '[DBName].[SchemaName].[TableName]'. When I use your co0de with something like that the database name is dropped.

ScottPletcher (6/10/2015)

---

Sorry, I was being lazy and didn't include checks for db name and schema:

ALTER PROCEDURE sampleprocedure

@tablename AS varchar(4000),

@date AS date

AS

SET NOCOUNT...

srgaddam2 (6/10/2015)

---

Thank you for the quick reply.

I implemented the logic, but some how when I passed the table name it says invalid object name. The way I created is I...

A different way. Modify the SET and EXEC lines of Scott's code above as follows:

SET @query = 'SELECT * FROM ' + QUOTENAME(@tablename) +

'...

phillyflats (6/10/2015)

---

The table has a primary key of SalesID.

The table also has a NONCLUSTERED index on SalesID.

The table has a CLUSTERED index on SalesPersonID.

Before attempting the insert, the clustered index...

Well, that explains why I got the question correct, I read it after it was fixed.

jodevil99 (6/10/2015)

---

Hi, I am really not sure where I had to post this so I'm sorry if this isn't the right place

So I'm creating a query to extract data, and...

luis_carlosh (6/9/2015)

---

Steps I done:

OLD SQL 2008> task > backup DB

NEW SQL 2014 task > Restore DB

1) SET COMPATIBILITY_LEVEL = 120

...

Alvin Ramard (6/9/2015)

---

ricardo_chicas (6/9/2015)

---

Hello All

I have a 50gb database, with 3 files at the primary filegroup, each one of those has around 16gb

I truncated 2 tables releasing 33gb, so the...

Would be nice if Microsoft brought partitioning to all editions of SQL Server, well, maybe not Express but it wouldn't hurt for people experimenting.

It would also help if you posted the actual execution plans for the query from both systems.