Topics
Started by
Posts
Last post
i got this message when i was executing my trigger.. the error message is Msg 1013, Level 16, State…
12 replies
Hi all, Does anyone know a workaround in T-SQL to retrieve names which has a french accent mark SEL…
1 replies
How do I name a column when using a For XML Explicit clause. I would have expected this to be simpl…
2 replies
Hello everyone, I have a SQL statement thats looks correct but I can't seem to figure out why it's …
10 replies
Hello Everyone I am trying to change the ownership of all objects of a certain type, such as all th…
3 replies
Hi all, I am having an issue selecting only rows that contain the MAX(createdate). I will break dow…
4 replies
The trigger below will send the correct e-mail twice for Yes and an empty e-mail twice for No: CREA…
5 replies
Hi, If you use ANSI joins in a select statement, are there any occasions when you would still need …
6 replies
Hello. I have the following table and sample data: Id | CacheString ----------------- 1 | 'Cache …
6 replies
Hello, Trying to get this statement working: IF NOT EXISTS('SELECT ' + @ColumnName + ' FROM ' + @T…
10 replies
Hi everyone, I have a table with the following structure and data -- Step -- Id(PK), RisktID(FK), D…
10 replies
I'm declaring and opening a cusor that consists of all columns from a given table. This is a fairly…
2 replies
I just started working on a project for my company in which I need to build a process for matching …
9 replies
i have a problem with my trigger.. I have create my trigger to audit Users Table. The problem is, i…
1 replies
Hi, Does anyone know of any tools that give a code complexity analysis value of t-sql or dts code? …
3 replies
Viewing 15 topics - 10,726 through 10,740 (of 12,230 total)
You must be logged in to create new topics.