Topics
Started by
Posts
Last post
Hello, Could some one please tell how to get the current Identity value from a table using Dynamic …
2 replies
dear all i would like to take the mcp certification in sqlserver--->70-229 how should i prepare?…
1 replies
Hi, Please write an SQL Statement which will analyse a Table which has many fields and list those…
2 replies
SELECT 'ActionTime' = actiontime, 'Line' = line, 'PhoneNumber' = phonenumber, 'ActionType' = cat.Ac…
5 replies
I have a .bak file and I need to restore it using TSQL. I do not know what the logical files names …
7 replies
Hi In SS2000, I want to see if the employid in transaction_table is exist in DD00100 table, and I a…
1 replies
Hi all, I have been working on this for past 2 days but can't figure out how to do it. I would be r…
4 replies
I'm trying to create a stored procedure to selectively update or insert to a table. The origi…
3 replies
Hi All, My head is just at bursting point today trying to solve this problem. I have 2 tables, one …
4 replies
I am trying to build a search form so a user can input their search term. How do I handle the…
1 replies
I keep getting an error of "Invalid column name 'ClosedFiveDaysTot'. Server: Msg 207, Level 16, Sta…
5 replies
Folks, I have a small table with column1 as UserID and column2 as RoleID I have multiple roles assi…
2 replies
Other than setting ANSI_NULLS to on/off, is there a function I can use which automatically 'un-null…
1 replies
Is there a function like iszero li isnull where i can check zero eg: Select isZero(count(*)) from a…
5 replies
Hello, We have a large number of Intermediate and Aggegate tables that are populated daily. We have…
6 replies
Viewing 15 topics - 11,596 through 11,610 (of 17,081 total)
You must be logged in to create new topics.