Topics
Started by
Posts
Last post
hi, I want current year and month like YYMM in user defined function. How can i achieve this one. T…
4 replies
I have a 'base' stored proc which performs many calculations required by several other stored procs…
3 replies
I have a table where 1 desk may have >1 portfolios. i.e. Desk 1 has portfolios W,X, Y, Z so the …
1 replies
Basically, can you do this? BOL states that any data type but a cursor can be used as an input para…
2 replies
How can i display a column as row in Tsql (sql server)
4 replies
Hi, It is very frustrating that SQL Server's largest date type can only go back to 1753. I'm …
7 replies
Table has duplicate SSN. I want keep ony one entry for per SSN. Any duplicate entry want to de…
8 replies
Hello All, I am trying to execute the below line of code, so that the resultset would fit on 1 line…
1 replies
In mY database the create date for all the db objects is having some weird characters after the act…
1 replies
I am trying to update a field (varchar) in a newly written record if that field is null. The update…
3 replies
What GUI interface to do you recommend for creating StoredProcs? Currently we do the query in Ent…
2 replies
Hi, I have a script to search a word (some text in general) in all stored procedures text, somethin…
3 replies
I open up SQA (2000) connecting with windows authentication looking at a SQL 7 Server. Put in a num…
2 replies
If using the TABLE data type in any SQL statement, where does the structure get built.....in memory…
4 replies
Hi when I run the following statement in the query analyser, I get an error : [Microsoft][ODBC SQL…
3 replies
Viewing 15 topics - 12,361 through 12,375 (of 17,082 total)
You must be logged in to create new topics.