Topics
Started by
Posts
Last post
Dear all, I'm getting an error as given below while executing the query: Msg 512, Level 16, State 1…
3 replies
Hi Guys, I know this should be simple to code but i've hit a wall trying to produce something simpl…
21 replies
Dear All, I''m getting an error msg on executing the below given SQL query: Msg 102, Level 15, Stat…
3 replies
--exec [dbo].[GenerateSeries] 100 alter Procedure [dbo].[GenerateSeries] @int bigint=NULL AS BE…
7 replies
Hello, I am using SQL Server 2008 R2 and facing an issue to update XML attribute value. I have a re…
2 replies
I have below table: ColA ColB ColC ColD ColE ColF Host1 P PP dateA 98 Host1 Q …
3 replies
I want to select the password from the aspn_membership (.NET memberships tables) and decrypt it a…
6 replies
Ok, here goes. I have a table, which sits within my CRM and stores "questionnaire" type information…
9 replies
We have one procedure [say P1] having multiple inserts to a table [Say Target1] resulting from join…
21 replies
I have a trigger that is firing with out issue in non-production but the same exact code is failing…
12 replies
How do you write a case statement like this for the <> 2 part? select field1 from tbl1 where …
8 replies
If I had a single INSERT INTO statement that was very big, what would happen to the transaction log…
8 replies
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
Viewing 15 topics - 5,836 through 5,850 (of 10,644 total)
You must be logged in to create new topics.