Topics
Started by
Posts
Last post
Went to rollback a transaction from a script I started with Begin Transaction and the result was an…
3 replies
What is the wrong in this query insert into tbTasks_New( AssignedToId) values('Employee') where Ow…
2 replies
Hello All, I need help to figure out this query. From the sample data, If a program has form (cb_re…
11 replies
I want to set a bunch of variables to the results of a SELECT that will only return one line. Is t…
10 replies
Populate this Contract Number field in the database... Fields are SSN, Contract_Number, Effective_D…
6 replies
Hi, I need to set a date column, and milliseconds are significant. If I do this: UPDATE mytable S…
8 replies
Hello, I am trying to parse data and put in seperate columns if possible. For example: 332|347 34…
5 replies
I see query somebody use like below. So let me know this method (joinig tables/ outer join) is good…
2 replies
Hi there, I have table holding values for hours, and for days as: CREATE TABLE [dbo].[HoursandDays]…
8 replies
We have 60 stored procedures without headers. now we need to include below details in all sp. Is th…
4 replies
Hi I am trying to copy a data from text file to temp table using bulk insert but it gives me Error…
3 replies
I am using many indexes in my database I understood that it is not advisable to rebuild all the ind…
4 replies
Hi All I want to reserve memory. I am not using sql full text nor the analysis service in my applic…
4 replies
Hi All, I have a question around "What is the best practice" for doing a delete statement when join…
7 replies
I'm testing the below script. If I give the path name wrong, @hr variable giving some number (like …
1 replies
Viewing 15 topics - 6,661 through 6,675 (of 10,635 total)
You must be logged in to create new topics.