Topics
Started by
Posts
Last post
How do you update the top 10 in sql 2000? Heare is what I have so far, but it updates all the recor…
6 replies
Hi I have a table with a field containing days (Monday, Tuesday etc.). I want to sort on this…
9 replies
Is it possible to change the registration properties using TSQL? I want to change the User and Pass…
5 replies
Hi friends i have this problem, i create a object of dll with the sp_OACreate , and i call a …
5 replies
Here's a simple question ....... If I run this script in query analyzer, do the statements exe…
11 replies
I have an stored procedure that creates a linked server connection to an excel file and inserts que…
2 replies
Here's my select : select dest_bol_no, rev_no, max_rev_yorn from BL_TRUCK_BOL_DEST A WHERE bol_no =…
7 replies
Hi All, I have a procedure for upgrade. It is usual run manually from QA. It's very important for t…
3 replies
This is a weird one. I have a sproc that executes a CREATE VIEW statement in a dynamic SQL. The tro…
67 replies
Under my sql server agent: Jobs, I have got this job "Integrity checks job for DB Maintenance plan …
8 replies
Hello everybody, I had studied earlier that the user-defined datatypes that are created in th…
4 replies
Hello once again, What is the use of 'collate', how effectively can v use that, Likewise what is th…
2 replies
Hello everybody,  …
2 replies
UPDATE p SET p.name=m.name FROM tabl a INNER JOIN tab2 M ON p.number=m.number How can …
4 replies
Hi, I need to create a temp table in my stored procedure with some parameters passed in. The p…
21 replies
Viewing 15 topics - 9,661 through 9,675 (of 17,082 total)
You must be logged in to create new topics.