How can I know what query is executing by by a particural user? (using sp id or any othe way.)2 2878
what is the main difference between after trigger and instead trigger.2 17214
I have to display ten columns values from diffrent ten tables. how many joins are require?10 8524
What is Report Server,Report Manager and Report Builder in SSRS 2005?1 16085
what is syntex second or third highest salary. thanks & Regards Dhirendra sinha7 4865
what is difference between nchar and char in Sql server ?3 5273
How can we write or define DDL statements in Sql server and DML statements?3 3727
i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L8 3221
write down the code for "how we delete a table without using of Drop command " ?7 5859
9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 182 2348
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h1 2244
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)8 7816
System variable and temporary variables
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
What is the difference between NOROW and LOCKROW?
New concepts of sql server 2005 use in your project.
where the connection string store in the database
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
You are doing log shipping due to some reasons it is failing. How you will proceed from there
plss anybody specify tha constrian management system in dbms
your distribution database is full what will u do
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
what is checksum in sql server.........???
Delete duplicate rows without using rowid.
How retrieve field names from the table in SQL through JAVA code?
tell me the disaster recovery plan