Topics
Started by
Posts
Last post
Here another one, can you please help me optimize this one as well. -------------------------------…
9 replies
I have the following table structure: col1col2 abcfolder1\folder2\folder3\abc tttfolder1\folder2…
3 replies
This is probably a newbie question but what system stored procedure or dmv will return what current…
4 replies
how do i convert IIf([x]="YEN","JPY",IIf([x]="EURO","EUR",[x])) AS InvCurr to SQL?
8 replies
How the below can be written in SQL? CStr(Format([x],"dd-mmm-yyyy")) as y where x is a [smalldatet…
6 replies
Hello! I need to check whether an UPDATE statement succeeded or not... But this code does not what …
4 replies
hi experts i've created a bat file and scheduled it to run daily at midnight, i used windows schedu…
2 replies
Dear friends, I am using two queries inside a stored procedure to check two different tables. I hav…
1 replies
hi, i'm trying to dynamically create a tablename in tsql so that the tablename contains the month a…
1 replies
I have a query where I need to evaluate the contents of one field and return results based off the …
11 replies
IF Any chance to create DDl trigger in sql-server 2000 If its possible give any one sample..
1 replies
hi, i have a stored procedure: create proc pBaseValues @kennung int as if @kennung = 1 select …
3 replies
Hi, I have tableA that has a primary column named "EmployeeID". Then there are 10 other tables th…
5 replies
The syntax is sp_recompile @objname = 'objname' The object name can be the name of a stored procedu…
6 replies
i want to pass to_date and from_date to a SP and wanted to get the latest modified SP's,Views and F…
2 replies
Viewing 15 topics - 7,306 through 7,320 (of 12,230 total)
You must be logged in to create new topics.