Topics
Started by
Posts
Last post
Hi experts, How to query from 2 different servers, say, server A (SS 2000) and server B (…
4 replies
I have a trigger on a "expense report" table that fires on inserts & updates. Basically t…
1 replies
Hi everybody, I have a querry like that: UPDATE tblGood SET userID = @userID, DateUpd = @DateUpd …
3 replies
Hi All, I'm working on a reporting tool called VISION, which can extract data from underlying SQL D…
4 replies
Is there any way to create a foreign-key within a table...For example, I have an employees table, a…
6 replies
Hi All, Do you know how to use "CASE" in "WHERE" clause? Could you please give me some examples! Th…
3 replies
I'm trying to select a bunch of rows but I only want the latest trips (trip_id) for each recor…
4 replies
Hi, I have 3 tables TBL_MAIN, TBL_A, TBL_B. TBL_MAIN has a primary key PRIM1 and both TBL_A and TBL…
3 replies
OK,it's Friday and I'm brain dead. But is there a function that will return the number of the curr…
2 replies
I have a table. Field1 and want to create the view.
4 replies
Is this possible? Can you pass a table variable to another stored procedure, modify its contents, …
7 replies
How can i make a select statement return a "default" value if it returns null. below is what…
5 replies
I need to fetch the monthname in full like january, march. I need to pass only the month(numeric). …
3 replies
During development (and occasionally for debugging in production) we find it useful to use print-st…
2 replies
I am importing a text file with '~' column delimiter and my text has in the file has some format.If…
2 replies
Viewing 15 topics - 12,226 through 12,240 (of 17,082 total)
You must be logged in to create new topics.