here's soemthing i put together previously:

this searches an entire database , that is all tables, so you might want to add AND TABLENAME ='YourTable' to limit it's use.

CREATE PROCEDURE...

your temp table could be materialized as a CTE, and used for further processing...that is allowed in a function.

show us your function, and we can probably help.

newbieuser (12/13/2011)

---

Oh no.. Is there a way to find the non character columns that are in lower case? I should may be run the sql for non character fields first...

only nvarchar/nchar/char/varchar columns with default or check constraints will fail(and this need to be dropped and recreated)...so if you had a check constraint for 'Y' or 'N', or a Default...

what about Proper Cased column names? not just all lower case;

this will find anything not upepr cased, buy using collation:

SELECT 'EXEC sp_rename '''

...

isn't the "table" data stored wherever the HEAP or CLUSTERED idnex type is stored?

so you can infer that wherever the i.type_desc in(HEAP,CLUSTERED), that's where the table is.

i added one column...

each exit is going to need a commit:

IF @condition =1

BEGIN

--do stuff (like you said...either raise an error or commit.

COMMIT TRAN...

Another option is to change one of the keyboard shortcuts to sp_helptext in SSMS; that's free, which is closer to my usual budget.

for example, in the screenshot below, i'm calling...

in SQL, that's the IDENTITY() property;

you can script it like this:

CREATE TABLE MYTABLE(

ID int IDENTITY(1,1) NOT NULL PRIMARY KEY,

OtherCollumns varchar(30 )

if you have SSMS for SQL Express, you can design...

a visualization and explanation form a forum post on the same subject:

Al the SQL Browser Service is what makes a SQL instance "visible", but that is not required. i don't think it's included in express versions, anyway.

It sounds like you already...

we have an app here which supports either Oracle and SQL Server as the behind the scenes DBMS.

I'll be the first to say I do not know how to tune...

Dev and John i thought we might be overthinking the complexity of the original post, and wanted to throw the view possibility out there as well;

It seemed to me he...

i'd recommend forgetting about putting the count in the table.

instead, create a view that is uesed to calculate the count based on a join; then the count is correct every...

dogramone (12/11/2011)

---

Your poblem is probably related to the "select *" stuff. When SQL creates the view with select * it creates the view in the underlying DB engine as...