Topics
Started by
Posts
Last post
Hi, See the following procedure. Create procedure test as begin declare @test-2 varchar(8) …
6 replies
I inherited a table whereby the date is broken out into three separate fields (numeric) instead of …
4 replies
I would think this would be simple but still having trouble with it. I have a search variable passe…
2 replies
Hi I am using SQL Server 2000 I have a function which returns a value from an Oracle server, as sh…
3 replies
Hi, This stored procedure has been in used for some time. But, only recently, it runs into a timeo…
1 replies
iM a newbie. I need a script that will allow me to drop a table BMUser.templist (BMUser as the dbo)…
1 replies
If I have a table that goes like this: fieldid userid &nbs…
3 replies
Hello All, I am trying to execute a query in QA and getting this error: [Microsoft][ODBC SQL Server…
1 replies
Hi, I need the equivalent for below mysql query : select *from test limit 5, 20 I know that the bel…
1 replies
Hi, I would like to get the top row and assign it to a variable. How can I achieve this? Declare @N…
6 replies
Hi, I have some data in a source system that is a PERFECT fit for a recursive CTE but unfortunately…
4 replies
Hi guys, Could anybody reccomend some good T-SQL books? Thank you
1 replies
I've seen this come up a few times, but couldn't find it after a brief search. If anyone has …
2 replies
Please would somebody suggest how one might pass the value returned by READTEXT to a variable (eg S…
4 replies
I have a table called quizresults which gives details such as username,score,datentime,quizid,rank.…
17 replies
Viewing 15 topics - 8,851 through 8,865 (of 17,082 total)
You must be logged in to create new topics.