Topics
Started by
Posts
Last post
We're currently developing a multithreading windows service which is simply dispatching work to the…
12 replies
I have an AS 400 linked server that I am querying from sql server using the open query method. …
2 replies
Hi, I have created a SP to restore a database. it works fine when i ran through the QA. but it give…
5 replies
I have a trigger that is fired on a table that is used to update another table with appropriate dat…
5 replies
Greetings, I am trying to get the identity value inserted into the table in the current scope and c…
1 replies
I found this stored proc to decrypt other sprocs that are encrypted. Quick question, does this repl…
4 replies
Hi, I want to use parameters in a DECLARE CURSOR statement. The following code appears to work righ…
1 replies
In a function like RIGHT(N'123', 2) which yields '23', what exactly does the N do? I have see…
5 replies
Hi All Does anybody know how to detect changes in the data using T-SQL but not with triggers. I ha…
15 replies
Hi, I want to do a select on tables in multiple databases. Can it be done? Thanks Dinuj Thanks and …
2 replies
I have two table... the first table, I can update the primary key but the other table I can't. erro…
2 replies
Why is this script updating every record in the table? The table has 197 records in it but only 88 …
10 replies
Hi All, I need your help with joins. I have a table which contains the store number and day polle…
3 replies
I have lost the resource that answered this for me and can't seem to find it again ... I seem to re…
6 replies
I have the following code. DECLARE @time datetime SELECT @time = GETDATE() SELECT 12345 AS …
6 replies
Viewing 15 topics - 10,801 through 10,815 (of 17,082 total)
You must be logged in to create new topics.