Converting data field into hours, minutes, seconds.
How do I convert a field in SQL 2005 from seconds to hours, minutes, and seconds?
View Answer
| Jul 10 2008 4:18 PM GMT
| asked by
Tonya
T/SQL, SQL Server 2005
T-SQL how to identfiy tables that have dulicate roaws
I have a MS 2000 SQL server.How can I search the db and indentify the tables that have duplicate raws.Thanks
View Answer
| Jun 17 2008 9:44 PM GMT
| asked by
Techzon12
SQL, T/SQL, SQL Server 2000
How to prevent SQL update trigger from firing on insert?
Category: SQL Server 2005, T-SQLI have an insert trigger on TableA that updates Column1 in TableA. I also have an update trigger on TableA that I don't want to fire, or at least not to execute certain code, when a new record is inserted in the table. How can this be achieved? I don't want to use a...
View Answer
| Apr 22 2008 5:34 PM GMT
| asked by
Leo W
SQL Server, Triggers, T/SQL
Convert time to GMT time
In t-sql, I want to store the date from the getDate() function in GMT time instead of local time.
View Answer
| Apr 21 2008 6:42 PM GMT
| asked by
Apinto
getDate(), convert, SQL
Potential over & under security issues with SQLNative Client ?
Hello,I've been unable to find any reports of these two problem when using the SQL Native Client driver (9.00.3042.00), so I'm hoping else has seen these.Firstly check constraint definitions accessed by the following TSQL only returns data with the SQL Server driver, ie nothing with SQL Native...
Answer Question
| Apr 10 2008 6:43 AM GMT
| asked by
WarwickW
SQL Server, SQL Server security, T/SQL
