Topics
Started by
Posts
Last post
when i use the sp_helptext with a name of procedure it shows the word 'text' and a line of '-…
5 replies
What are the differences in creating an Index on multiple columns as a Constraint or as an Index? W…
2 replies
A simple question, but I coouldn't figure it out so far: Inside an SP, how can the SP knows the tra…
9 replies
Hi I have a table that returns the next: ID MATCHES …
4 replies
hi, In my installation of SQL Server the T-SQL Debugger runs but does not show the value of local a…
3 replies
Looking for T-SQL to add a COMMA in the following situation: My single column contains the City, St…
9 replies
I have the following code; ISNULL(CI.InsuranceStartDate, '00-00-00') AS 'InsuranceStartDate' But I …
6 replies
Hi all, My first post on SQLServerCentral, and it's a good 'un! What I'm trying to do is find a cle…
12 replies
Background info: I have a main SQL stored procedure that calls the crosstab stored procedure found …
6 replies
does anyone have a handy script to get a count of all user objects (tables, views, stored procedure…
3 replies
Hi All, Is there any way to find the event (Insert/Update/Delete) whcih fired the trigger on …
5 replies
I am running an application on SQL Server 2000 with a Transaction Isolation Level of Serializable (…
2 replies
I am from the Oracle world and use the following script to display unique and nonunique indexe…
2 replies
how i can find total no. of days in month in SQL Server2000?
3 replies
Hi All, I have a stored proc that uses a cursor to iterate over the join resultset of 5 table…
3 replies
Viewing 15 topics - 10,831 through 10,845 (of 17,082 total)
You must be logged in to create new topics.