Topics
Started by
Posts
Last post
Dear All I have a stored procedure that is outputting a PageID and StatusID. PageIDs can be any in…
3 replies
Dear Friends, I have a table which contains the rights of groups for the file types. Another table …
2 replies
Hi, Can anyone help me to construct a sql query? I have a query that calculates quantity of hours …
5 replies
Hello again, I know there's 2 versions of inner joins: 1: select * from r_user ru inner join r_con…
4 replies
I would like to use a query for several searches in my database. Currently, my stored procedure tak…
2 replies
Hi, I am in no way a db expert, but I am required to create a generic trigger to track changes to a…
21 replies
I couldn't find this answer anywhere, but what can I do so that my scripts will work for databases …
2 replies
What happens to nvarchar variables when different concatenations are performed. (This is for a dyna…
8 replies
Hello I am trying to write a query, that will retrieve records of customers that are about to expi…
14 replies
i have the following table remarktyperemarks Remarktype1Remarktype11 Remarktype1Remarktype12 Rem…
8 replies
I have a table with the following structure: REF Id Value Code…
2 replies
Hi, I would like to know how can I create a trigger which affet on another table. I have a …
6 replies
Hi All, I have a situation here for inserting one value in my existing record. here is the situatio…
5 replies
Hi, I'm looking for a solution to a UPDATE query I'm trying to perform. Basically, I have an existi…
6 replies
I try during a transaction raise error but @n return me always 112....not 100. Where I wrong. Thank…
3 replies
Viewing 15 topics - 9,406 through 9,420 (of 12,234 total)
You must be logged in to create new topics.