Topics
Started by
Posts
Last post
Hi Experts, Wanted to know if there is there any way to have database names aliases in SQL Server? …
1 replies
I was able to use Adam Machanic's logic to Validate a URL from SQL Server, now I am trying to retri…
1 replies
I have created a trigger for a particular table.While i insert a record the trigger is working perf…
5 replies
Greetings dear all, I've a column in a table with type NVARCHAR(50), with values that now "people" …
2 replies
Hello all - I'm having a concurrent deadlock issue, two batch jobs running simultaneously. Here is…
1 replies
Dear friends , How to initialise a sql variable to 0 in stored-procedure which would work both in…
32 replies
HI In SQL server 2000 the sysuser table had an suid column. in Sql server 2008 that table changed t…
4 replies
Hello Experts, I am facing issues with database restoration using different server backup. We have …
5 replies
I'm trying to find the next appointment, if any, after a patient "no shows". Here is the code to cr…
11 replies
WeekNo FromDate ThruDate Period 36 2016-08-29 2016-09-04 201609 37 201…
14 replies
Here in the below procedure we are taking some data from temp data and inserting into main table. E…
3 replies
Hi Experts , i need to insert below input_value into table input_value is: 'select cc_key ,'+ cast…
2 replies
Can SQL SSMS do an Auto Rollback of a transaction? I had an SQL Update done under Begin tran block…
6 replies
TL;DR: when does an execution plan get a)cached b) cleared from the cache? As part of a continual i…
7 replies
Hi, I am using Ola's script to one of the Sharepoint databases to run checkDB. It's SQL Server 2008…
3 replies
Viewing 15 topics - 1,771 through 1,785 (of 30,225 total)
You must be logged in to create new topics.