tag:blogger.com,1999:blog-18730743.comments2024-02-24T21:55:43.157+01:00SQL TroublesAdrianhttp://www.blogger.com/profile/07612735744573114626noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-18730743.post-67172967321652878742018-07-13T16:11:08.729+02:002018-07-13T16:11:08.729+02:00Awesome!!! This was the best tip. This finally ena...Awesome!!! This was the best tip. This finally enabled FileStream.<br />ThanksSurajhttps://www.blogger.com/profile/16080394998011848523noreply@blogger.comtag:blogger.com,1999:blog-18730743.post-69535133818336704602017-04-22T09:12:47.094+02:002017-04-22T09:12:47.094+02:00ThanksThanksFusion Duniyahttps://www.blogger.com/profile/11932996248455972766noreply@blogger.comtag:blogger.com,1999:blog-18730743.post-63825044646272493912016-02-11T14:54:41.640+01:002016-02-11T14:54:41.640+01:00Just to let you know that starting from SQL Server...Just to let you know that starting from SQL Server 2012, it's possible to evaluate arithmetic expression in T-SQL with <a href="https://github.com/zzzprojects/Eval-SQL.NET" rel="nofollow">Eval SQL.NET</a> library<br /><br />DECLARE @table TABLE<br /> (<br /> Formula VARCHAR(50) ,<br /> X INT ,<br /> Y INT ,<br /> Z INT<br /> )<br /><br />INSERT INTO @table<br />ZZZ Projectshttps://www.blogger.com/profile/11204643800065030666noreply@blogger.comtag:blogger.com,1999:blog-18730743.post-67612080802733577052013-12-04T01:40:28.454+01:002013-12-04T01:40:28.454+01:00This is one of the best articles that gives someon...This is one of the best articles that gives someone an introduction into Data Migration I have ever seen. Great for beginners and also for advanced users who sometimes need to go back to the basics!Anonymoushttps://www.blogger.com/profile/06643528875968343254noreply@blogger.comtag:blogger.com,1999:blog-18730743.post-39758361021199135122012-10-23T16:59:37.242+02:002012-10-23T16:59:37.242+02:00Thanks, very helpfullThanks, very helpfullAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-18730743.post-38376554656763127602012-07-10T19:27:49.613+02:002012-07-10T19:27:49.613+02:00OPENQUERY Pasar Parametros Solucionado.
Hola Buen...OPENQUERY Pasar Parametros Solucionado.<br /><br />Hola Buen dia para pasar parametros en la clausula where solo hay que utilizar un ejemplo como este:<br /><br />SELECT Responsable,Empleado From OpenQuery(WEBURREA,'Select rr.Responsable As Responsable,Empleado From dhdbD..relacionempleadoresponsable rr')<b>Where Empleado=9321</b><br /><br />Por Carlos Ruiz de GuadalajaraCarlos Ruizhttps://www.blogger.com/profile/06033988389136610811noreply@blogger.comtag:blogger.com,1999:blog-18730743.post-30151023293850136312012-07-10T19:26:44.734+02:002012-07-10T19:26:44.734+02:00Hola Buen dia para pasar parametros en la clausula...Hola Buen dia para pasar parametros en la clausula where solo hay que utilizar un ejemplo como este<br />SELECT Responsable,Empleado From OpenQuery(WEBURREA,'Select rr.Responsable As Responsable,Empleado From dhdbD..relacionempleadoresponsable rr')<b>Where Empleado=@Empleado</b><br /><br />Donde @Empleado es tu variable a pasar.<br /><br />Por Carlos Ruiz de GuadalajaraCarlos Ruizhttps://www.blogger.com/profile/06033988389136610811noreply@blogger.comtag:blogger.com,1999:blog-18730743.post-87799839536384581462011-11-06T12:04:27.724+01:002011-11-06T12:04:27.724+01:00This is really gr8 stuff..
But when we want to do...This is really gr8 stuff..<br /><br />But when we want to do different configurations on different databases then this becomes bit difficult.<br /><br />Can any one please suggest good <a href="http://www.tools4sql.net>CRUD Stored Procedure Creator</a>?Nilesh Gambhavahttps://www.blogger.com/profile/01957127682901670519noreply@blogger.comtag:blogger.com,1999:blog-18730743.post-28762776469059365562011-06-30T09:08:04.070+02:002011-06-30T09:08:04.070+02:00You'll have to move the aggregation inside the...You'll have to move the aggregation inside the inline view. Something like:<br /><br />update testtable <br />SET tot_qty =itm.qty_A + itm.qty_B<br />, tot_qty_B = itm.qty_B<br />FROM ( -- inline view <br />SELECT itm.company_num<br />, sum(itm.qty_A) qty_A<br />, sum(itm.qty_B) qty_B<br />FROM testtable ITM <br />GROUP BY itm.company_num<br />) itm <br />where testtable.company_num = Adrianhttps://www.blogger.com/profile/07612735744573114626noreply@blogger.comtag:blogger.com,1999:blog-18730743.post-66344779089352321442011-06-30T07:32:45.494+02:002011-06-30T07:32:45.494+02:00thanks for the post.I just wondering how to apply ...thanks for the post.I just wondering how to apply this in group function update?Is it allowed in oracle ? see my sample update below, it throw me an error 'group function is not allowed'<br /><br />update testtable <br />SET tot_qty =itm.qty_A + sum(itm.qty_B) , tot_qty_B =sum(itm.qty_B)<br />FROM ( -- inline view <br /> SELECT * <br /> FROM testtable ITM <br /> ) itm <br />whereunidhttps://www.blogger.com/profile/09929503035044413506noreply@blogger.comtag:blogger.com,1999:blog-18730743.post-30514341960388444102011-02-16T16:23:52.392+01:002011-02-16T16:23:52.392+01:00You forgot to mention that Access can migrate to a...You forgot to mention that Access can migrate to a SQL Express database. As of the SQL 2008 R2 release, the database file size limit has gone to 10GB<br /><br />http://www.microsoft.com/express/Database/Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18730743.post-30516667043595122832011-02-15T08:06:17.658+01:002011-02-15T08:06:17.658+01:00Very Nice Resource for Web Developers. Thanks For ...Very Nice Resource for Web Developers. Thanks For your nice information.Excel Comparisonhttp://www.litera.com/products/change-pro_for_excel.htmlnoreply@blogger.comtag:blogger.com,1999:blog-18730743.post-74052127436235345662010-08-20T18:16:51.701+02:002010-08-20T18:16:51.701+02:00Sorry, I will have to resume in answering with the...Sorry, I will have to resume in answering with the typical "it depends". It depends on your requirements, what features or OS versions you are targeting, on the volume or particularities of your data, etc. Also in many cases, one of the drivers was not working as expected so my choices reduced considerably. If you want unicode support or any other type of newer Oracle features then Adrianhttps://www.blogger.com/profile/07612735744573114626noreply@blogger.comtag:blogger.com,1999:blog-18730743.post-24498503305974922512010-08-20T11:07:55.396+02:002010-08-20T11:07:55.396+02:00When downloading the instant client, there ar eman...When downloading the instant client, there ar emany options. Which is the preferred one for the ssis ole db driver?<br /><br />ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-18730743.post-53341216193449916842010-03-01T21:07:41.092+01:002010-03-01T21:07:41.092+01:00I think you have to install at least the SQL Serv...I think you have to install at least the SQL Server 2008 Express with Advanced Services or SQL Server 2008 trial version in order to have access to the SQL Server 2008 Sample Databases as the following prerequisites must be met: http://msftdbprodsamples.codeplex.com/wikipage?title=Database%20Prerequisites&referringTitle=Installing%20Databases<br /><br />As far I know the SQL Server 2008 Adrianhttps://www.blogger.com/profile/07612735744573114626noreply@blogger.comtag:blogger.com,1999:blog-18730743.post-18353791347955159732010-03-01T20:18:48.875+01:002010-03-01T20:18:48.875+01:00Hi there,
Can you tell me if it's possible to ...Hi there,<br />Can you tell me if it's possible to install AdventureWorks 2008 and then migrate/export all the DB with Oracle SQL Developer to a Oracle 11g DB?<br />I want to do a benchmark of Oracle11g and MSSQLServer2008 data mining tools, with the same DB schema and data.<br />What do you think about this?Unknownhttps://www.blogger.com/profile/06640111550667486197noreply@blogger.com