Topics
Started by
Posts
Last post
I've always used the left outer join operator instead of the "*=" legacy syntax but below has been …
5 replies
hey guys, i insert into a table that has a trigger (FOR INSERT). The problem is when i 'batch' inse…
17 replies
hi every body ,i have some problems and i hope you help me..i used sql server with job schedule it…
2 replies
i want to use Set Datefirst 1 statement in UDF but when i create the UDF it gives error invalid use…
3 replies
USE msdb DECLARE @TXT AS NVARCHAR(50) SET @TXT = N'sp_help_job @job_name = ''SWLTEST'', @job_aspect…
1 replies
how can ido this ? Every new year new number Generating in SQL server evry new year Generating new …
12 replies
I am running the code below. The table "tblGU" has approximately 188k records in it. I have three i…
13 replies
Can anyone tell me what the difference between the 'xtype' and the 'type' fields in sysobjects and …
3 replies
How can i make auto number from the first day of the year? How can I make this? From the binging of…
7 replies
OK, who noticed my deliberate mistake? Here's a useful tip for you. Always make your char and varch…
1 replies
Does anyone have any documentation for the sysproperties table? It doesn't appear to be mentioned i…
2 replies
I see queries where a capital N precedes strings in single quotes. Ie: OBJECTPROPERTY (id, N'IsPro…
3 replies
I have a question about using print. I put some print statement in an stored proc so I could monit…
4 replies
I have two columns, name & keywords How can I change the following SQL statement so that it wil…
3 replies
is *= a left outer join or right outer join? thanks in advance, Billy
3 replies
Viewing 15 topics - 13,651 through 13,665 (of 17,082 total)
You must be logged in to create new topics.