Viewing 15 topics - 266,176 through 266,190 (of 284,116 total)
Topics
Started by
Posts
Last post
Are there any system stored procedures that would allow you to simply type the name of any table fr…
5 replies
Hi, i am running a create Database Script, but need to move the Database, depending on where the us…
1 replies
I've always used the left outer join operator instead of the "*=" legacy syntax but below has been …
5 replies
I have two columns, name & keywords How can I change the following SQL statement so that it wil…
3 replies
I have two columns, name & keywords How can I change the following SQL statement so that it wil…
2 replies
Hi everyone, I had posted a message on this board a week or two ago about the same problem. I…
3 replies
Just wondering if there is a maximum number of joins recommended in a select statement for sql serv…
2 replies
how can ido this ? Every new year new number Generating in SQL server evry new year Generating new …
12 replies
Hi all, I am interested in tracking certain client information for all users who connect to my sql …
4 replies
Hi All, Does it make any harms for my production database if I shink it couple time a week? Please …
2 replies
Is it a good to write a store procedure using dynamic sql? What in ways could I optimize this SP th…
1 replies
is *= a left outer join or right outer join? thanks in advance, Billy
3 replies
I see queries where a capital N precedes strings in single quotes. Ie: OBJECTPROPERTY (id, N'IsPro…
3 replies
Can anyone tell me what the difference between the 'xtype' and the 'type' fields in sysobjects and …
3 replies
Does anyone have any documentation for the sysproperties table? It doesn't appear to be mentioned i…
2 replies
Viewing 15 topics - 266,176 through 266,190 (of 284,116 total)