Topics
Started by
Posts
Last post
Log file size is increased to 3 GB in production. Can any one suggest me how to decrease log file s…
10 replies
Dear All, Hi! I am in a need where I have to store "Insert, Update, Delete" statements in an AUDIT…
4 replies
select 'A' as [value], 'B' as [value] for xml path('test'), type This outputs the following:…
7 replies
Hi all I am trying to implement a simple warning system using database email. I am monitoring an …
9 replies
Hi Team, We have Two Environments QA and IST. Here we have ABC user we have How Can we check ABC us…
2 replies
Hi, I have the following SQL: UPDATE TABLE1 t1 SET Processing_Status = 0 WHERE t1.ID NOT IN (SELEC…
4 replies
REVISED Question: I want to return all data (varchar) from a column in a table and have it sorted a…
9 replies
Greetings all. I was posed with what turned out to be a more difficult problem than I had anticipa…
40 replies
Hi, I want to multiply two columns in SQL nd store can anybody help me out in this scenario. Exampl…
13 replies
hi, i am trying to get 0 as a value if no of rows is 0 still not getting ,my result set is blank. p…
9 replies
Hi all I have a list of file i want to Bulk insert using the Bulk Insert command. I also have an XM…
10 replies
I hope someone can help me. This is driving me nuts. I've got a big file that is tilda delimited. W…
1 replies
I executed this query: update table2 set id=(select max(id) from table1) where id=0. It indicates i…
2 replies
Hi Following is the code CREATE TABLE #ProductRate( [ProductID] [int] NOT NULL, [FromDate] [date…
14 replies
Hi I have table which has to delete the 5 week older data.Please help out. I would appreciate your …
5 replies
Viewing 15 topics - 5,851 through 5,865 (of 10,647 total)
You must be logged in to create new topics.