Topics
Started by
Posts
Last post
Does inserted and deleted tables not support text datatypes? If not is there a way to get the old a…
14 replies
Can anyone tell me why a trigger would not fire when a table is updated from an app, when it fire O…
6 replies
why does this return 0 ??? "select cast((30/364) as dec(20,20))" Steve Johnson Steve Johnson
6 replies
Hi friends, I am performing a search and replace on columns having different data types (note not o…
2 replies
Greetings: In my app I want to get the primarykeys and the datatypes of that column for a table. N…
8 replies
I am trying to display the different records between two tables that have nine fields that are iden…
8 replies
Can I get the name/id of the machine in a trigger that I can use for populating as a user id in a t…
24 replies
Hi Again, I want to change a column's data type from my VB Client using ADO. In Oracle I could do t…
6 replies
I have a stored procedure that creates a clustered index on a temp table which works great. Now I w…
9 replies
Hi All, I have 2 tables with a 1-to-1 mapping. I want to be able to set a constraint which contains…
4 replies
I am creating a table with the primary key being an identity column. This is the snippet of my DDL …
4 replies
Dear All, I am writing a script for SQL6.5 for auto generating a database and a user for that datab…
4 replies
I'd like to know if there is a T-SQL command to replace NULL values by empty (or an other value) fo…
7 replies
I have 36 columns in a table. My objective is to create a trig which traps any column change and po…
5 replies
Is it possible to write a stored procedure that accepts a parameter such as a Datetime and then pas…
2 replies
Viewing 15 topics - 16,951 through 16,965 (of 17,082 total)
You must be logged in to create new topics.