Topics
Started by
Posts
Last post
How do I display a 'datetime' field in a view as mm/dd/yyyy? I'm trying to create a view with the d…
4 replies
Hi, I am attempting to create a data type based on datetime that will have the date portion set to …
9 replies
While adding to a table of unique (nonsignificant) IDs to use in place of social security numbers, …
10 replies
There doesn't seem to be any basic search for the forums so if this has been covered before, I appo…
8 replies
Hi I need to create a number of strings depending on bool-values in a number of fields. I want the …
2 replies
This isn't a problem per se, but more a bit of angling for suggestions. I currently have a vb scrip…
9 replies
Hi All, SELECT * FROM sys.sysdatabases If i run the query it will display all the dat…
4 replies
Hello Comunity I´am curious about this kind of method to import into SQL 2005 an Excel Sheet. I try…
1 replies
I have several instances of a windows service that are spread across many machines. These services…
3 replies
Hi all, I'm kinda new to the SP scene and was wondering if someone could give me advice on the foll…
9 replies
When asking SSMS to execute a stored procedure, the code generated is: GO DECLARE@return_value int…
3 replies
SELECT SERVERPROPERTY('LicenseType')) AS LicenseType, CONVERT(char(100), SERV…
1 replies
This simple stored procedure works FINE! ALTER PROCEDURE [dbo].[UB_BH_ANNEX_SP] @SitusParam NCHAR(…
3 replies
Hi all, I am using a lot the system stored procedure sys.sp_columns for retrieving the data type of…
5 replies
The following is the table structure and sample data. I am looking to return the most recent date …
12 replies
Viewing 15 topics - 10,981 through 10,995 (of 12,234 total)
You must be logged in to create new topics.