Topics
Started by
Posts
Last post
Hello all, BOL states: Use update locks instead of shared locks while reading a table, and hold lo…
6 replies
Hello, I've got a somewhat interesting issue that I'm in the process of working through and was won…
5 replies
If I simply use following statement ALTER TABLE table_name ALTER COLUMN col_name_pwd va…
1 replies
I have an Accountmembership Table. This table has 5 TEXT (DataType) Columns. I'm currently developi…
1 replies
Hi, I am trying to create a stored procedure where each time the procedure is called the tempoprary…
6 replies
In a JOIN statement, I've always seen it look like: FROM Table1 LEFT JOIN Table2 ON Table1.I…
6 replies
Is there a stored procedure that lists all the login accounts on a server? If I use windows autheni…
4 replies
Why do I always have SQL trouble on fridays? Anyway, I have this query, where I'm trying to …
11 replies
I have a file that looks like this: Amber Wood Photgraphy 252 Ashley Road Parkstone Poole Do…
3 replies
Hi, I want to return the next row in a select ... order by ... cursor. I don't want to loop,just S…
5 replies
Hi there, FIRST PROBLEM: Can some one tell me the syntax to re-calculate the values of the IDENTITY…
4 replies
Lo to all, I hope someone can help. my questions is: i have a string " where strs in ('…
8 replies
"Transaction (Process id 119) was deadlocked on lock resources with another process and has been ch…
4 replies
Is there any way of displaying SQL dates in the following format: ddmmmyyyy i.e. 01Apr2005 Thanks i…
4 replies
Hello, Please spend some time to solve my problem. Some people suggests to change my ta…
2 replies
Viewing 15 topics - 9,151 through 9,165 (of 17,082 total)
You must be logged in to create new topics.