Where Can I Get I Guide On Conventions For Naming
Jun 12, 2007Where can I get I guide on conventions for naming, stored procedures, tables, user functions ? that I can implement in my work
View 6 Replies
ADVERTISEMENT
Naming Conventions
Jan 31, 2005Most of the programming I do is in Access. I like to use naming conventions for all my tables, queries, etc. I am now moving several databases to SQL Server. Does anyone know of a good resource for naming convetions in SQL Server. Website, book?
View 2 Replies View RelatedNaming Conventions
Mar 8, 2006In our database tables are generated like
EMP_MASTER
DEPT_MASTER
like that. when we generate classes from database the class names are looking like
EmpMaster
DeptMaster
but for my classes that Master suffix is not required.
please solve my problem.
Thanks and Regards,
guru
Naming Conventions
May 3, 2007I'm coming from a MS Access background and so I'm very used to andcomfortable with the hungarian (Leszynski et al) naming conventions.However, I'm getting started into my first SQL Server Database andreally want to use the appropriate up to date standard namingconvention (ISO compliant).I think I have the general idea from raking though countlessconflicting sites and posts, but I'm a bit stuck on what to doregarding pk / fk namingFor example, in my MS Access world I would have two tables:tblOrders=======strOrderIDintCustomerIDdtOrderDate....tblCustomers==========intCustomerIDstrCustomerName....So what would the appropriate and most up-to-date and standard namingbe for SQL Server? My Guess:Orders=====Ord_Order_ID_PkOrd_Customer_ID_FkOrd_Order_Date....Customers========Cus_Customer_ID_PkCus_Customer_Name....How close (or far) am I from "Celko Proof" naming here?All help gratefully accepted!
View 9 Replies View RelatedSqlServer Naming Conventions
Nov 18, 2005I noticed that a lot of my stuff is getting named dbo.XXXXXXX. Why is it happening and what does this mean?
View 4 Replies View RelatedVariables In The Four Naming Conventions
Apr 27, 2006Hi
I am running SQL Server 2000 and have two different databases with different names on two different machines.
The servers (machines) are linked and I want to use a single set of stored procedures on both databases.
I want to know if and how I can use variables in the four naming conventions in a stored procedure. This way I do not have to write an if statement and rewrite the code for each database.
Example:
Select * from SERVER_A.DATABASE_1.dbo.CENSUS
Eventually, I want SERVER_A and DATABASE_1 to become the variables that will change depending on which database that is being requested.
Any help would be appreciated.
Procedure Naming Conventions
Oct 31, 2006Hi,
Can someone give me a quick explanation of the naming conventions used in naming a procedure. I am referring to the way procedures are name for the system procedures. Most of them start as dbo.sp_xxx. I assume that sp stands for system procedure?
The reason I ask is that the company that I'm currently working on a project for has things like dbo.pv_xxx for parameterized for, dbo.up_xxx for udpating, dbo.d_xxx for deleting rows ...etc. The 'xxx' is a wildcard, those are not the actual names. The documentation they have is poor and I'm trying to figure out how/why they name their procedures the way they do.
Does it look like they are following industry conventions? Is the format for the name something like (schema).(return value)_(Action)(Name of Table), ie: dbo.up_AddUser?
Thank you.
Naming Conventions For Stored Procedure
Feb 20, 2005Hi,
What are the naming conventions for Stored Procedures in Sql Server ??
Thanks,
Guide Me
Apr 23, 2008hi i m new to sql and learning sql server 2005 ..can any body please tell me which topics i have to cover to start with?please help
View 10 Replies View RelatedGuide Me
Oct 6, 2006can you guide me to write a query to get cumulative salary, like this
Ename Salary Cu_Sal
----- ------ -------
A 15000 15000
B 10000 25000
C 20000 45000
D 45000 90000
Do i need to use functions or can it be done by using a subquery.IF yes please explain
one more doubt.Is there a query to write a word in the reverse format.
for ex:SQL--->LQS
also on the same lines can we write a query to convert the case of the string like for ex:SeRVer---->sErvER
DBA Guide
Jul 20, 2005Any good SQLServer DBA guides available online? Preferablya downloadable pdf. Or online in HTML.Thank you.
View 1 Replies View RelatedCan Anyone Guide Me
Nov 23, 2005i'm very new to SQl server, even i know nothing about it, all what i know about is Ms Access, i want to ask that :-
View 5 Replies View RelatedGuide
Dec 28, 2006Hi!
I am a beginner doing ETL processes, searching for a step by step detailed guide. Actually I could not map the columns, getting errormessages, and moreover I need to add sql.
Where could I find a such a detailed guide?
Guide Needed For Vb.net
Feb 13, 2008 how to set values for parameter during run-time.
in query, we set
select * from user_alms where username=?
during run-time, we have to pass values to the username. how it has to be done using dataadapter.
my current coding is as follows:
dim Conn as new odbcconnection
dim strQuery as string
Conn = New OdbcConnection(connString)
strQuery = "select * from user_alms where username=?"
ODBCHelper.ExecuteDataset(Conn, CommandType.Text, strQuery, ds, 0, 0)
what i have to do, for pass parameter values to '?' during runtime
thanx in advance
DTS - Beginners Guide
Mar 22, 2001I have "played" with DTS packages but I am now trying to do the following in an ActiveX VB script
Open a connection to database/table <---- Can't find how to do this!
Read a record from the table
Alter the content based on some rules
Post the record back to the table
Simple eh? If anyone has any examples or can point me to a good source of examples.
Many Thanks.
Geoff.
Best Guide For Exam 70-229
Oct 25, 2007I've gone through the Microsoft press study material for Exam 70-229. It is okay but not really comprehensive. I'd appreciate any supporting book that deals with the exam topics inside out... And info on any site which offers good practise exams is also appreciated.
Thank you.
Installation Guide Please
Mar 20, 2008Dear All,
please provide me the complete installation guide links like
on which operating system, which version can install like that...
i've searched in google, but i'm not satisfied. please provide the link from experts side....
thank you very much
Vinod
Even you learn 1%, Learn it with 100% confidence.
Some Links Guide Datetime In Sql !
Feb 17, 2006I need some links which guide datetime in sql statement !!
Such as : I have a datetime column in my table , I need to calculate
the total orders in the today, or yesterday ...
Any one know ?
Thank you very much .
User Manuel/guide
Oct 18, 2007
Hi all,
Search for any samples or whatever help writing professional user Manuel for SSIS any suggest or help is Grateful thanks in advance
Can U Guide Me Writing A Simple Query
Jun 26, 2007I am trying to do following thing:i got a table which contains some words....all i need to do is whenever i see a word starting with 'R', i need to remove the starting 'R' and update it in the same table... could anyone help me out here.....thanks a lot in advance.........
View 2 Replies View RelatedWhat's The Best Study Guide Outhere To Pass 70-229
Jan 30, 2005hi guys,
what's the best book outthere that can help me to pass microsoft sql exam
70-229?
rgrds
Mosaad
Guide To Setup Database Mirroring
Feb 29, 2008Hello room,
I am newbie to Database mirroring.
I have 3 window server 2003 running in window virtual server 2005.
Server1 of sql 2005 instance:
-- SQLDev01
Server2 of sql 2005 instance:
-- SQLDev02
Serve3 of sql 2005 instance:
-- SQLDev03
The servers are running on DC and the sql servers was setup with Window authentication mode only.
Also, All the sql instances'services are running under single domain user name.
e.g: sqladmin.
I have tried to setup manually and t-sql and both running into some issues.
Can anyone help and share t-sript to setup database mirroring.?
Thanks for the help.
TJ
SQL 2005 Disaster Recovery Guide
Nov 22, 2006Hi All,
Does somebody know where can I find a guide or white paper regarding to the subject?
It should contain the procedures needed to recover Analisys, Reporting and Integration services as well.
Thanks,
Miska
New To SQL - Can Someone Send Me Towards A Good Guide? More Inside...
Jan 26, 2008
Hey forum...i'm a newbie to SQL, but not IT. However I'm or a network admin than a database admin...so this is completely new.
All i'm trying to do is setup one single database for my mail server to use for grey listing entries. it is using Access right now, and i want to setup a SQL Express database and DSN for it to use.
Does anyone have a good pointer for beginning SQL people?
THANKS!
SQL Server Express: Can Someone Provide The Guide MS Does Not?
Mar 30, 2007The overly complex MSDN library is proving virtually useless to me. To give you some background, I've programmed PHP / MYSQL websites, in-depth VBA programs for Excel and a bit of non-database work in various languages - I'm an amateur.
I've just bought a new PC (2g Ram, Core 2 Duo, Vista Home Basic) and would like to run Web Developer Exp, VB Exp and SQL Server 05 Exp.
Note. I have installed all three and run through Microsoft's video tutorial, until I hit a snag at the start of Tutorial 2. When try to create a new SQL Database in WebDev, an error saying either SQL Server is not installed or operating correctly (could Microsoft provide a more specific error or what????)
The questions Microsoft need to answer are:
1. What are the hardware requirements for SQL Server 05?
2. What are the operating system requirements for SQL Server 05?
3. What does IIS have to do with SQL Server 05?
4. How do you know if you meet the IIS requirements for running SQL Server 05?
5. Exactly what elements of SQL Server 05 are affected by different levels of IIS?
6. Can anti-virus or firewall software cause issues.
Please, some one from Microsoft respond.
Please Guide - Especially About Time Dimension And Approach In General
Mar 30, 2004Hi,
I have a table which contains all the transaction details for which I am trying to create a CUBE... The explanation below in brackets is only for clarity about each field. Kindly note that I am using the following table as my fact table. Let's call it tblFact
This table contains fields like transaction date, Product (which is sold), Product Family (to which the Product Belongs), Brand (of the product), Qty sold, Unit Price (at which each unit was sold), and some other fields.
I have created a Product dimension based on tblFact. I don't know if this is a good idea or not :confused: Is it okay and am I on the right track or should I base my Product Dimension on some other table (say tblProducts and then in the Cube editor link tblProducts with tblFact based on the ProductID field? Please guide.
Now coming to my last question:
Currently I am also creating my Time Dimension based on tblFact. Is this also a wrong approach?
1. Should I instead create the Time Dimension based on a different table (say tblTime) and again link up tblTime and tblFact in the Cube editor?
2. if yes, then how do I create tblTime from tblFact in a manner that it only contains all the transaction dates.
3. Assuming that I should take the tblTime approach, then should this table (tblTime) also contain the ProductID - representing the Product which was sold for each date in tblTime?
I realize that this is a lenghty post but reply and more importantly guidance from the experienced users will be greatly appreciated becuase I have recently started learning/playing around on the OLAP side of things and I know that this is the time that I get my foundations correct otherwise I'll end up getting used to some bad practice and will find it difficult to change my approach to cube designing later down the road.
So many thanks in advance and I eagerly look forward to reply from someone.
Data Conversion/Migration Tools/guide
Jun 11, 2008Please point me towards some good trusted (possibly economical) Data Conversion tools for converting legacy system SQL 2000 (XML, Image all data type) db data to SQL 2005 database (and possibly to Oracle too) in a totally different db schema/structure.
View 6 Replies View RelatedOracle Server Quick Reference Guide
May 29, 2006Oracle Server Quick Reference Guidehttp://quickdba.blogspot.com/2006/0...ence-guide.htmlVisit daily to get more updated articles
View 1 Replies View RelatedError 1418 And Good Basic Setup Guide
Jun 16, 2006Hi,
I'm new to DB Mirroring, and I am trying to get it going in a test enviroment between two SQL 2005 Dev Servers. I have followed documentation that I have found but cannot get past a 1418 error when establishing a connection between the servers initially. Does anyone know of any good step by step guides that I could look at, in case I have missed something stupid.
Thanks in advance
Stupots
SQL Server 2005 Integration Services Installation Guide
Sep 8, 2006Hi, all,
Thank you very much for your kind attention.
Would please any here give me any advices for where can I find the SQL Server 2005 Integration Services Installation Guide? The one I found online (http://msdn2.microsoft.com/en-us/library/ms143506.aspx) is just confused me, which is just about the installation of SQL Server 2005 different version.
Really need help for that.
With best regards,
Yours sincerely,
Urgent: Suggest The OLAP Service Installation Guide Source
Oct 22, 2001See topic
View 1 Replies View RelatedSQL Server 2008 :: White Spaces Not Getting Ignored For Plan Guide Matching?
May 1, 2015In sp_create_plan_guide documentation, it's written:
When SQL Server matches the value of statement_text to batch_text and @parameter_name data_type [,...n ], or if @type = 'OBJECT', to the text of the corresponding query inside object_name, the following string elements are not considered:
White space characters (tabs, spaces, carriage returns, or line feeds) inside the string.
Comments (-- or /* */).
Trailing semicolons
On SQL Server 2008 SP3, I created a plan guide for a query. Now, if I execute the query exactly how it was defined in the plan guide, SQL Server match it and use the plan guide to optimize the query.
However, if I add just a space between a column name and an operator in the WHERE clause, the plan guide is ignored. How come it doesn't ignore the extra space, like mentioned in the documentation?
FK Naming
Sep 28, 2007Hello, I have 2 tables: Articles and Users. These 2 tables are related by AuthorId (FK) in Articles and UserId (PK) in Users. My question is: should the use the same name for the 2 keys, i.e., UserId? Or it is normal to use AuthorId in Articles table and UserId in Users table. This makes more sense. Just a naming question. Thanks, Miguel
View 5 Replies View Related