Topics
Started by
Posts
Last post
What's the recommended method to enforce a rule that a table only contain one row? Is there a downs…
21 replies
SQL SERVER BUG ? Is this is a bug or am I missing something... I'm a fairly experienced …
28 replies
Hi I have two table T1 (columns C10 & C11) and T2 (columns C20 & C21). /*------------------…
3 replies
Though timestamp column is a unique identifier, why it is not prefered to set as primary key by des…
3 replies
Can anybody help me get this right? I have been trying to generate an XML document that looks…
8 replies
I was tasked to write a system to deliver stock emails to all our company's employees. I figured th…
2 replies
Hello, I am trying to change certain columns in different tables to different data types. the …
5 replies
Hey. In a procedure that is stored on one SQL server I need to search trhough tables that are only …
1 replies
could anybody please tell me how to delete/truncate data from tables. When i try to truncate/delete…
3 replies
The featured script to retrieve the last day of the month could be made simpler. The last day of a …
9 replies
I need to select rows from Contacts where Contacts.ModDate (column data type = "datetime") is equal…
2 replies
I need to change the script to delete partially rows from patient data instead of all the rows DECL…
7 replies
This section of a SP should generate an error(Fields not found) at the Insert Statement, but my Ret…
4 replies
I'm writing a stored procedure that, among other things, inserts values into a table. If valu…
5 replies
I have a DTS package in which I need to retrieve a recordset from my SQL Server connection and work…
9 replies
Viewing 15 topics - 11,491 through 11,505 (of 17,082 total)
You must be logged in to create new topics.