Topics
Started by
Posts
Last post
I am trying to get a list of roles from a specific set of DB's. My DB's are stored in a table along…
3 replies
Can anybody please tell me? What is the basic difference between these 2 query? Select * from Tabl…
6 replies
Hi, I have the following tables : Create Table #Request ( [requestid] int , [customername] Varchar(…
4 replies
What am I missing? The following query does not return results from the Webs table (left join) even…
12 replies
Works for sql statements: ExecuteSql ('sql statement') BUT I want is this: ExecuteSQL…
2 replies
We are in the process of upgrading one of our sql server instances to 2005. We have a process that…
12 replies
myID myVal minTic maxTicticCount ---- ------ --------- --------- --------- 1 A 0.20 …
3 replies
Yeah, my PL/SQL is extremely rusty. Can anyone here point me in the direction of a decent PL/SQL t…
4 replies
I tried to do something like this CREATE Function Foo (params...) Returns bit as begin RETURN (ex…
7 replies
Hi there, in my function i want to make certain standard querry string. my sample code, DECLARE @t…
4 replies
I have 2 tables table1 id, type, date, name table2 id, type, id1 I want to select all rows from tab…
1 replies
Hi, I have a requirement to calculate the difference between dates in a query. The query has been a…
6 replies
I took the following syntax from BOL ALTER TABLE MyCustomers ALTER COLUMN CompanyName SET DEFAUL…
6 replies
hello guys !!! i have a table as id date data 1 3/10/2007 "hello" 1 4/10/2007 "hi" 2 3/10/2007 "hel…
2 replies
In SQL 2005 there's a new function ROW_NUMBER() is there something equivalent in SQL 2000? Thanks …
3 replies
Viewing 15 topics - 11,506 through 11,520 (of 12,230 total)
You must be logged in to create new topics.