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 bkrike 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 TheFrog
-
Insert TableA into TableB
use before your insert the expression in SQL Server to permit insert in autonumber field SET IDENTITY_INSERT tableA ON INSERT INTO TableA( a, b, c, d, e ) SELECT A, B, C, D, E FROM TableB; SET IDENTITY_INSERT tableA ON- TheFrog
- Post #7
- Forum: Microsoft SQL Server: Programming
-
dsn-less connection to SQL Server
really the inconsistency occurr. the trust connection is default for some windows. Configure your sql server security SQl server and Windows, and change the password of the your users in SQL Server. The passwords will have different between Windows and SQL server.- TheFrog
- Post #9
- Forum: Microsoft SQL Server: Programming
-
Access Date() function syntax for SQL Server?
griks, your problem is simple. the problem is typical.Not in your syntax or sql but in your references in VBA. Please verify your references library when worked in Access 2000.- TheFrog
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Stored Procedure: Sort by Variable Column
that's simple solution see... CREATE PROCEDURE sorter_variable (@col varchar(255)) AS declare @sql varchar(255) select @sql = 'select * from cpu_insumo where projeto= 23 order by ' + @coluna exec(@sql) GO ok?- TheFrog
- Post #8
- Forum: Microsoft SQL Server: Programming
