Programming SQL
in [Microsoft SQL Server]
|
Convert varchar to datetime Hi, I have what seems to be a simple issue, yet I can't get it to work: I have a table that I have imported into SQL via a .txt file , one of the fields holds a date (which was originally in the format of '122499'). I added, based on certain criteria a '19' or '20' in front of the year to make it '12241999... 14 Sep 2005 15:12
IsNumeric function I have an excel file that I am using to populate a table in SQL 2000 using OpenRowSet. If the excel cell contains more than 255 characters the IsNumeric function errors. I can populate the table in other columns with > 255 characters when I do not use the IsNumeric function. If the cell contains numeric values,... 9 Sep 2005 16:28
Relational ACL Hi Does anyone have any good links on implementing a relational ACL. I can think of some fairly obvious implementations but i'd like to know...what i dont know. All the links i can find are all Netware/File System relevant. Many of the principals carry over but i'd still like further info. For instance, SAP i... 6 Sep 2005 20:27
Lookup tables What are the typical things you look for to decide whether to use a lookup table? I typically have Country lookup tables, State lookup tables, Airline lookup tables, etc. We also have a field that is a company type which would be one of 6 values: Corporation Partnership ... 6 Sep 2005 15:39
sp_rename Hi, I tried to rename one of the stored procedures by using sp_rename 'Hello', 'World' after I execute the above command The stored procedure name itself changed to 'World' but when I edit the stored procedure in Query Analyzer, the text is still Alter Proecedure Hello as .... .... I think I only change... 24 Feb 2005 07:37
Parsing comma delimited values from ntext field I have a long comma delimited string (more than 8000 characters). like this "<SomeXML1>, <SomeXML2>, <SomeXML3>, <SomeXML4>". I need to parse through them and store them in different rows of same column. The only input parameter I can use is text/ntext since there are more than 8000 characters. Can someone ple... 23 Feb 2005 00:47
Cannot create a row of size 8068 which is greater than the allowable maximum of 8060 when add/updating SQL 2000 on Win2003 Hello, I am getting this error: Cannot create a row of size 8068 which is greater than the allowable maximum of 8060 When updating/added row to SQL 2000 on Windwos 2003. Thanks for all you help, Jack ... 21 Feb 2005 02:30
Query LDAP user group membership from SQL Server this is driving me nuts! all i want is a simple list of groups and members for each group in Active Directory. I read numorous postings on this topic and no one seems to know how to query it from sql server directly. why can't Microsoft provide some kind of schema (views) for that? i can issue a query like thi... 22 Feb 2005 09:33
Datediff function select DATEDIFF(second, min (time_stamp), max(time_stamp)) AS responsetime FROM table1. Now, on this table1, time_stamp column is defined in datetime format. Case1 When the min(time_stamp) is 2/17/2005 8:34:55AM, and the max(time_stamp) is 2/17/2005 8:35:12AM ... the responsetime is shown as 0 seconds. C... 18 Feb 2005 00:21 |