Database

Thank you very much. I just needed a clarification for not under-estimating my decision over my superior. Thank you very much.

I'm using Oracle SQL Developer Data Modeler[^] ole.Grossklaus@gmx.de wrote: - reverse engineer to have a starting Point (Oracle 11 and MSSQL2008) to have all tables in this tool (on a hidden layer if possible Supports Oracle (duh), MSSQL and DB2. ole.Grossklaus@gmx.de wrote: - Select some tables and copy them (link) to a new layer to switch visibility depending on the development task that i want to give to a developer It's tab based, you can create a new view with a subset of existing tables. ole.Grossklaus@gmx.de wrote: - Display compact (square with table Name, and PKs only). Hide all other columns Yes ole.Grossklaus@gmx.de wrote: - a good way to arrange everything on Screen to avoid crossing Relations and to nicely arrange every table and relation Auto arrange sucks big donkey balls. But it does in all tools in my opinion. So it's up to you to do the work I'm afraid. ole.Grossklaus@gmx.de wrote: - toggle visibility of a layer It's tab based, and you can have one or more windows and move the tabs between them. ole.Grossklaus@gmx.de wrote: - a certain table appears on more than one layer depending on the development tasks A table can appear in many windows/views, not sure if this is what you mean. ole.Grossklaus@gmx.de wrote: - something that makes it all "nice" to present to the Boss. Use Powerpoint. :) ole.Grossklaus@gmx.de wrote: - crow feet Notation Barker notation - check Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln

Thanks! :)

Yeah it didnt work. However I realised that this script didnt have any code to create tables so I used a different script with "CREATE TABLE" code in the query and it worked! thanks

See if it helps: Copy Table With Data From One Database to Another in SQL Server 2012[^] Sandeep Mewara Microsoft ASP.NET MVP 2012 & 2013 [My Blog]: Sandeep Mewara's Tech Journal! [My Latest Article]: HTML5 Quick Start Web Application

This could be an odd question, but, you tried Quote: SELECT * From Foo WHERE Type = 'Sales Tax ([%])' Cause, when your using '=' command, means that is HAS to be egual.

As Jörgen Andersson said, cte is faster cause there's no IO on disk, it's just memory. when you declare an #Temporary, you really create the table on your tempdb, that means that you have to write on disk. For a long range of information, you can say that is not that fast as use an cte. If i'm not wrong, declare an variable ( Declare @Table Table (column) ) is faster as use an CTE , and less complicate, cause just create the table on Memory. BUT, you got to remember, that this will only use memory, for a long range of information, this mean that will use a lot of ram.

Karthik_J, Coimbatore wrote: Microsoft SQL Server 2012 introduces 14 new built-in functions. And you posted this to demonstrate that you can read documentation maybe?

And we can use of it form programming (dataset dt=new,....) and from toolbox in the visual studio,right?

You should use Where Clause at End of Statement Like SELECT * FROM dbo.OutputPromptItem JOIN dbo.OutputPrompt ON dbo.OutputPromptItem.PromptId=dbo.OutputPrompt.Promp WHERE SegmentId=7198

//for each row of gridview CheckBox chk; for (int i = 0; i< GridView1.Rows.Count; i++) { chk = (CheckBox)GridView1.Rows[i].Cells[chechboxcolumnIndexInterger].FindControl("checkboxID"); }

I'd go for the PowerShell option mentioned here[^]. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

I would have agreed, but I created a new database on the SQL server. I went to a client machine to connect, and once again, the new database does not show in the list. I get the SQL list with master and such. Truly, this is really bothersome. It is almost as if there is a "scope" problem. Could the GPO affect this? It is an Admin of the domain, but what was given to me was that this admin account has full access. I would think to differ only because ... SQL installs with a local machine admin yes? Creator/Owner does have special permissions by default on 2008 ... would any portion of this effect the DATA folder where the database has been relocated for attachment? Lastly, I will try using nonintegrated methods and consider troubleshooting ID values as well per Mycroft Holmes' post.

searching for solution..... wrote: I cannot ask the user to remove empty line at EOF. Then you'll have to write something that removes that line for the user. As the example, I'd expect it to be invalid, as an empty row would consist of field-separators and a row-separator. Like this: 1,abc 2,xyz , An empty line does not equal an empty row. It equals a row without fields. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

MS Access might do that but I seriously doubt SQL Server does. If it is null in the database then a null is returned to .Net. No manner of casting/manipulation at that point in time is going to change that to something that isn't a null.

Thank you. I got through it, and yes, the trick was to remove " before the first --user...