Topics
Started by
Posts
Last post
consider the following scanario of categories table CatID ParentID Ca…
23 replies
I have two tables like this Table1: ID LName FName -------------- 1 LN1 FN1 2 LN2 FN2 3 N…
5 replies
Hi, don't know if I have this in the right forum but thought I'd give it a try. Is there any …
5 replies
As I was reading in BOL, the bitwise operators seem to work for int and smaller. I've been using t…
2 replies
Hello - Is there any way to capture all the text LEFT of the CHARINDEX character in a text string, …
8 replies
Is there a way to find which tables in the DB has rows in it and select all those tables which has …
5 replies
Can a variable be passed to the @command line? If so, how? Here's a portion of what I have: D…
1 replies
Hi all, Here i have one question that I am fetching some names through the cursor. Now …
4 replies
My Database name is ST_Rel_4.050_Test When i fire query in select * from ST_Rel_4.050_Test.dbo.sa_d…
57 replies
I have 2 tables (more than 10 million rows each). table1 has 3 columns a - datatype - varchar, b - …
15 replies
SELECT A1.JoinID from Join A1, Product A2, Location A3 WHERE A1.ProductID = A2.ProductID AND A1.Loc…
3 replies
I have a table containing 2 string fields : field1 field2 ============= s1 s1 s1 s2 s1 …
6 replies
Hi, This might be a really dumb question but is there a way to do something like this: Select (sele…
4 replies
I'm using SQl Server 200 SP3 standard. I have an Agent job that runs a script calling several…
2 replies
How can i check if my database has any circular references/relationships and how to get rid of them.
5 replies
Viewing 15 topics - 4,261 through 4,275 (of 17,082 total)
You must be logged in to create new topics.