Topics
Started by
Posts
Last post
Is it possible in TSQL to determine whether a value is in a specific format e.g. check if the value…
3 replies
Hi, I didn't find any way how to supply hint FORCESEEK in SQL 2005. Do anybody any idea? Tx
16 replies
Hi, I have a doubt here, i want to remove the rows if my result set (QText) column has return NULL …
3 replies
I am runnig the follwing sql in the same server though i have given server name in my sql. When i r…
7 replies
I'm not even sure how to really title this question, but here goes... I have two table that have th…
3 replies
Hi I am pretty new to SQL and have a question maybe someone can help me with. We have a database …
2 replies
/*** Create Variable Table @TableName***/DECLARE @TableName TABLE ( Component Char(…
1 replies
Update myTable Set strwhere = 'C.IT_Code IN ('A','E','C','P','R','O') AND SP.Status='S' and SP.Pay…
5 replies
Ok, I've been looking at this for ages and just cannot get what I want to work! Here's my table: CR…
4 replies
Hello ALL, I have created a query in store procedure and wish to capture a case if that case falls …
2 replies
Hi All, I am getting the below error frequently while connecting to SQL Server. Database access er…
5 replies
My requirement is if the startdate and enddate parameters are null, then the dates should default t…
2 replies
Hello: I'm familiar with the TOP command and that works fine to limit my record count, using a fixe…
10 replies
Table 1 GroupName GroupID GroupDesc Group1 1Item1 Group1 2Item2 Group1 3…
6 replies
Hi all I've got this scenari table1 id Name 10 John 11 Alice 12 Peter table2 id Name 4 John 5 …
13 replies
Viewing 15 topics - 6,991 through 7,005 (of 12,234 total)
You must be logged in to create new topics.