Topics
Started by
Posts
Last post
Hi, I am facing some problem while updating a column through trigger. I have a table User_Records w…
14 replies
Hello, I am using SQL Server 2008 R2. Whenever we are taking backup of the database, all the users,…
5 replies
I am trying to create a procedure against all my databases and I am not able to see the error. I ha…
8 replies
In trying to optimize database code, are there any tools that can go through all the stored procedu…
2 replies
I am involved in a migration project with the following parameters. - There are stored procedures r…
4 replies
HI i Write a procedure that you can see my Code Here {----- Code set ANSI_NULLS ON set QUOTED_IDENT…
28 replies
I know triggers are not allowed on Select statements but here is my issue: there is some code (that…
5 replies
Declare @strStartTime varchar(50) select @strStartTime = '12/10/2010' select * from Elect_SubB1_Dai…
2 replies
I'm using the XQuery nodes() method to shred XML, but in addition to the node value, I want to retu…
7 replies
Hi, everybody. I have a problem optimizing my stored procedure, but after a long research on cursor…
12 replies
I have the following query. It runs fine in SQL 2000, but since the upgrade to SQL 2008 it's geving…
9 replies
Hello, I am trying to find a solution to compare columns and values stored in another table with ac…
4 replies
I need recommendation on which books to buy for SQL Server 2008 developer Thanks
2 replies
Hi all. How do you check if a record doesn't exist? I want to return an empty string for column3 if…
1 replies
Hi, I've got the following raw data: C100071540 1 10120101122 040039 using the fol…
1 replies
Viewing 15 topics - 9,001 through 9,015 (of 10,647 total)
You must be logged in to create new topics.