Or some dynamic SQL

DECLARE @sql VARCHAR(MAX)

SELECT @sql = ISNULL(@sql,'') + 'SELECT ''' + name + ''',COUNT(*) FROM [' + SCHEMA_NAME(schema_id) + '].[' + name +'];' +...

amitchaudhury (8/25/2011)

---

I have a column called InsertedItemWhen on all tables that begin with CMS_

I want to go though all the tables that being with CMS_ and look for data...

Do you mean records inserted/updated after a specific date/time?

If so, unless you maintain a complete...

Try this:

http://ola.hallengren.com/Documentation.html

Huh!

Is the DOB column Date of birth?

or maybe this (I don't know what your tables look like!!!)

SELECT @actualPassword =convert(VARCHAR(10),DOB,101)

FROM [Annual_Edu_2006].[dbo].[HREMP_Adp]

Where fullName = @username

try this

SELECT @actualPassword =convert(VARCHAR(10),DOB,101)

FROM [Annual_Edu_2006].[dbo].[HREMP_Adp]

Where [LName]+', '+[FName] = @username

Are you really going to use this to authenticate users in a production system?

Ah! Good point

or

SELECT LEN(REVERSE('1 ')) 😛

SQL Server is a big product, with many features. You will need to be a bit more specific with your questions.

Try starting here http://msdn.microsoft.com/en-us/library/ms130214.aspx

This was ambiguous and misleading!!! :angry:

Geoff,

My bad. I hadn't noticed the use of system tables in your query (didn't scroll right far enough). 😀

I've got to ask, where are the values for the column and table name coming from?

If they are entered by a user then you have opened yourself up to an...

Even simpler with Auto-Implemented Properties in C# 3.0 and later you don't need the private variable.

See http://msdn.microsoft.com/en-us/library/bb384054.aspx