Topics
Started by
Posts
Last post
The EXECUTE sp_executesql allows the dynamic execution of a SQL statement where that statement is …
4 replies
I have a table with thousands of sales history records. Some of the records have skewed data i.e pr…
21 replies
Hi all, Using SQL2K. Consider the following: IF OBJECT_ID('tmp_list') IS NOT NULL DROP TABLE tmp_l…
4 replies
Hi, Currently my query returns 6 rows; it returns the first and last row for each ID_NUMBER... But …
2 replies
Dear All, is there any system table available in TSQL like we have 'select * from dual' in oracle .…
4 replies
I have a very large stored procedure (called pr_insert_order) that saves an order into our database…
12 replies
I have been able to link the server to query AD. I use a Cursor to go through and import OU's…
4 replies
Hello, (SQL 2000 SP4) We are looking to solve a problem we run into somewhat regularly where we nee…
6 replies
Hi All, I have to add a new column in all the tables which resides in a database. say for example, …
6 replies
Hi , I am trying to write a message to the Event Viewer by using the command :raiserror(@testmessag…
1 replies
Hi, I'm writing a stored proc to display credit/debit values. These values are of type decimal. I …
8 replies
After building a custom schedule tool, I had to discover ways to find things such as first day of t…
9 replies
Hey all, I have been working in a test environment and the following statement works fine (both tab…
3 replies
hello friends is any different between this kind of declaration for Table field : [Name] varchar(10…
3 replies
On One server error log reintializing, on daily basis,means it is creating new errorlog, instead of…
1 replies
Viewing 15 topics - 2,131 through 2,145 (of 17,082 total)
You must be logged in to create new topics.