sp_help wlll tell you all referenced as well as referencing keys. You want to look at the last two result sets:

USE AdventureWorks

GO

EXEC sys.sp_help @objname = 'HumanResources.EmployeeDepartmentHistory'

If you are interested you...

harmand (2/25/2011)

---

THANK YOU

Another problem. I have catalog table with a description field. If the description has a comma in it the field in the flat file is in double...

Lowell's example uses xp_cmdshell to find a list of files to BULK INSERT from specific directories. If the files you'll be BULK INSERTing will never change, or can be sent...

As with most things it will depend on a lot of factors...more than we can discuss in this forum. However as an initial direction for supporting reporting functions denormalizing the...

BOL: http://msdn.microsoft.com/en-us/library/ms190998.aspx

You'll need to supply a format file. This post may help:

http://www.sqlservercentral.com/Forums/FindPost99982.aspx

Possible...

I would designate the values you have for Products (Shirt), Colors (Green, Blue, etc.) and Sizes (S, M, L, etc.) as "natural keys". Surrogate keys (IDENTITY) are my preferred way...

namrata.dhanawade-1143388 (2/23/2011)

---

Requirement:

There are 100 tables each with different number and type of columns and obviously different rows.

And then there is a condition to check if some 5 columns...

Your OP says you're trying to alter columns from INT to BIGINT but your script is altering columns to VARBINARY(MAX). What exactly are you trying to do?

In any case you'll...

Here is why using the sp_ prefix for your proc names is a bad idea:

http://blogs.msdn.com/b/jenss/archive/2009/04/28/a-long-but-not-missed-friend-revisited-prefixing-stored-procedures-with-sp.aspx

Please post the DDL for your table and the DML for your data.

Please post what you have so far.

Sounds like a proprietary SEQUENCE to me. Can you refactor?

Your proprietary sequence (you called it ID) had to start somewhere so you must have a seed. Since all proprietary "ID"s...

In short, yes.

Try this:

SELECT CONVERT(DATETIME,'15 Feb 2011 12 am',121) as my_date ;