Topics
Started by
Posts
Last post
I had created following table Create Table emp(empid int,ename varchar(30)) Insert Into emp values(…
2 replies
First SP is used to check how many tables Referred and return the Referred tables names Second SP ,…
1 replies
First SP is used to check how many tables Referred and return the Referred tables names Second SP ,…
1 replies
Hi Guys I have got this query where I am using union all to combine different dates. These dates ha…
1 replies
Apologies if anyone just looked at this in the 2000 forum, it wasn't until I saw the Control Panel …
14 replies
This doesn't seem like it should be this hard... maybe it's just a Monday thing. I've got some dat…
5 replies
select distinct A.Col1,A.Col2,A.Col3,A1.total as [current_month] ,A2.total as [current_month-1],A3.…
2 replies
As the description reads, I need to search every column in a database, I've done some web searchs a…
21 replies
To multilpy TotalLoans X .06 do I use set @TotalC1 = ((@TotalLoans * 0.06)) OR set @TotalC1 = ((@To…
2 replies
I am trying to enter data into product id's that correspond to a category id in a different databas…
3 replies
I have a front end application which has 4 checkboxes . Each checkbox corresponds to a column in th…
2 replies
I've a fair number of tables in my various databases, which are there for the sole purpose of accom…
5 replies
CREATE Trigger dbo.Tab_trigger on dbo.Tab for INSERT as declare @body2 varchar(2000) declare @ID v…
7 replies
Hi All, I'm using a XML Value() method to parse a XML data & insert the data into a table. But…
1 replies
i have a tables like : this table have the columns: ----------------------------------- prioriy tab…
2 replies
Viewing 15 topics - 5,386 through 5,400 (of 12,231 total)
You must be logged in to create new topics.