Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by wildsol
-
Insert TableA into TableB
Make sure that when you are inserting into table A that you are not including the autonumber field for the table in the insert statement. from what you originally posted: INSERT INTO TableA( a, b, c, d, e ) SELECT A, B, C, D, E FROM TableB If field x was the autonumberfield for table A, you...- wildsol
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Proper case
You have to make sure you add the user prefix when calling the function (e.g., dbo.propercase(lastname) )- wildsol
- Post #7
- Forum: Microsoft SQL Server: Programming
