Yes you can:

--Create table parameter type

CREATE TYPE dbo.TableParamTest AS TABLE

(i INT, string VARCHAR(255));

--Create stored procedure

CREATE PROCEDURE dbo.test

(

@tableparam TableParamTest READONLY ,

...

You've probably already checked this, but I've had problems in the past (in Windows) where the DSN's default database was different than the one I was trying to access, and...

You can use the ISNULL() function:

SELECT ISNULL(fieldthatmaybenull, 'Other value')

FROM ...

I've always been successful by scripting the job to a new Query Editor Window, then changing the connection on that window to the destination server.

Can you post the entire SQL statement where the dynamic string is built?

I disagree that fragmentation would not be removed. As long as the table is big, the fragmentation will be reduced. I have a bunch of crappy third party...

batgirl (5/16/2014)

---

As is often the case, I am now thoroughly confused.

I am pretty sure that I need a vacation, or at least a long weekend.

I assumed that "NOT"...

Why not upgrade to SSMS 2012? It's free!

http://www.microsoft.com/en-us/download/details.aspx?id=35579

I earned a degree in math and very slowly grew my career into being the DBA I am today. I started out programming Excel using VBA, then moved into...

Good question, I hadn't heard of WITH TIES before. Thanks!

Man, I felt so good that I knew that quote was from "Speed"!

Oh, but I also picked bit and thus got the question wrong.

I'm sure I'm in the minority with my perspective. I love SQL Server - learning how it works, why it does what it does, how to make it hum,...

My biggest worry about using the cloud is 5 - 10 years down the road, when 75% of SQL Servers are in Azure, MS can start jacking up the price....

I think I understand what you mean. I was thinking of the problems more as those chess puzzles where you see the board in a certain position and it's...

I agree heartily with this editorial. I have been a DBA for 1.5 years, and would love a way to test my knowledge and see where I need improvement....