Enterprise IT Virtual Event: Doing More IT With Less July 23rd Virtual Event: Economizing and Innovating in Today's Enterprise IT Organization Register Now
How can I output records/messages to a flat file from inside a SQL Server TSQL script/stored-procedure/trigger? Apr 18, 1999 A. A. SQL Server doesn't have a handy SPOOL command like Oracle does... How can I get random numbers from SQL Server? Using rand() I always get the same sequence. Apr 18, 1999 A. A. This is because you need to start the rand function off with a... How can I completely uninstall SQL Server? Apr 18, 1999 ... Why does my transaction-log fill up when I use fast-bcp? Apr 08, 1999 A. A. Fast BCP and select into do not log record updates. However they... How can I pad an integer value in SQL Server with zeroes? Apr 08, 1999 A. By converting to a string and padding that way. e.g. an example from pubs to pad a value :- select right(replicate('0',10)+ convert(varchar(10),ytd_sales),10) from titles How can I modify the SQL 7 unattended install script? Apr 07, 1999 A. Check out the following link for info http://technet.microsoft.com/cdonline/content/complete/boes/bo/SQL/Technote/sql7set Is there an Access upsizing wizard to SQL Server 7.0? - 08 Apr 1999 Apr 07, 1999 A. Yes, there is now one available at http://www.microsoft.com/AccessDev/ProdInfo/AUT97dat.htm Do I really need a 166Mhz Pentium processor to run SQL Server 7.0? Apr 07, 1999 A. No. But you DO need a 100% Intel pentium compatible chip - which... How can I transfer database diagrams from one SQL 7 server to another? Apr 07, 1999 A. Assuming you have identical databases and the dtproperties table... Why do I get the SQL Server error "Msg 8412 - Schemas differ" when doing a LOAD TABLE? Apr 06, 1999 A. If both tables have been defined identically the most common... Load More first previous … 1047 1048 1049 1050 1051 1052 1053 1054 1055 … next last Load More
How can I get random numbers from SQL Server? Using rand() I always get the same sequence. Apr 18, 1999 A. A. This is because you need to start the rand function off with a... How can I completely uninstall SQL Server? Apr 18, 1999 ... Why does my transaction-log fill up when I use fast-bcp? Apr 08, 1999 A. A. Fast BCP and select into do not log record updates. However they... How can I pad an integer value in SQL Server with zeroes? Apr 08, 1999 A. By converting to a string and padding that way. e.g. an example from pubs to pad a value :- select right(replicate('0',10)+ convert(varchar(10),ytd_sales),10) from titles How can I modify the SQL 7 unattended install script? Apr 07, 1999 A. Check out the following link for info http://technet.microsoft.com/cdonline/content/complete/boes/bo/SQL/Technote/sql7set Is there an Access upsizing wizard to SQL Server 7.0? - 08 Apr 1999 Apr 07, 1999 A. Yes, there is now one available at http://www.microsoft.com/AccessDev/ProdInfo/AUT97dat.htm Do I really need a 166Mhz Pentium processor to run SQL Server 7.0? Apr 07, 1999 A. No. But you DO need a 100% Intel pentium compatible chip - which... How can I transfer database diagrams from one SQL 7 server to another? Apr 07, 1999 A. Assuming you have identical databases and the dtproperties table... Why do I get the SQL Server error "Msg 8412 - Schemas differ" when doing a LOAD TABLE? Apr 06, 1999 A. If both tables have been defined identically the most common... Load More first previous … 1047 1048 1049 1050 1051 1052 1053 1054 1055 … next last Load More
How can I completely uninstall SQL Server? Apr 18, 1999 ... Why does my transaction-log fill up when I use fast-bcp? Apr 08, 1999 A. A. Fast BCP and select into do not log record updates. However they... How can I pad an integer value in SQL Server with zeroes? Apr 08, 1999 A. By converting to a string and padding that way. e.g. an example from pubs to pad a value :- select right(replicate('0',10)+ convert(varchar(10),ytd_sales),10) from titles How can I modify the SQL 7 unattended install script? Apr 07, 1999 A. Check out the following link for info http://technet.microsoft.com/cdonline/content/complete/boes/bo/SQL/Technote/sql7set Is there an Access upsizing wizard to SQL Server 7.0? - 08 Apr 1999 Apr 07, 1999 A. Yes, there is now one available at http://www.microsoft.com/AccessDev/ProdInfo/AUT97dat.htm Do I really need a 166Mhz Pentium processor to run SQL Server 7.0? Apr 07, 1999 A. No. But you DO need a 100% Intel pentium compatible chip - which... How can I transfer database diagrams from one SQL 7 server to another? Apr 07, 1999 A. Assuming you have identical databases and the dtproperties table... Why do I get the SQL Server error "Msg 8412 - Schemas differ" when doing a LOAD TABLE? Apr 06, 1999 A. If both tables have been defined identically the most common... Load More first previous … 1047 1048 1049 1050 1051 1052 1053 1054 1055 … next last Load More
Why does my transaction-log fill up when I use fast-bcp? Apr 08, 1999 A. A. Fast BCP and select into do not log record updates. However they... How can I pad an integer value in SQL Server with zeroes? Apr 08, 1999 A. By converting to a string and padding that way. e.g. an example from pubs to pad a value :- select right(replicate('0',10)+ convert(varchar(10),ytd_sales),10) from titles How can I modify the SQL 7 unattended install script? Apr 07, 1999 A. Check out the following link for info http://technet.microsoft.com/cdonline/content/complete/boes/bo/SQL/Technote/sql7set Is there an Access upsizing wizard to SQL Server 7.0? - 08 Apr 1999 Apr 07, 1999 A. Yes, there is now one available at http://www.microsoft.com/AccessDev/ProdInfo/AUT97dat.htm Do I really need a 166Mhz Pentium processor to run SQL Server 7.0? Apr 07, 1999 A. No. But you DO need a 100% Intel pentium compatible chip - which... How can I transfer database diagrams from one SQL 7 server to another? Apr 07, 1999 A. Assuming you have identical databases and the dtproperties table... Why do I get the SQL Server error "Msg 8412 - Schemas differ" when doing a LOAD TABLE? Apr 06, 1999 A. If both tables have been defined identically the most common... Load More first previous … 1047 1048 1049 1050 1051 1052 1053 1054 1055 … next last Load More
How can I pad an integer value in SQL Server with zeroes? Apr 08, 1999 A. By converting to a string and padding that way. e.g. an example from pubs to pad a value :- select right(replicate('0',10)+ convert(varchar(10),ytd_sales),10) from titles How can I modify the SQL 7 unattended install script? Apr 07, 1999 A. Check out the following link for info http://technet.microsoft.com/cdonline/content/complete/boes/bo/SQL/Technote/sql7set Is there an Access upsizing wizard to SQL Server 7.0? - 08 Apr 1999 Apr 07, 1999 A. Yes, there is now one available at http://www.microsoft.com/AccessDev/ProdInfo/AUT97dat.htm Do I really need a 166Mhz Pentium processor to run SQL Server 7.0? Apr 07, 1999 A. No. But you DO need a 100% Intel pentium compatible chip - which... How can I transfer database diagrams from one SQL 7 server to another? Apr 07, 1999 A. Assuming you have identical databases and the dtproperties table... Why do I get the SQL Server error "Msg 8412 - Schemas differ" when doing a LOAD TABLE? Apr 06, 1999 A. If both tables have been defined identically the most common... Load More first previous … 1047 1048 1049 1050 1051 1052 1053 1054 1055 … next last Load More
How can I modify the SQL 7 unattended install script? Apr 07, 1999 A. Check out the following link for info http://technet.microsoft.com/cdonline/content/complete/boes/bo/SQL/Technote/sql7set Is there an Access upsizing wizard to SQL Server 7.0? - 08 Apr 1999 Apr 07, 1999 A. Yes, there is now one available at http://www.microsoft.com/AccessDev/ProdInfo/AUT97dat.htm Do I really need a 166Mhz Pentium processor to run SQL Server 7.0? Apr 07, 1999 A. No. But you DO need a 100% Intel pentium compatible chip - which... How can I transfer database diagrams from one SQL 7 server to another? Apr 07, 1999 A. Assuming you have identical databases and the dtproperties table... Why do I get the SQL Server error "Msg 8412 - Schemas differ" when doing a LOAD TABLE? Apr 06, 1999 A. If both tables have been defined identically the most common... Load More first previous … 1047 1048 1049 1050 1051 1052 1053 1054 1055 … next last Load More
Is there an Access upsizing wizard to SQL Server 7.0? - 08 Apr 1999 Apr 07, 1999 A. Yes, there is now one available at http://www.microsoft.com/AccessDev/ProdInfo/AUT97dat.htm Do I really need a 166Mhz Pentium processor to run SQL Server 7.0? Apr 07, 1999 A. No. But you DO need a 100% Intel pentium compatible chip - which... How can I transfer database diagrams from one SQL 7 server to another? Apr 07, 1999 A. Assuming you have identical databases and the dtproperties table... Why do I get the SQL Server error "Msg 8412 - Schemas differ" when doing a LOAD TABLE? Apr 06, 1999 A. If both tables have been defined identically the most common... Load More first previous … 1047 1048 1049 1050 1051 1052 1053 1054 1055 … next last Load More
Do I really need a 166Mhz Pentium processor to run SQL Server 7.0? Apr 07, 1999 A. No. But you DO need a 100% Intel pentium compatible chip - which... How can I transfer database diagrams from one SQL 7 server to another? Apr 07, 1999 A. Assuming you have identical databases and the dtproperties table... Why do I get the SQL Server error "Msg 8412 - Schemas differ" when doing a LOAD TABLE? Apr 06, 1999 A. If both tables have been defined identically the most common... Load More first previous … 1047 1048 1049 1050 1051 1052 1053 1054 1055 … next last Load More
How can I transfer database diagrams from one SQL 7 server to another? Apr 07, 1999 A. Assuming you have identical databases and the dtproperties table... Why do I get the SQL Server error "Msg 8412 - Schemas differ" when doing a LOAD TABLE? Apr 06, 1999 A. If both tables have been defined identically the most common... Load More first previous … 1047 1048 1049 1050 1051 1052 1053 1054 1055 … next last Load More
Why do I get the SQL Server error "Msg 8412 - Schemas differ" when doing a LOAD TABLE? Apr 06, 1999 A. If both tables have been defined identically the most common... Load More first previous … 1047 1048 1049 1050 1051 1052 1053 1054 1055 … next last Load More
