Re: Hello everyone, MS SQL roooookie here Community Center Say Hello! by Espinoza84 MS SQL which im guessing is VB? Re: Linked Server in Ms sql 2005 Programming Databases by tan3587 > SQL code my web layer is written in JSP that has java code embedded in it to connect to MS SQL Server. Thanks a lot for clearing my doubt!!1:) Re: sql - how to Programming Databases by hollystyles … say you were using Access, and as this is a MS SQL Forum I used TSQL. Ok just for you I have… recreated everything in Access and tweaked the SQL. Basically removed all formating, changed joins to INNER JOIN, added… Re: Sql??????? Programming Web Development by ~s.o.s~ …standard than a language. The Database packages which implement SQL are Oracle, MySQL, MS SQL Server 2005, etc. to name a few. … on your side if you knew the basics of SQL before attempting to tacke server side scripting languges like … case then you dont need to know SQL. [URL]http://www.w3schools.com/sql/default.asp[/URL] [URL]http://sqlcourse.… Re: sql server does not allow to remote connection. Programming Software Development by kvprajapati >sql server does not allow to remote connection. Post your connection …=dbfirst;User id=sa;Password=sa" [/code] Read about MS-Sql server authentication - [URL="http://msdn.microsoft.com/en-us…/library/aa905171(SQL.80).aspx"]http://msdn.microsoft.com/en-us/library… Re: SQL Development Community Center by virgilio MS Sql. Mostly my background is ETL related SSIS SSRS Data management. Data Cubes, DW. Currently I'm working for a BI team creating cube views, reports and stuff Re: How to Backup database - SQL Server 2000 Programming Databases by Geek-Master MS SQL DB Backups by default have the .BAK file extension. Table adapters - Is it necessary for linking or reference tables Programming Web Development by nzkks [MS SQL Server 2005, Visual Studio 2005, ASP.Net 2.0(with … brand table which is inter-related with many other tables. SQL generation code below. [CODE] /****** Object: Schema [Product] Script Date: 03… Row Number Programming Databases by Rpower MS SQL 5 vb.net asp.net I working on a new … Re: IF (SELECT blah = value) THEN Programming Databases by tesuji MS SQL server also supports if and case statements within select. Your … principle if-else (there is no "then") on MS SQL server should look like: [CODE] if (select only_one_column from your_table… Re: store coordinates Programming Databases by hericles MS SQL has two data types, geometry and geography, which are designed for holding that type of data. Define your columns using them. And read the docs, there's a lot more to it than just that. Re: Automatically filling a column of a database Programming Software Development by kvprajapati MS-SQL compact doesn't support computed column but you may use select statement which evaluates overdue value. [code=text] SELECT MemberID, DVDID, DaysOnRent,DateRented,DueDate, TotalPrice, CASE WHEN GETDATE() > DUEDATE THEN 0 ELSE 1 END AS OVERDUE FROM Rentals [/code] Re: ADO Connection String. Programming Software Development by kvprajapati MS-SQL server can operate in one of the two security modes: 1. Windows Authentication 2. Sql Server authentication Read more on this subject…;]http://msdn.microsoft.com/en-us/library/aa905171(SQL.80).aspx[/URL] For Ms-SQL Express edition, use Windows Authentication, [code=cplusplus] pConnection1… Re: 'There is already an object named 'ProductID' in the database.' Programming Databases by achied Ms. SQL Server treats constraint as an object. You can check it in sys.objects table. Re: retrieve data Programming Databases by hollystyles … to use for the following TSQL code. Sql 2000 Start->Programs->Ms Sql Server->Query Analyser File->Connect click… toolbar or press F5 key. For Sql 2005 Start -> programs -> Ms Sql Server 2005 -> Sql Server Managent Studio Click New Query… Re: Software for updating/improving MySQL database Programming Databases by pritaeas MS SQL Server Management is for Microsoft SQL, not MySQL. Re: oledb issue Programming Software Development by tendaimare ms sql 2005 MS SQL enterprise edition Programming Databases by judithSampathwa …studio 2008 standard edition and I am connecting to ms sql sever enterprise edition 2008 r2. When I depoy the…created and install inanother computer some components relating to ms sql server is being downloaded, I want to know …what are being downloaded. And is MS SQL server 2008 R2 client side application also free????? Appreciate… MS SQL import DB problem Programming Databases by feedz87 - I'm using ms sql and then i export the database and then … at desktop.After that i delete the database in ms sql because i want to learn how to import the …to give the tutorial how to import the DB into MS SQL. - This is the file of DB that i want… to import into ms sql : [url]http://dl.dropbox.com/u/5448200/WMS20110316[/… ms sql access Programming Databases by judithSampathwa hi there, i have a machine installed MS server 2008 and in that it has MS SQL express , how can i connect othe MS SQL express from another PC in the network what is the toll that i need to have appriciate a lot thanxxxx ms sql management studio login error Programming Databases by judithSampathwa … i log in to the server and connect to the ms sql server i can connect to the databases. but when i… login to another computer and try to login to the MS SQL server management studio i get an error message saying A… was issued by an authority that is not trusted.) (Microsoft SQL Server, Error: -2146893019) what is the solution for this MS SQL Library? Programming Software Development by Daneos … working on a programm and for that programm I need ms sql connection. Ive already googled much but I couldnt find what… someone know where I can get this. I need a ms-sql library(?) which I can put into my c++ programm and… MS SQL date time format Programming Databases by judithSampathwa …. i have two date times in a table in the MS SQL server database, when i write the query as below. the…/2010 12:00:00 AM it shows correct in the MS SQL business intelligent Development studio query builder by in the report… MS SQL Replication - multiple Schemas with same tables names Programming Databases by KirstyHunter …, I am trying to set up transactional replication on a MS SQL 2008 database that has two Schemas, both schemas have some… same name as a table in Schema A: [LIST=1] [*]SQL Server Management Studio could not create article 'Customer' Cannot create… ms sql column encryption Programming Databases by judithSampathwa Hi there, How can I use the “EncryptByPassphrase” for a table in ms sql server 2008 r2??? or if i can get a good tutorial appriciate a lot thanxxxx ms sql error sever stopped Programming Databases by judithSampathwa hi there, i was doing some changes to the ms sql reporting server and after some time i get an error … ms sql reporting server 2008 Programming Databases by judithSampathwa … admin privileges is this the cause for this. and from MS SQL management studio when i try to login to the reporting… MS SQL Connection to PHP Programming Web Development by Jerome_3 I have read from different forums, PHP website and Microsoft website how to connect PHP to MS SQL Server but the provided solutions didn't worked for me. If you could help me in this would be greatly appreciated. Re: MS SQL Connection to PHP Programming Web Development by Jerome_3 I use MS SQL Server 2005 Enterprise edition and PHP 5.4. How to Connect to online MS SQL database Programming Software Development by IntegrityWebDev … couple of years using ASP.NET online. I'm using MS Visual C# 2010 Express to play around and learn with… company I want to be able to connect to our MS SQL database and pull out info...but I dont want to… give me beginners pointers on how to connect to our MS SQL database in this manner? Thanks! Chris