Browse by Tags

SQL Cast using sp_xml_preparedocument

Hi Experts, I'm super new at these types of functions in SQL. I'm passing in an array of foreign key values to select corresponding primary key values from the parent table for a hiearchical grid. The ASP.NET / VB code seems to be working. But I think I need to cast from text to int out of the...

Posted to Queries (SQL) (Forum) by microsoft on 06-22-2009
Problem: Copy a table schema from one database to another using T-SQL

Hello Experts, Can some provide me the T-SQL I would need to copy a particula Table in one database into another. It needs to only copy the table schema, not any row data. I don't want to use Integration services or DMO. Only T-SQL. Thanks!

Posted to SQL Server 2005 (Forum) by microsoft on 06-10-2009
Problem: Linked Server can't read/write MS Access Tables (Error Msg 7303)

I'm attempting to use this to access MS Access 2003 from SQL Server 2005. I cannot use DTS/SSIS because I need to access data in real-time from a web page. EXEC sp_addlinkedserver @server = 'MyAccessDB', @provider = 'Microsoft.Jet.OLEDB.4.0', @srvproduct = 'OLE DB Provider for...

Posted to SQL Server 2005 (Forum) by microsoft on 06-02-2009
Problem: IF STATEMENTS IN WHERE CLAUSE

I have optional parameters on my sproc. How do I evaluate whether they're null or not? Attached is what I have so far that's not working. Thanks for your help! Code Snippet: 1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32:...

Posted to SQL Server 2005 (Forum) by microsoft on 06-01-2009

Page 1 of 1 (4 items)

Browse by Tags

SQL Cast using sp_xml_preparedocument

Problem: Copy a table schema from one database to another using T-SQL

Problem: Linked Server can't read/write MS Access Tables (Error Msg 7303)

Problem: IF STATEMENTS IN WHERE CLAUSE