Topics
Started by
Posts
Last post
I have a database supporting a web page that logs each user login. I want to count each user's logi…
6 replies
Does anyone know how to get an inner join which uses or blocks to work efficently as at present it …
5 replies
How can I create a select statement that uses a sub query to generate its values as well as the ini…
8 replies
I need to parse data within a field into multiple records Ex: Here is the table layout Sku &nb…
7 replies
hi, i m able to return a TABLE thru Function. Now, i need to pass TABLE as an argument to a Functio…
7 replies
Hi looking for a solution for next problem. Got one table : Customer, AccountCode, Entrydate, Debit…
4 replies
Can anyone tell me how to get a short month from a date e.g. JAN, FEB etc Thanks
3 replies
When restoring a database I'm getting the following error: The media set for database 'datab…
4 replies
There's probably a function already available to do this, but I am asking any way. I know I can con…
17 replies
Please have a look at the code below: CREATE procedure rt_edt_sp as SET ANSI_NULLS ON SET NOCOUNT O…
15 replies
it is legal if I write like this: select * from t1 where c1 in (select c1 from t2) what if i write …
3 replies
Hello, MSSQL 2000/sp3 A developer stumbled across the DERIVEDTBL keyword while coding. There seems …
4 replies
Hi, We are trying to find out how to identify / manipulate the 'CASCADE' property of a foreign key.…
7 replies
Hi We need a select statement in a stored procedure. This sp is called from a asp.net application …
7 replies
i am trying to find out where the table properties on relationships like Enforce relationship or re…
2 replies
Viewing 15 topics - 10,291 through 10,305 (of 17,082 total)
You must be logged in to create new topics.