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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: tomjscribe
- Order by date
-
Hi, All, Anybody know how to get
the DATEADD function will work select DATEADD(yy,1,"07/02/01") returns --------------------------- 2002-07-02 00:00:00.000 (1 row(s) affect- tomjscribe
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Trigger - How to tell operation type
Writing a generic trigger for all operations (Update, Insert, Delete). How can I tell what type of operation against the table has occurred. I want one, generic I/U/D trigger that needs slightly different behavior for each operation. Basically, I am writing an 'audit trail' trigger and need to...- tomjscribe
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Hi, SQL 6.5 Database Trf from on
The best way to move database from one SQL server to another is as follows: 1 - Do a SQL Server backup/dump of the database. This will create a .bak file. 2 - On the other machine/SQL Server create a new database the same size and structure as the original 3 - Copy the .bak file from the 1st...- tomjscribe
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Trigger - How to get tablename
I want to create a generic trigger that KNOWS what table it is built against. I took a guess the @@tablename might be a system variable and hoped the following code would work: declare @tblname as char(50) select @tblname = @@tablename It did not. ANY CLUES. Again I want to write a generic...- tomjscribe
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
