Topics
Started by
Posts
Last post
Has anyone heard of an easy way to convert triggers to foreign keys? We have an "old" database of 2…
4 replies
I am trying to write a trigger that whenever a row is added to a table, the AI Trigger will execute…
2 replies
I am trying to fine tune a query and I'm not sure which operator (IN or OR) is faster? I'm worried …
5 replies
I'm trying to extract a substring and convert it to a datetime variable without success. Can someon…
5 replies
Is there a way in t-sql to transform data stored in row form to column form. By this i mean the fol…
6 replies
have 0ne field, model. Need to add a -R to the end of the text that is in this field ie...before, L…
2 replies
I have attempted to create a script to do a backup and restore that would be useable for several di…
2 replies
I have an sp that I use to update all DB's. I supply it a block of T-SQL and it executes it using …
4 replies
I am trying to see if a "IF" condition in a trigger is executed or not and so I am trying to use th…
3 replies
Not sure if this is the correct forum. Maybe 'Performance tuning' would be a better place to ask th…
3 replies
Does anyone know the syntaxt to connect to and disconnect from another SQL SERVER while executing a…
10 replies
Hi, All I have a Q for U. I though this was easy to do but not quite.. Here is one.. ID Code …
6 replies
Hello I have a customer table with many duplicate records. Many times the companyname is misspelled…
3 replies
How can I retrieve the values for the Description Property for a tables columns? I mean with a T-sq…
1 replies
Hi. I've read somewhere that if you had the XACT_ABORT option set to OFF (which is the default v…
2 replies
Viewing 15 topics - 16,831 through 16,845 (of 17,082 total)
You must be logged in to create new topics.