GilaMonster (10/9/2015)

---

Not a template, but...

Open Object explorer, navigate to a table/view, Drag the 'columns' folder to your query window.

SQLPrompt does all the column generation for inserts and selects. It's not...

You're welcome!

Dana

Jeff Moden (5/26/2014)

---

danaanderson (5/25/2014)

---

Jeff Moden (5/25/2014)

---

danaanderson (5/25/2014)

---

I don't think that it matters about the position in the parameter of the dbtype spec, but I'll check it out. It is...

Matt Miller (#4) (5/25/2014)

---

Have you tried look at the profiler session of the parameters being passed in? Also - have you made sure that there is in fact only...

Jeff Moden (5/25/2014)

---

danaanderson (5/25/2014)

---

I don't think that it matters about the position in the parameter of the dbtype spec, but I'll check it out. It is ASP.NET. Classic...

J Livingston SQL (5/25/2014)

---

not sure what you...

I just swapped those two dbType attributes to the end like all the other type attributes in the parameters and it didn't make a difference.

Dana

I don't think that it matters about the position in the parameter of the dbtype spec, but I'll check it out. It is ASP.NET. Classic ASP is quite...

Carolyn S. White (1/21/2014)

---

I did that and got the same error.

I retyped everything and still got the same error.

This is what I typed in:

SCHEMA_NAME(o.schema_id) + ',' + OBJECT_NAME(p.object_id) AS name,

...

Carolyn S. White (1/20/2014)

---

Please excuse my ignorance.

I need to change this how?

I get the error

Incorrect syntax near 'o'.

I tried changing SCHEMA_NAME to the name of the schema for the...

Louis&Sql (1/18/2014)

---

danaanderson (1/18/2014)

---

The total space used in version 2 doesn't match any of the space used values in version 1. The values in version 1 seem to be considerably...

The total space used in version 2 doesn't match any of the space used values in version 1. The values in version 1 seem to be considerably higher in...

homebrew01 (6/3/2013)

---

I would think they will have the same problem distinguishing names with the current setup. If the asterisk is a delimiter of some kind, then it could be useful...

kiran.vaichalkar (6/1/2013)

---

Hi Folks,

Please help me on below few queries

My table is

Users(ID IDENTITY(1,1) PRIMARY KEY, NAME nvarchar(10), MANGER_ID fk_User_id References ID)

1) now im trying SET IDENTITY_INSERT USERS.ID OFF

But...

Unfortunately, this...